java通过ODBC连接sqlserver 代码
import java.sql.*;
public class DBConnectionManager {
//数据源配置名为"test";
static final String url = "JDBC:ODBC:test";
public Connection con = null;
//装载数据库
public DBConnectionManager()throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
//建立数据库连接
public Connection getConnection()throws Exception{
con = DriverManager.getConnection(url);
return con;
}
//关闭数据库连接
public void closeConnection(Connection con){
try{
if(con!=null){
con.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
public void closepreparedStatement(PreparedStatement prepstment){
try{
if(prepstment!=null){
prepstment.close();
}
}catch(Exception e){
e.printStackTrace();
}
}public void closeResultSet(ResultSet rs){
try{
if(rs!=null){
rs.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}