数据库课程设计_实验室系统管理_链接数据库

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();}}}