学生管理系统50331.docVIP

package management; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBConnection { private static final String DBDRIVER = com.mysql.jdbc.Driver ; //驱动类类名 private static final String DBURL = jdbc:mysql://localhost:3306/jdbc; //连接URL private static final String DBUSER = root ; //数据库用户名 private static final String DBPASSWORD = admin; //数据库密码 static //将加载驱动放到静态块中 { try { Class.forName(DBDRIVER); //加载驱动 } catch (ClassNotFoundException e1) //发生加载驱动异常 { System.out.println(加载驱动失败); } } public static Connection getConnection() { Connection conn=null; //建立Connection接口引用 try { conn=DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD); //建立连接 } catch (SQLException e) //发生连接异常 { System.out.println(发生连接异常); } return conn; } public static void close(Connection conn) { if(conn!=null) //判断Connection对象是否为空 { try { conn.close(); //关闭连接数据库资源 } catch (SQLException e) //判断关闭Connection对象时是否发生异常 { System.out.println(关闭数据库连接发生异常); } } } public static void close(Statement stmt) { if(stmt!=null) //判断Statement对象是否为空 { try { stmt.close(); //关闭操作数据库资源 } catch (SQLException e) //判断关闭Statement对象时是否发生异常 { System.out.println(关闭数据库操作资源发生异常); } } } public static void close(ResultSet rs) { if(rs!=null) //判断结果集是否为空 { try { rs.close(); //关闭结果集 } catch (SQLException e) //判断结果集是否发生异常 { System.out.println(关闭结果集发生异常); } } } } ***************************************************************** package management; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class IDUS { static Connection conn=null; static { conn=DBConnection.getConnection(); //进