java连接sqlserver jar_java连接sqlserver时需要的jar包

给你个例子试试看

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;