www.pudn.com > RFID_98798798698698.rar > TUserDAO.java

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; 
	} 
}