JDBC连接sybase数据库

利用熟了hibernate连接数据库，现在要用到jdbc来连接，感觉怪怪的，不过工作需要啊，不得不熟悉一下^^

首先定义一个工具类Conn，用来连接sybase数据库

 

/*
  * 获取JDBC连接，得到Connection对象
  */
     public static Connection getConnection(){
              String Driver = "com.sybase.jdbc3.jdbc.SybDriver";  //这里要特别注意，驱动有的网上给的是错误的
              String url = "jdbc:sybase:Tds:192.168.2.103:5000/ext"; // 连接的数据库是ext
              String Userid = "sa";
              String Password = "";
              Connection conn = null;

 

             try {
                     Class.forName(Driver);
                     conn = DriverManager.getConnection(url, Userid, Password);
             } catch (Exception e) {
                     e.printStackTrace();
             }
            return conn;
     }

再来定义一个可以处理我们请求的类：

            public List<Users> selectAll(){                                 //查询数据库中users表中所有的记录
  
                   PreparedStatement ps = null;
                   ResultSet rs = null;
  
                  List<Users> userList = new ArrayList<Users>();
                  Connection conn = Conn.getConnection();                  //得到Connection对象
                  String sql = "select * from users";

                  try {
                          ps = conn.prepareStatement(sql);
                          rs = ps.executeQuery();
                         while(rs.next()){
                                   Users user = new Users();
                                   user.setId(rs.getString("id"));
                                   user.setName(rs.getString("name"));
                                   user.setAge(rs.getInt("age"));
                                   userList.add(user);
                            }
   
                  } catch (SQLException e) {
                          e.printStackTrace();
                  } finally{
                             try {
                                    if(rs!=null){
                                            rs.close();
                                    }
                                   if(ps!=null){
                                             ps.close();
                                    }
                                   if(conn!=null){
                                             conn.close();
                                    }
                            } catch (SQLException e) {
                                   e.printStackTrace();
                            }
                   }
                   return userList;
            }

 

 

在业务层就可以调用此类中的方法来查询users表中的所有的记录啦！！！^^