一、创建一个类编写数据库连接及关闭方法、加入类名MyDBManager
//SQL数据库引擎
private String JDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//数据源注意IP地址和端口号,数据库名字
private String URL= "jdbc:sqlserver://localhost:1433;DatabaseName=数据库名";
public Connection getConDB(){
Connection con = null;
try {
Class.forName(JDriver);
//连接数据库
con = DriverManager.getConnection(URL,"登陆用户名","登陆数据库密码");} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
//关闭连接,关闭命令对象链接和数据库
public void closeAll(Connection con,PreparedStatement ps,ResultSet rs){try {
if(con!=null){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
二、在创建一个类继承上面的类
假如子类为TestCon
public static void main(String[] args) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
con = new MyDBManager1().getConDB();
ps = con.prepareStatement("select *from userinfo");
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getInt("uid")+"\t"+rs.getString("uname"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
new MyDBManager1().closeAll(con, ps, rs);
}
}
即可访问数据库信息