?? dbutil.java
字號:
package com.witbridge.netstore.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
private static Connection conn;
public DBUtil(){
}
public static DBUtil getIstance(){
return new DBUtil();
}
public Connection getConn() throws SQLException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/netstore","root","root");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public Connection getConn(boolean actocommit) throws SQLException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/netstore","root","root");
conn.setAutoCommit(actocommit);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void commit(Connection conn) throws SQLException{
if(conn!=null&&!conn.isClosed()){
conn.commit();
}
}
public static void rollback(Connection conn) throws SQLException{
if(conn!=null&&!conn.isClosed()){
conn.rollback();
}
}
public static void release() throws SQLException{
if(conn!=null&&!conn.isClosed()){
conn.close();
}
}
public static void release(Statement st) throws SQLException{
st.close();
conn.close();
}
public static void release(PreparedStatement pt) throws SQLException{
pt.close();
conn.close();
}
public static void release(Statement st,ResultSet rs) throws SQLException{
rs.close();
st.close();
conn.close();
}
public static void release(PreparedStatement pt,ResultSet rs) throws SQLException{
rs.close();
pt.close();
conn.close();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -