recorddao.java~6~

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

package server.dao;

import java.sql.*;
import server.dao.Connectionmanager;
import server.entity.User;

public class Recorddao {

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

    //增加一条借出记录
    public boolean cdout()
    {
        //初始化变量
        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;}
    }

}