authorize.java

来自「JAVA编程思想源代码 值得一下 很难找的」· Java 代码 · 共 52 行

package chapter10.util;

import java.sql.*;

import chapter10.util.DBManager;

/**
 * @author panglina
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class Authorize {
	
	private  Statement stat;
	private ResultSet res;
	String quote="\"";
	
	public  boolean isAuth(String username,String password)
	{
		boolean isAuth=false;
		
		DBManager dbM=new DBManager();
		stat=dbM.getStatement();
		String sqlString="select password from auth where username="+quote+username+quote;
		
		try {
			res=stat.executeQuery(sqlString);
			while (res.next())
			{
				if(password.equals(res.getString(1)))
					isAuth=true;
				}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return isAuth;
		
	}

	public static void main(String[] args) {
		
		Authorize auth=new Authorize();
		boolean is=auth.isAuth("panglina","panglina");
		System.out.println(is);
		
	}
}