systemusersdaoimpl.java

swing+jdbc+sqlserver2000的小型网吧系统

package org.itstar.netbar.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.itstar.netbar.utils.ConnectDB;
import org.itstar.netbar.bean.SystemUsersBean;
import org.itstar.netbar.dao.ISystemUsersDao;


public class SystemUsersDaoImpl implements ISystemUsersDao
{
	public SystemUsersBean delete(String sysUsername) {
		// TODO 自动生成方法存根
		return null;
	}
	public SystemUsersBean insert(SystemUsersBean suBean) {
		// TODO 自动生成方法存根
		return null;
	}
	public List query(Map map) 
	{
		String strSQL;
		Statement stmt=null;
		strSQL="select * from systemUsers where 1=1";
		
		if(map.get("sysUsername")!=null)
			strSQL=strSQL+" and sysUsername='"+map.get("sysUsername")+"'";
		if(map.get("sysPassword")!=null)
			strSQL=strSQL+" and sysPassword='"+map.get("sysPassword")+"'";
//			System.out.println(strSQL);
//			System.exit(0);
		ResultSet rs=null;
		List list=new ArrayList();
		try {
			stmt=ConnectDB.getConn().createStatement();
			rs=stmt.executeQuery(strSQL);
			while(rs.next())
			{
				SystemUsersBean suBean=new SystemUsersBean();
				suBean.setSysUsername(rs.getString(1));
				suBean.setSysPassword(rs.getString(2));
				list.add(suBean);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	
	public List queryAll()
	{
		String strSQL;
		Statement stmt=null;
		strSQL="select * from systemUsers";
		ResultSet rs=null;
		List list=new ArrayList();
		try {
			stmt=ConnectDB.getConn().createStatement();
			rs=stmt.executeQuery(strSQL);
			while(rs.next())
			{
				SystemUsersBean suBean=new SystemUsersBean();
				suBean.setSysUsername(rs.getString(1));
				suBean.setSysPassword(rs.getString(2));
				list.add(suBean);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	public SystemUsersBean update(SystemUsersBean suBean) {
		// TODO 自动生成方法存根
		return null;
	}
	
	

}