userdao.java

使用JSP+Servlet+Ajax的供应商管理系统（不包含数据库部分）

package com.aowin.scm.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.aowin.scm.model.User;
import com.aowin.scm.util.DBConnection;



public class UserDAO {
    private DBConnection dbConn = new DBConnection();

    public boolean check(String name,String password) {
    	boolean flag = false;
        String sql = "select * from scmuser where Name='" + name+ "' and Password='" + password + "'";
        ResultSet rs = dbConn.executeQuery(sql);
        try {
			while(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
        dbConn.close();
        return flag;
    }
}