80e009493ef7001d17c382fc5cbc284e

java做的客房查询系统、 仅供初学者参考！

package DBUtil;
import java.sql.*;

public class DBAccess {
	public Connection getConnection() {
		Connection con=null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=Hotel","sa","");
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		catch(java.lang.ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
		return con;
	}
	public void close(Connection con) {
		try {
			if(con != null) {
				con.close();
		    }
		}
		catch(java.sql.SQLException sqle) {
			sqle.printStackTrace();
		}
		
		
	}

}