tuserdao.java

jsp网页

package com.rfid.dao;

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

import com.rfid.global.DbUtil;

public class TUserDAO {
	public int validate(String username , String password) {
		int result = 0;
		
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		String sqlStr = "select * from t_user where username='"
						+ username + "' and password='" + password + "'";
		
		try {
			stmt = conn.prepareStatement(sqlStr);
			rs = stmt.executeQuery();
			rs.last();
			
			if(rs.getRow() > 0){
				result = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return result;
	}
}