code/src/com/dao/DB.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dao;

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

import com.model.HibernateSessionFactory;

public class DB
{
	private Connection con;

	private PreparedStatement pstm;
	private String className = "com.mysql.jdbc.Driver";
 
	private String url = HibernateSessionFactory.getConfiguration().getProperties().getProperty("connection.url");
	private String user = HibernateSessionFactory.getConfiguration().getProperties().getProperty("connection.username");
	private String password = HibernateSessionFactory.getConfiguration().getProperties().getProperty("connection.password");
	
    private Connection conn=null;
    private Statement stmt=null;
    ResultSet rs=null;
    
	public DB()
	{
		try
		{
			Class.forName(className);
		} catch (ClassNotFoundException e)
		{
			System.out.println("加载数据库驱动失败！");
			e.printStackTrace();
		}
	}

	/** 创建数据库连接 */
	public Connection getCon()
	{
		try
		{
			con = DriverManager.getConnection(url, user, password);
		} catch (SQLException e)
		{
			System.out.println("创建数据库连接失败！");
			con = null;
			e.printStackTrace();
		}
		return con;
	}
	
	
	  public ResultSet executeQuery(String sql)
	    {
	        rs=null;
	        try
	        {
	        	getCon();