check.java

实现了基本的增删改查和分页功能很简单的但是挺不错的适合初学者

package org.demo.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.demo.dbutil.DBConn;

public class Check {
    public static boolean checkUser(String username,String password){
    	DBConn dbconn=new DBConn();
    	boolean flag=false;
    	String strSQL="select password from users where username='"+username+"'";
    	ResultSet rs=dbconn.execQuery(strSQL);
    	try {
			if(rs.next()){
				if(password.equals(rs.getString(1))){
					flag = true;
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
    }
    public static void main(String[] args) {
		System.out.println( Check.checkUser("alvin", "123"));
	}
}