userbo.java

来自「是一个在线通讯录！很好的」· Java 代码 · 共 40 行

package operation;
import common.DBConnnection;
import entity.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserBo {
	private static Connection con=DBConnnection.getConnection();
	private static PreparedStatement pst;
	private static ResultSet result;
	private Users users;
	public boolean validUser(String userName,String password)
	{
		boolean vali=false;
		String sql="select * from USERS where userName=? and password=?";
		try {
			pst=con.prepareStatement(sql);
			pst.setString(1, userName);
			pst.setString(2, password);
			result=pst.executeQuery();
			while(result.next())
			{
				users.setUserName(result.getString("userName"));
				users.setPassWord(result.getString("password"));
			}
			if(users!=null)
			{
				vali=true;
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return vali;
	}
}