logindao.java

网上订餐系统

package com.newer.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.newer.bean.loginBean;

public class loginDao {
	public loginBean getloginInfoByName(String loginName){
		loginBean lb=new loginBean();
		Connection conn=ctxUtil.getConn();
		PreparedStatement pstmt=null;
		String sql="select * from login where userName=?";
		try {
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, loginName);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				lb.setUserID(rs.getInt(1));
				lb.setUserName(rs.getString(2));
				lb.setUserPass(rs.getString(3));
				
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			return null;
			//e.printStackTrace();
			
		}
		return lb;
		
	}

}