给你个例子试试看
Connection conn = null;
//连接数据库的URL
String jdbcDriver = "net.sourceforge.jtds.jdbc.Driver";
String jdbcUrl = "jdbc:jtds:sqlserver://localhost:1433;DatabaseName=FeiCui";
try{
//加载驱动
Class.forName(jdbcDriver);
conn = DriverManager.getConnection(jdbcUrl, userName, password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){}
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException(e);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
try{
if (rs != null) {
rs.close();
rs = null;
}
if (countRs != null) {
countRs.close();
countRs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}catch(SQLException e1){
e1.printStackTrace();
throw new RuntimeException(e1);
}
}
return items;