loginoperation.java

该源代码实现了系统的进货

package operation;

import java.sql.ResultSet;

import dataBase.DataBase;

public class LoginOperation
{
	public LoginOperation()
	{
		db = new DataBase();
	}
	
	// 登录查询，看用户输入的用户名密码是否存在数据库中
	public String Check(String userID,String password)
	{
		sql = "select * from EmployeeInfo where EmployeeName = '"+userID+"' and Password = '"+password+"'";
		rs = db.getResult(sql);
		try
		{
			if(rs.next())
			{
				employeeClass = rs.getString("employeeClass");
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return employeeClass;
	}
	//	关闭连接
	public void close()
	{
		db.close();
	}
	private DataBase db = null;
	private String sql = "";
	private ResultSet rs = null;
	private String employeeClass = "";
}