package cn.jack.bean;

import cn.jack.form.LoginForm;
import cn.jack.tool.DBConnection;
import cn.jack.tool.MD5;

import java.sql.*;

public class LoginBean {
DBConnection DBConn = new DBConnection();
MD5 md5 = new MD5();

public boolean  login(LoginForm lf){
	Connection Conn = DBConn.getConn();
	Statement stmt = null;
	ResultSet rs = null;
	String userpass = lf.getUserpass();
	userpass= md5.getMD5ofStr(userpass);
	String sql="select * from Manager where username='" + lf.getUsername() + "' and userpass='" + userpass + "'";
	try
	{
		stmt = Conn.createStatement();
		rs = stmt.executeQuery(sql);
		if(rs.next()){
			return false;
		}
		Conn.close();
		rs.close();
		stmt.close();
	}catch(Exception e){}
	return true;
}
}