stateinfodao.java

一个仿造淘宝的jsp网站。功能比较完善

package com.jc.taobao.gjj.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.jc.taobao.gjj.db.DBManager;
import com.jc.taobao.gjj.entity.StateInfo;

public class StateInfoDAO{
	DBManager dm = new DBManager();

	public int delete(Integer id) {
		String sql="delete from stateinfo where stateid="+id;
		return dm.updb(sql);
	}

	public int merge(StateInfo si) {
		String sql="update stateinfo set statename='"+si.getStatename()+"'";
		return dm.updb(sql);
	}

	public int save(StateInfo si) {
		String sql = "insert into stateinfo values('" 
				+ si.getStatename() + "')";
		return dm.updb(sql);
	}
	
	private List<StateInfo> query(String sql)//查询 
	{
		List<StateInfo> list = new ArrayList<StateInfo>();
		ResultSet rs = dm.getRs(sql);
		try {
			while(rs.next())
			{
				StateInfo state = new StateInfo();
				state.setStateid(rs.getInt("stateid"));
				state.setStatename(rs.getString("statename"));
				list.add(state);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	
	public List<StateInfo> queryALL()//查询所有状态信息
	{
		String sql="select * from stateinfo";
		return query(sql);
	}
	
	public List<StateInfo> querybystateid(StateInfo state)
	{
		String sql="select * from stateinfo where stateid="+state.getStateid();
		return query(sql);
		
	}
	public List<StateInfo> querybystatename(String statename)
	{
		String sql="select * from stateinfo where statename='"+statename+"'";
		return query(sql);
		
	}
	
	public ArrayList queryAllStatename()
	{
		ArrayList al=new ArrayList();
		String sql="select statename from stateinfo";
		try {
			ResultSet rs=dm.getRs(sql);
			while(rs.next())
			{
				al.add(rs.getString("statename"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return al;
	}

}