db_conn.java

精通Jsp-Web开发技术与典型应用 源码

package ch16.JavaBean;

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

public class DB_Conn {

	private String driverName = "com.mysql.jdbc.Driver"; // 驱动程序名

	private String userName = "root"; // 数据库用户名

	private String userPwd = "123456"; // 密码

	private String dbName = "netshop"; // 数据库名

	private String url = "jdbc:mysql://localhost/" + dbName + "?user="
			+ userName + "&password=" + userPwd
			+ "&useUnicode=true&characterEncoding=gb2312"; // 连接字符串

	private Connection conn = null; // 数据库连接对象

	public Statement sm = null; // 数据库语句对象

	private PrintWriter out = null;

	// 建立数据库连接
	public void ConnectDB() {
		try {
			Class.forName(driverName).newInstance();
			conn = DriverManager.getConnection(url); // 获得数据库连接
			sm = conn.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
			out.print("数据库连接失败!");
		}
	}

	public void CloseDB() {
		try {
			if (sm != null) {
				sm.close();
			}
			conn.close();
		} catch (SQLException SqlE) {
			SqlE.printStackTrace();
			out.print("数据库关闭失败！");
		}

	}
}