hyjydao.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 55 行

/**
 * @author 郑文金
 *这个类定义的是 会员建议的数据库访问对象
 * 
 * 
 */
package javabean;
import java.sql.*;
public class Hyjydao 
{
	public Connection con=null;
	private ResultSet rs;
	private ConnectionPool pool;
	public Hyjydao() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
		con=pool.getConnection();  //从池中获得一个连接	
	}
	public ResultSet executeQuery(String s)
	{
		try
		{		   
			Statement statement = con.createStatement();
			rs = statement.executeQuery(s);
			//con.close();
		}
		catch(SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return rs;
	}
	
	public String  update(String s)
	{
		String msg;
		try
		{
			
			Statement sql = con.createStatement();
			sql.executeUpdate(s);
			msg="success";
			//con.close();
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
			msg="failure";
		}
		return msg;
	}
	

}