modeinfodao.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.ModeInfo;

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

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

	public  int merge(ModeInfo mi) {
		String sql = "update modeinfo set modelname='" + mi.getModelname()
				+ "' where modeid=" + mi.getModeid();
		return dm.updb(sql);
	}

	public int save(ModeInfo mi) {
		String sql = "insert into modeinfo values('" 
				+ mi.getModelname() + "')";
		return dm.updb(sql);
	}
	
	public int saveajax(String modelname)// 利用ajax技术添加模块 
	{
		String sql = "insert into modeinfo values('" 
			+ modelname + "')";
		return dm.updb(sql);
	}
	public int ismodename(String modelname)
	{
		int modecount=0;
		String sql="select count(modeid) as modecount from modeinfo where modelname='"+modelname+"'";
		try {
			ResultSet rs=dm.getRs(sql);
			while(rs.next())
			{
				modecount=rs.getInt("modecount");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return modecount;
	}
	
	private List<ModeInfo> query(String sql)//查询
	{
		List<ModeInfo> list = new ArrayList<ModeInfo>();
		ResultSet rs = dm.getRs(sql);
		try {
			while(rs.next())
			{
				ModeInfo mode = new ModeInfo();
				mode.setModeid(rs.getInt("modeid"));
				mode.setModelname(rs.getString("modelname"));
				list.add(mode);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List<ModeInfo> querybyALL()//查询所有模块信息
	{
		String sql="select * from modeinfo";
		return query(sql);
	}
	
	public int queryModeCount()//查询模块的个数
	{
		int modecount=0;
		String sql="select count(modeid) as modecount from modeinfo";
		try {
			ResultSet rs=dm.getRs(sql);
			while(rs.next())
			{
				modecount=rs.getInt("modecount");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return modecount;
	}
	
	public List<ModeInfo> querybymodeid(Integer modeid)//根据模块编号查询模块信息
	{
		String sql="select * from modeinfo where modeid="+modeid;
		return query(sql);
	}
	
	public List<ModeInfo> querybymodename(String modename)//根据模块名称查询模块信息
	{
		String sql="select * from modeinfo where modelname='"+modename+"'";
		return query(sql);
	}
	
	public List<ModeInfo> querySuijiMode()//随机抽出5个模块
	{
		String sql="select top 6 * from modeinfo order by newid()";
		return query(sql);
	}

}