userdao.java

来自「简单的信息录入系统 大家可以在这个基础上将其完善 是对初学者的有力帮助」· Java 代码 · 共 23 行

package mvcdemo;
import java.sql.*;
import com.sun.rowset.*;
import javax.sql.rowset.CachedRowSet;
public class UserDAO {
    public UserDAO(){}
    public static boolean select(User user){
        boolean result = false;
        String sql = "select * from userTbl where uname='%s' and upassword='%s'";
        sql = String.format(sql,new String[]{user.getName(),user.getPassword()});
        DAOHelper dh = new DAOHelper();
        try {
            CachedRowSet crs = dh.query(sql);
            if (crs.next()) {
                result = true;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return result;
    }
}