package database;

import java.sql.*; //完成環(huán)境設(shè)置，導(dǎo)入java.sql包

public class Database {
 public Database() {
 }
// declare variable
 private Connection conn = null;
 private ResultSet rs = null;
 private String server = "127.0.0.1"; // Can't use localhost , you
            // must use IP or CNAME
 private String port = "3306"; // change to your port
 private String db = "hotel"; // change to your db name
 private String user = "root"; // change to your username
 private String pass = "root"; // change to your password
 private String drivername = "org.gjt.mm.mysql.Driver"; // mysql driver
 private String URL = "jdbc:mysql://" + server + ":" + port + "/" + db
   + "?useUnicode=true&characterEncoding=utf-8&user=" + user
   + "&password=" + pass;


 public Connection getConn() { // get database connection
  try {
   Class.forName(drivername).newInstance(); // 載入驅(qū)動(dòng)器
   conn = DriverManager.getConnection(URL); // 連接到數(shù)據(jù)庫(kù)
  } catch (Exception e) {
   e.printStackTrace();
  }
  return conn;
 }


 public ResultSet executeSQL(String str) {
  try {
   Statement stmt = conn.createStatement(); // 語(yǔ)句接口
   rs = stmt.executeQuery(str); // 獲得結(jié)果集
  } catch (Exception e) {
   e.printStackTrace();
  }
  return rs;
 }
 
}