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

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