userdao.java

来自「struts+Spring+Hibernate经典入门源码」· Java 代码 · 共 41 行

package com.softeem.login.model;

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

public class UserDAO {

	/**
	 * @param args
	 */
	private Connection con;
	private PreparedStatement ps;
	private ResultSet rs;
	public UserDAO(Connection con) {
		this.con = con;
	}
	
	public boolean validLogin(UserDTO dto){
		try {
			ps = con.prepareStatement("select * from tb_user where username=? and password=?");
			ps.setString(1,dto.getUsername());
			ps.setString(2,dto.getPassword());
			rs = ps.executeQuery();
			if(rs.next()){
				return true;
			}
			
		} catch (SQLException e) {
			return false;
		}
		
		
		return false;
		
	}
	

}