一个简单的jdbc

************************************************************************************************************

public class JdbcUtil {

 
 //第一种方法： private String url = "jdbc:mysql://localhost:3306/day17";
 private static String url = "jdbc:mysql:///day17";//第二种方法
 private static String user = "root";
 private static String password = "root";
 
 //写成静态方法，用类名.getConnection()获取该连接对象
 public static Connection getConnection() {
  try {
   Class.forName("com.mysql.jdbc.Driver");
   return DriverManager.getConnection(url, user, password);
  } catch (Exception e) {
   throw new RuntimeException(e);
  }
 }

 /**
  * 关闭
  * 关闭原则：后开先关
  */
 public static void closeAll(Connection con, Statement stmt, ResultSet rs) {
  try {
   if (rs != null) {
    rs.close(); 
    rs = null;   // 建议释放资源
   }
   if (stmt != null) {
    stmt.close();
    stmt = null;
   }
   if (con != null && !con.isClosed()) {
    con.close();
    con = null;
   }
  } catch (SQLException e) {
   throw new RuntimeException(e);
  }
 }
}