paramaccess.java

Athena酒店小组_Athena酒店管理系统

/*
 * ParamAccess.java
 *
 * Created on 2007年5月23日, 下午4:54
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package athena;

import java.sql.*;
import java.util.*;
import plugin.*;

/**
 *
 * @author Virlene Cheng
 */
public class ParamAccess
{
    private IDBResource dbRes;
    
    /** Creates a new instance of ParamAccess */
    public ParamAccess(IDBResource dbRes)
    {
	this.dbRes = dbRes;
    }
    
    public int insert(ParamInfo paramInfo)
    {
	//TODO insert
	return -1;
    }
    
    public int update(ParamInfo paramInfo)
    {
	//TODO update
	return -1;
    }
    
    public int delete(ParamInfo paramInfo)
    {
	//TODO delete
	return -1;
    }
    
    public String getParamById(Integer paramId)
    {
	//TODO getParamById
	return null;
    }
    
    public ArrayList<ParamInfo> getParamsByName(String paramName)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM ParamInfo WHERE ParamName = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, paramName);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<ParamInfo> params = new ArrayList<ParamInfo>();
	    readData(params, rs);
	    return params;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}
    }
    
    public int addParam(String paramName, String paramValue)
    {
	return insert(new ParamInfo(paramName, paramValue));
    }
    
    
    private void readData(ArrayList<ParamInfo> params, ResultSet rs) throws SQLException
    {
	while(rs.next())
	{
	    ParamInfo param = new ParamInfo();
	    param.setParamId(rs.getInt("ParamId"));
	    param.setParamName(rs.getString("ParamName"));
	    param.setParamValue(rs.getString("ParamValue"));
	    params.add(param);
	}
    }
    
    
    
    
    
    
    
}