JAVA知识点——JDBC
private static final String URL=
“jdbc:sqlserver://localhost:1433;databaseName=mySchool”;
private static final String USERNAME=“sa”;
private static final String PASSWORD=“sa”;
获取驱动
static {
try {
Class.forName(DRIVER_CLASS);
System.out.println(“获取驱动成功了!”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
链接数据库 java.sql.Connection
public Connection getConnection() throws SQLException{
Connection conn=null;
conn=DriverManager.getConnection(URL, UERNAME, PASSWORD);
return conn;
}
关闭数据库
public void close(Connection conn, Statement stmt, ResultSet rst) {
if(rst!=null) {
try {
rst.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
rst=null;
}
}
if(stmt!=null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
stmt=null;
}
}
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
conn=null;
}
}
}