cddao.java~1~

来自「我做的第一个java MIS项目」· JAVA~1~ 代码 · 共 55 行

package server.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import server.entity.User;
import java.sql.SQLException;
import server.entity.Card;

public class Cddao {

    private Connection con = null;
    private Connectionmanager cm=null;
    private PreparedStatement ps = null;
    private ResultSet rs = null;

    //检验检查客户借碟数量
    public boolean chk(Card card)
    {
        //初始化变量
        String testusername=user.getusername();
        String testuserpwd=user.getuserpwd();
        String dbusername=null;
        String dbuserpwd=null;
        //创建一个连接并得到查询结果
        cm =new Connectionmanager();
        con= cm.getconnection();
        try
        {
            ps = con.prepareStatement("select * from [user] where username='" +user.getusername() + "'");
            rs=ps.executeQuery();
            while(rs.next())
            {
                dbusername=rs.getString(1);
                dbuserpwd=rs.getString(2);
            }
        }
        catch (SQLException ex) {return false;}
        //断开数据连接
        finally
        {
            cm.closeresultset(rs);
            cm.closestatement(ps);
            cm.closeconnection(con);
        }

        //判断并返回判断值
        if (dbusername.equals(user.getusername())&& dbuserpwd.equals(user.getuserpwd()) )
        {return true;}
        else
        {return false;}
    }

}