JDBC

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseDao {

	// 首先明确连库时需要的可变信息
	// 连库驱动类
	private final String DRVIER_CLASS = "com.mysql.jdbc.Driver";
	// 连库字符串
	private final String URL = "jdbc:mysql://localhost:3306/test5_4";
	// 用户名和密码
	private final String USER_NAME = "root";
	private final String PASSWORD = "admin";

	// 声明连库时需要用到的对象
	protected Connection conn;
	protected PreparedStatement pt;
	protected ResultSet res;

	public Connection getConn() {

		try {
			Class.forName(DRVIER_CLASS);
			conn = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;

	}

	public void close() {

		try {
			if (res != null)
				res.close();
			if (pt != null)
				pt.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}