db_conn.java

通过JSP技术实现商品房产的查询与购买

package ch14.JavaBean;

import java.io.PrintWriter;
import java.sql.*;

public class DB_Conn {
	
	private  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";      //驱动程序名
	private  String userName="LiuYu";                         //数据库用户名
	private  String userPwd="123";                        //密码
    private  String url="jdbc:sqlserver://HP-46A3C071D140:1433;Databaseame=House";//连接字符串
    private  Connection conn=null;                          //数据库连接对象
    public Statement sm;                               //数据库语句对象
    private PrintWriter out = null;
    
    // 建立数据库连接
    public void ConnectDB() throws SQLException{
    	 try {
    		 Class.forName(driverName).newInstance();
        	 conn=DriverManager.getConnection(url,userName,userPwd);  //获得数据库连接
        	 sm=conn.createStatement();
         } catch(Exception e) {
    		 e.printStackTrace();		 
        	 out.print("数据库连接失败!");
    	 }
    }
    
    public void CloseDB() throws SQLException{
    	try {
			if (sm != null) {
				sm.close();
			}
			conn.close();
		} catch (SQLException SqlE) {
			SqlE.printStackTrace();
			out.print("数据库关闭失败！");
		}
    
   }
}