dbhelper.java

Eclips3.2 + mysql5.5 用Struts2编写的图书管理系统

package com.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * 
 * 数据库连接类
 *
 */
public class DBHelper {
	private String driver = "org.gjt.mm.mysql.Driver";
	private String url = "jdbc:mysql://localhost:3306/peng";
	private String user = "root";
	private String pwd = "peng";
	
	public Connection getConn(){
		Connection conn = null;
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, pwd);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	public static void main(String[] args) {
		System.out.println("DBHelper.main()" + new DBHelper().getConn());
	}
}