?? connectionfactory.java
字號:
package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ConnectionFactory {
public static Connection conn = null;
private static String driver = "com.mysql.jdbc.Driver";
private static String url;
private static String userName = "root";
private static String password = "";
public static Connection getConnection() {
try {
Class.forName(driver);
url = "jdbc:mysql://127.0.0.1:3306/student";
conn = DriverManager.getConnection(url, userName, password);// 建立連接
} catch (Exception e) {
System.out.println(e.getMessage());
}
return conn;
}
public static void close(Statement st, Connection con) {
close(st);
close(con);
}
public static void close(ResultSet rs, Statement st) {
close(rs);
close(st);
}
public static void close(ResultSet rs) {
try {
rs.close();
} catch (Exception e) {
}
}
public static void close(Statement st) {
try {
st.close();
} catch (Exception e) {
}
}
public static void close(Connection con) {
try {
con.close();
} catch (Exception e) {
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -