userdao.java

jsp书店cnn来看是绝对法律框架是独立房间是东方

package com.csthit.store.dao;

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

import com.csthit.store.db.DB;
import com.csthit.store.vo.User;

public class UserDAO {

	public boolean getValidate(User user) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		
		try {
			conn = DB.getConn();
			String sql = "select * from userinfo where loginname=? and password=?";
			pstmt = DB.getPstmt(conn, sql);
			pstmt.setString(1, user.getLoginName());
			pstmt.setString(2, user.getPassword());
			rs = pstmt.executeQuery();
			
			if(rs.next()) {
				return true;
			} else {
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		} finally {
			try {
				DB.close(rs);
				DB.close(pstmt);
				DB.close(conn);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	
}