?? database.java
字號(hào):
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;
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -