userdao.java

来自「jsp/serlvet/javaBean:订餐系统」· Java 代码 · 共 55 行

package dao;

import java.sql.*;

import bean.*;

/**
 * 用户数据层
 * @author dell
 *
 */
public class UserDao {
	
	BaseDao bdao=new BaseDao();
	Connection conn=null;
	PreparedStatement psmt=null;
	ResultSet rest=null;
	String sql=null;
	int i;
	
	//用户注册
	public int addUser(UserBean ubean){
		try{
			sql="insert into userInfo values(?,?)"; 
			String[] param={ubean.getLoginName(),ubean.getLoginPass()};
			i=bdao.executeDB(sql, param);
		}catch(Exception sex){
			sex.printStackTrace();
			System.out.println(sex.getMessage());
		}
		return i;
	}
	
	//用户登录
	public int userLogin(UserBean ubean){
		try{
			conn=bdao.getConn();
			sql="select * from userInfo where loginName=? and loginPass=?";
			psmt=conn.prepareStatement(sql);
			psmt.setString(1, ubean.getLoginName());
			psmt.setString(2, ubean.getLoginPass());
			rest=psmt.executeQuery();
			if(rest.next()){
				i=1;
			}else{
				i=0;
			}
		}catch(SQLException sex){
			sex.printStackTrace();
			System.out.println(sex.getMessage());
		}
		return i;
	}
}