JDBC的数据库连接使用完之后需要关闭,以节约资源。按jdbc标准,ResultSet, Statement, Connection都要close()。
private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=学生管理系统";
private static final String NAME = "sa";
private static final String PASSWORD = "199601";
private static final String NAME = "sa";
private static final String PASSWORD = "199601";
private Connection conn;
private PreparedStatement stmt;
private PreparedStatement stmt;
void f(){
conn = DriverManager.getConnection(URL, NAME, PASSWORD);
stmt = conn.createStatement();
ResultSet rset = ...;
rset.close();
stmt.close();
conn.close();
}