logindao.java

来自「宠物医院 JSP项目 我是一个初学者 请大家多多指教」· Java 代码 · 共 37 行

package da0;
import java.sql.*;
import da0.*;

public class Logindao {
    PreparedStatement ps = null;
    ResultSet rs = null;
    Connection con = null;
    public Logindao() {
    }
    public boolean DengLu(String name,String pass){
        boolean flag = false;
          DBcon dbcon = new DBcon();
        try {

            con= dbcon.GetConnection();
            String str = "select * from employee where ename=? and epassword =?";
            ps = con.prepareStatement(str);
            ps.setString(1,name);
            ps.setString(2,pass);
            rs = ps.executeQuery();
            if(rs.next()){
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        finally{
            dbcon.CloseRs(rs);
            dbcon.ClosePs(ps);
            dbcon.CloseCon(con);
        }
        return flag;
    }

}