java银行管理系统功能模块_java swing银行管理系统,java实现的毕业设计

package com.bank.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import com.bank.model.Customer;

public class CusVerifyDao {

/**

*

* @param con

* @param operator

* @return

* @throws Exception

*/

public Customer login(Connection con,Customer customer)throws Exception{

Customer resultUser=null;

String sql="select * from customer where cuAccount=? and cuPassword=?";

PreparedStatement pstmt=con.prepareStatement(sql);

pstmt.setString(1, customer.getCuAccount());

pstmt.setString(2, customer.getCuPassword());

ResultSet rs=pstmt.executeQuery();

if(rs.next()){

resultUser=new Customer();

resultUser.setId(rs.getString("id"));

resultUser.setCuName(rs.getString("cuName"));

resultUser.setCuPassword(rs.getString("cuPassword"));

resultUser.setCuIDCard(rs.getString("cuIDCard"));

resultUser.setCuAccount(rs.getString("cuAccount"));

resultUser.setCuPhone(rs.getString("cuPhone"));

resultUser.setCuAddress(rs.getString("cuAddress"));

}

return resultUser;

}

/**

*

* @param con

* @param operator

* @return

* @throws Exception

*/

public Customer traVerify(Connection con,String cuAccount)throws Exception{

Customer resultUser=null;

String sql="select cuPassword from customer where cuAccount=?";

PreparedStatement pstmt=con.prepareStatement(sql);

pstmt.setString(1, cuAccount);

ResultSet rs=pstmt.executeQuery();

if(rs.next()){

resultUser=new Customer();

resultUser.setCuPassword(rs.getString("cuPassword"));

}

return resultUser;

}

}