package labor;
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 DBConnection {
Connection conn=null;
Statement st=null;
ResultSet rs=null;
public DBConnection(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;DatabaseName=labor";
String user="sa";
String password="sa";
conn=DriverManager.getConnection(url,user,password);
st=conn.createStatement();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public int executeUpdate(String sqlUpdate) throws SQLException{
int ret=-1;
ret=st.executeUpdate(sqlUpdate);
return ret;
}
public ResultSet executeQuery(String sqlSelect) throws SQLException{
rs=st.executeQuery(sqlSelect);
return rs;
}
public Connection getConnection(){
return conn;
}
public void setConnection(boolean autoCommit) throws SQLException{
conn.setAutoCommit(autoCommit);
}
public void Commit() throws SQLException{
conn.commit();
}
public void RollBack() throws SQLException{
conn.rollback();
}
public void close(){
if(rs!=null)
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
if(st!=null)
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
数据库课程设计_实验室系统管理_链接数据库
最新推荐文章于 2022-08-30 17:17:38 发布