package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class UserUtil {
 // 建立数据库的链接

 public Connection getConn() throws Exception {
  String Driver = "com.mysql.jdbc.Driver"; // 驱动程序
  String URL = "jdbc:mysql://localhost:3306/zydb"; // 连接的URL,ccb为数据库名
  String Username = "root"; // 用户名
  String Password = "123456"; // 密码
  Class.forName(Driver).newInstance();
  Connection conn = DriverManager.getConnection(URL, Username, Password);
  // Statement statement = conn.createStatement();
  return conn;
 }

 public void closeConn(Connection conn) throws SQLException {
  conn.close();
 }

 public Statement getStatement() throws Exception {// 该方法用法主要负责用来获取执行Sql语句对象

  Connection c = getConn();
  Statement st = c.createStatement();// 该语句用来创建执行sql语句对象
  return st;
 }
 
 public ResultSet executeQuery(String sql){//如果该Sql语句是查询语句，即select,则返回ResultSet对象(结果集对象)
  ResultSet set=null;
  try{
   Statement s = getStatement();
   set = s.executeQuery(sql);//该语句通过委托执行sql语句对象来执行select语句,并返回结果集对象
  }catch(Exception ex){
   ex.printStackTrace();
  }
  return set;
 }

}