JDBC学习笔记

JDBC 分层开发（day1 银行系统的搭建）

---

---

JDBC分层开发

1.创建数据库信息

-- ----------------------------
-- 银行管理员表
-- ----------------------------
DROP TABLE IF EXISTS `bankmanager`;
CREATE TABLE `bankmanager` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `mname` varchar(20) NOT NULL,
  `mpass` varchar(20) NOT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- 添加数据
-- ----------------------------
INSERT INTO `bankmanager` VALUES ('1', 'admin', 'admin');

-- ----------------------------
-- 银行卡信息表
-- ----------------------------
DROP TABLE IF EXISTS `bankcard`;
CREATE TABLE `bankcard` (
  `cid` bigint(11) NOT NULL AUTO_INCREMENT,
  `cpassword` int(6) NOT NULL,
  `cmoney` double(9,0) NOT NULL,
  `ctype` varchar(10) NOT NULL,
  `uid` int(11) NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=1000006 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- 添加数据
-- ----------------------------
INSERT INTO `bankcard` VALUES ('1000001', '123456', '56000', '储蓄卡', '1');
INSERT INTO `bankcard` VALUES ('1000002', '654321', '8520', '储蓄卡', '2');
INSERT INTO `bankcard` VALUES ('1000003', '135790', '456452', '储蓄卡', '3');
INSERT INTO `bankcard` VALUES ('1000004', '147258', '1200', '信用卡', '2');
INSERT INTO `bankcard` VALUES ('1000005', '258369', '56123', '储蓄卡', '4');
-- ----------------------------
-- 用户信息表
-- ----------------------------
DROP TABLE IF EXISTS `bankuser`;
CREATE TABLE `bankuser` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(20) NOT NULL,
  `uphone` int(11) NOT NULL,
  `company` varchar(30) DEFAULT NULL,
  `hometown` varchar(30) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- 添加数据
-- ----------------------------
INSERT INTO `bankuser` VALUES ('1', 'xx', '1854012935', '毛氏集团', '四川南充新生村');
INSERT INTO `bankuser` VALUES ('2', 'xxx', '1852453012', '毛氏集团保安部', '辽宁锦州小柳村');
INSERT INTO `bankuser` VALUES ('3', 'xx', '1362493209', '甲骨文', '内蒙赤峰冯庄');
INSERT INTO `bankuser` VALUES ('4', 'xx', '1365689213', '字节跳动', '浙江台州下盘村');

2.创建项目并且分层

​ 项目结构

​ src

​ com.lxk.bean 实体类

​ com.lxk.controller 控制层：接收请求并且处理

​ com.lxk.service 业务层的接口

​ com.lxk.service.impl 业务层: 处理请求的业务以及事务的处理

​ com.lxk.dao 持久化层的接口

​ com.lxk.dao.impl 持久化层：操作数据库

调用的顺序:controller层接收请求，然后调用service层完成业务的处理，service层调用Dao来完成数据库操作。

3.编写代码

​ 项目结构

给项目导入jar包
Mysql8.0及以上的JDBC jar包下载
1.在项目文件新建名为lib的文件夹


2.把下载好的jar包复制并粘贴在lib文件夹中


3.右键jar包配置路径

主要代码：

实体类

BankCard.java

package com.yy.bean;

/**   
 * @ClassName:  BankCard   
 * @Description:银行卡实体类 
 * @author: 
 * @date:   2021年5月10日 下午1:17:09      
 * @Copyright:  
 */
public class BankCard {
	private long cid;
	private int cpssword;
	private double cmoney;
	private String ctype;
	private BankUser bankuser;
	
	@Override
	public String toString() {
		return this.cid+"\t\t"+this.cpssword+"\t\t"+this.cmoney+"\t\t"+this.ctype+"\t\t"
				 +this.bankuser.getUid()+"\t\t"+this.bankuser.getUname()+"\t\t"+this.bankuser.getUphone()+"\t\t"+this.bankuser.getCompany()+"\t\t"+this.bankuser.getHometown();
	}
	public BankUser getBankuser() {
		return bankuser;
	}
	public void setBankuser(BankUser bankuser) {
		this.bankuser = bankuser;
	}
	public long getCid() {
		return cid;
	}
	public void setCid(long cid) {
		this.cid = cid;
	}
	public int getCpssword() {
		return cpssword;
	}
	public void setCpssword(int cpssword) {
		this.cpssword = cpssword;
	}
	public double getCmoney() {
		return cmoney;
	}
	public void setCmoney(double cmoney) {
		this.cmoney = cmoney;
	}
	public String getCtype() {
		return ctype;
	}
	public void setCtype(String ctype) {
		this.ctype = ctype;
	}
	
	
	
	
}

BankManager.java

package com.yy.bean;

/**   
 * @ClassName:  BankManager   
 * @Description:银行账户管理员实体类 
 * @author: 
 * @date:   2021年5月10日 下午12:11:41      
 * @Copyright:  
 */
public class BankManager {
	private int mid;
	private String mname;
	private String mpass;
	
	public int getMid() {
		return mid;
	}
	public void setMid(int mid) {
		this.mid = mid;
	}
	public String getMname() {
		return mname;
	}
	public void setMname(String mname) {
		this.mname = mname;
	}
	public String getMpass() {
		return mpass;
	}
	public void setMpass(String mpass) {
		this.mpass = mpass;
	}
	
	
}

BankUser.java

package com.yy.bean;

/**   
 * @ClassName:  BankUser   
 * @Description:用户实体类
 * @author: 
 * @date:   2021年5月10日 下午4:18:14      
 * @Copyright:  
 */
public class BankUser {
	private int uid;
	private String uname;
	private int uphone;
	private String company;
	private String hometown;
	public String getHometown() {
		return hometown;
	}
	public void setHometown(String hometown) {
		this.hometown = hometown;
	}
	public int getUid() {
		return uid;
	}
	public void setUid(int uid) {
		this.uid = uid;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public int getUphone() {
		return uphone;
	}
	public void setUphone(int uphone) {
		this.uphone = uphone;
	}
	public String getCompany() {
		return company;
	}
	public void setCompany(String company) {
		this.company = company;
	}
	@Override
	public String toString() {
		return  uid+"\t\t"+uname+"\t\t"+uphone+"\t\t"+company+"\t\t"+hometown;
	}
	
	
}

控制层

BankController.java

package com.yy.controller;

import java.util.List;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;
import com.yy.service.BankService;
import com.yy.service.impl.BankServiceImpl;

/**   
 * @ClassName:  BankController   
 * @Description:控制层
 * @author:
 * @date:   2021年5月10日 下午12:17:37      
 * @Copyright:  
 */
public class BankController {
	BankService bankservice=new BankServiceImpl();
	//管理员登录功能
	public String ManagerLogin(BankManager bm) {
		return bankservice.ManagerLogin(bm);//得到管理员账户名
	}
	
	public boolean CardLogin(BankCard bc) {
		return bankservice.CardLogin(bc);//获得是否存在的标志
	}
	
	public List<BankCard> showAllBankCardInfo(){//查看所有的银行卡信息
		return bankservice.showAllBankCardInfo();
	}
	public List<BankCard> showBankCardInfobyphone(int userphone){//通过手机号查询银行卡信息
		return bankservice.showBankCardInfobyphone(userphone);
	}
	public List<BankUser> showAllBankUserInfo(){//查看所有用户信息
		return bankservice.showAllBankUserInfo();
		
	}
 	
	
	public boolean Finduserbyphone(BankUser bu) {//在添加用户信息之前先查询表中是否有该用户
		return bankservice.Finduserbyphone(bu);
	}
	
	public boolean adduserInfo(BankUser bu) {//添加用户信息
		return bankservice.adduserInfo(bu);
	}
	
	public boolean addcardInfo(BankCard bc){//添加银行卡信息
		return bankservice.addcardInfo(bc);
		
	}
	
	public boolean FindBankcardbycid(Long cid) {//查询是否有这个卡号的银行卡
		return bankservice.FindBankcardbycid(cid);
	}
	public boolean updatecardpwd(Long cid,int npwd) {//修改银行卡密码
		return bankservice.updatecardpwd(cid, npwd);
	}
	public boolean deletecardbycid(Long cid) {
		return bankservice.deletecardbycid(cid);
		
	}
}

业务层接口

BankService.java

package com.yy.service;

import java.util.List;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;

/**   
 * @ClassName:  BankService   
 * @Description:业务层的接口 
 * @author: 
 * @date:   2021年5月10日 下午3:58:49      
 * @Copyright:  
 */
public interface BankService {
	public String ManagerLogin(BankManager bm);
	public boolean CardLogin(BankCard bc);
	public List<BankCard> showAllBankCardInfo();
	public List<BankCard> showBankCardInfobyphone(int userphone);
	public boolean Finduserbyphone(BankUser bu);
	public boolean adduserInfo(BankUser bu);
	public List<BankUser> showAllBankUserInfo();
	public boolean addcardInfo(BankCard bc);
	public boolean FindBankcardbycid(Long cid);
	public boolean updatecardpwd(Long cid,int npwd);
	public boolean deletecardbycid(Long cid);
}

业务层

BankServiceImpl.java

package com.yy.service.impl;

import java.util.List;

import javax.print.attribute.standard.MediaSize.NA;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;
import com.yy.dao.BankDao;
import com.yy.dao.impl.BankDaoImpl;
import com.yy.service.BankService;

/**   
 * @ClassName:  BankServiceImpl   
 * @Description:处理请求的业务以及事务的处理   
 * @author: 
 * @date:   2021年5月10日 下午3:59:18      
 * @Copyright:  
 */
public class BankServiceImpl implements BankService{
	BankDao bankdao=new BankDaoImpl();
	@Override
	public String ManagerLogin(BankManager bm) {
		return bankdao.ManagerLogin(bm);
	}
	//如果查询返回值是1则说明查询到此人，返回是0则说明未查询到此人
	@Override
	public boolean CardLogin(BankCard bc) {
		int flag=bankdao.CardLogin(bc);
		if(flag>0)
			return true;
		return false;
	}
	@Override
	public List<BankCard> showAllBankCardInfo() {
		
		return bankdao.showAllBankCardInfo();
	}
	@Override
	public List<BankCard> showBankCardInfobyphone(int userphone) {
		
		return bankdao.showBankCardInfobyphone(userphone);
	}
	@Override
	public boolean Finduserbyphone(BankUser bu) {
		if(bankdao.Finduserbyphone(bu)>0)
			return true;
		return false;
		
	}
	@Override
	public boolean adduserInfo(BankUser bu) {
		if(bankdao.adduserInfo(bu)>0) 
			return true;
		return false;
	}
	@Override
	public List<BankUser> showAllBankUserInfo() {
		return bankdao.showAllBankUserInfo();
	}
	@Override
	public boolean addcardInfo(BankCard bc) {
		if(bankdao.addcardInfo(bc)>0) 
			return true;
		return false;
	}
	@Override
	public boolean FindBankcardbycid(Long cid) {
		if(bankdao.FindBankcardbycid(cid)>0)
			return true;
		return false;
	}
	@Override
	public boolean updatecardpwd(Long cid,int npwd) {
		if(bankdao.updatecardpwd(cid, npwd)>0) 
			return true;
		return false;
	}
	@Override
	public boolean deletecardbycid(Long cid) {
		if(bankdao.deletecardbycid(cid)>0) 
			return true;
		return false;
	}
	
}

持久化层接口

BankDao.java

package com.yy.dao;

import java.util.List;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;

/**   
 * @ClassName:  BankDao   
 * @Description:持久化层接口
 * @author: 
 * @date:   2021年5月10日 下午3:57:03      
 * @Copyright:  
 */
public interface BankDao {
	public String ManagerLogin(BankManager bm);
	public int CardLogin(BankCard bc);
	public List<BankCard> showAllBankCardInfo();
	public List<BankCard> showBankCardInfobyphone(int userphone);
	public int Finduserbyphone(BankUser bu);
	public int adduserInfo(BankUser bu);
	public List<BankUser> showAllBankUserInfo();
	public int addcardInfo(BankCard bc);
	public int FindBankcardbycid(Long cid);
	public int updatecardpwd(Long cid,int npwd);
	public int deletecardbycid(Long cid);
}

持久化层

BankDaoImpl.java

package com.yy.dao.impl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.net.ssl.HostnameVerifier;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;
import com.yy.dao.BankDao;

/**   
 * @ClassName:  BankDaoImpl   
 * @Description:数据库操作   
 * @author: 
 * @date:   2021年5月10日 下午3:58:04      
 * @Copyright:  
 */
public class BankDaoImpl implements BankDao{
	//查询管理员的账户名
	@Override
	public String ManagerLogin(BankManager bm) {
		Connection conn=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		String mname="";
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select mname from bankmanager where mname=? and mpass=?";
			ps = conn.prepareStatement(sql);
			ps.setString(1, bm.getMname());
			ps.setString(2, bm.getMpass());
			rs=ps.executeQuery();
			while(rs.next()) {
				mname=rs.getString("mname");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return mname;
	}
	//查询是否有这个银行账户，用于登录
	@Override
	public int CardLogin(BankCard bc) {
		Connection conn=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select count(*) from bankcard where cid=? and cpassword=?";
			ps = conn.prepareStatement(sql);
			ps.setLong(1, bc.getCid());
			ps.setInt(2,bc.getCpssword());
			rs=ps.executeQuery();
			while(rs.next()) {
				flag=rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return flag;
	}
	@Override
	//查询银行卡所有信息
	public List<BankCard> showAllBankCardInfo() {
		Connection conn=null;
		Statement stat=null;
		ResultSet rs=null;
		List<BankCard> list=new ArrayList<BankCard>();
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select bc.*,bu.uname,bu.uphone,bu.company,bu.hometown from bankcard bc,bankuser bu where bc.uid=bu.uid";
			stat= conn.createStatement();
			rs=stat.executeQuery(sql);
			while(rs.next()) {
				BankCard bc=new BankCard();
				BankUser bu=new BankUser();
				bc.setBankuser(bu);
				bc.setCid(rs.getLong("cid"));
				bc.setCpssword(rs.getInt("cpassword"));
				bc.setCmoney(rs.getDouble("cmoney"));
				bc.setCtype(rs.getString("ctype"));
				bc.getBankuser().setUid(rs.getInt("uid"));
				bc.getBankuser().setUname(rs.getString("uname"));
				bc.getBankuser().setUphone(rs.getInt("uphone"));
				bc.getBankuser().setCompany(rs.getString("company"));
				bc.getBankuser().setHometown(rs.getString("hometown"));
				list.add(bc);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(stat!=null) {
				try {
					stat.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return list;
	}
	@Override
	//通过手机号查询银行卡信息
	public List<BankCard> showBankCardInfobyphone(int userphone) {
		Connection conn=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		List<BankCard> list=new ArrayList<BankCard>();
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select bc.*,bu.uname,bu.uphone,bu.company,bu.hometown from bankcard bc,bankuser bu where bc.uid=bu.uid and bu.uphone=?";
			ps= conn.prepareStatement(sql);
			ps.setInt(1, userphone);
			rs=ps.executeQuery();
			while(rs.next()) {
				BankCard bc=new BankCard();
				BankUser bu=new BankUser();
				bc.setBankuser(bu);
				bc.setCid(rs.getLong("cid"));
				bc.setCpssword(rs.getInt("cpassword"));
				bc.setCmoney(rs.getDouble("cmoney"));
				bc.setCtype(rs.getString("ctype"));
				bc.getBankuser().setUid(rs.getInt("uid"));
				bc.getBankuser().setUname(rs.getString("uname"));
				bc.getBankuser().setUphone(rs.getInt("uphone"));
				bc.getBankuser().setCompany(rs.getString("company"));
				bc.getBankuser().setHometown(rs.getString("hometown"));
				list.add(bc);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return list;
	}
	@Override
	//通过手机查询是否有这个用户
	public int Finduserbyphone(BankUser bu) {
		Connection conn=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select count(*) from bankuser where uphone=?";
			ps = conn.prepareStatement(sql);
			ps.setInt(1,bu.getUphone());
			rs=ps.executeQuery();
			while(rs.next()) {
				flag=rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return flag;
	}
	@Override
	//向用户表添加信息
	public int adduserInfo(BankUser bu) {
		Connection conn=null;
		PreparedStatement ps =null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="insert into bankuser(uname,uphone,company,hometown) values (?,?,?,?)";
			ps = conn.prepareStatement(sql);
			ps.setString(1, bu.getUname());
			ps.setInt(2, bu.getUphone());
			ps.setString(3, bu.getCompany());
			ps.setString(4, bu.getHometown());
			flag=ps.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
		}
		return flag;
	}
	@Override
	//查询所有用户信息
	public List<BankUser> showAllBankUserInfo() {
		Connection conn=null;
		Statement stat=null;
		ResultSet rs=null;
		List<BankUser> list=new ArrayList<BankUser>();
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select * from bankuser";
			stat= conn.createStatement();
			rs=stat.executeQuery(sql);
			while(rs.next()) {
				BankUser bu=new BankUser();
				bu.setUid(rs.getInt(1));
				bu.setUname(rs.getString(2));
				bu.setUphone(rs.getInt(3));
				bu.setCompany(rs.getString(4));
				bu.setHometown(rs.getString(5));
				list.add(bu);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(stat!=null) {
				try {
					stat.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return list;
	}
	@Override
	public int addcardInfo(BankCard bc) {
		Connection conn=null;
		PreparedStatement ps =null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="insert into bankcard(cpassword,cmoney,ctype,uid) values (?,?,?,?)";
			ps = conn.prepareStatement(sql);
			ps.setInt(1, bc.getCpssword());
			ps.setDouble(2, bc.getCmoney());
			ps.setString(3, bc.getCtype());
			ps.setInt(4, bc.getBankuser().getUid());
			flag=ps.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
		}
		return flag;
	}
	@Override
	//通过银行卡号查询
	public int FindBankcardbycid(Long cid) {
		Connection conn=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="select count(*) from bankcard where cid=?";
			ps = conn.prepareStatement(sql);
			ps.setLong(1,cid);
			rs=ps.executeQuery();
			while(rs.next()) {
				flag=rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return flag;
	}
	//通过卡号修改密码
	@Override
	public int updatecardpwd(Long cid,int npwd) {
		Connection conn=null;
		PreparedStatement ps =null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="update bankcard set cpassword=? where cid=?";
			ps = conn.prepareStatement(sql);
			ps.setInt(1, npwd);
			ps.setLong(2, cid);
			flag=ps.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
		}
		return flag;
	}
	@Override
	public int deletecardbycid(Long cid) {
		Connection conn=null;
		PreparedStatement ps =null;
		int flag=0;
		try {
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"
					+ "class04?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC", "root", "root");
			String sql="delete from bankcard  where cid=?";
			ps = conn.prepareStatement(sql);
			ps.setLong(1, cid);
			flag=ps.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(ps!=null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
		}
		return flag;
	}
	
}

主函数（视图层）

BankMain.java

package com.yy.view;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

import com.yy.bean.BankCard;
import com.yy.bean.BankManager;
import com.yy.bean.BankUser;
import com.yy.controller.BankController;

//两个界面
//1.管理员界面  
//   1.1 新增用户信息
//   1.2 新增银行卡信息
//   1.3 修改银行卡信息
//   1.4 删除银行卡
//   1.5 查看所有银行卡信息
//   1.6 根据条件查看银行卡信息
//2.用户界面
//   2.1 取钱功能
//   2.2 存钱功能
//   2.3 转账功能
//   2.4 查看自己银行卡信息
//   2.5 修改密码功能
//3.登录功能
//   3.1 管理员登录
//   3.2 用户登录
/**   
 * @ClassName:  BankMain   
 * @Description:相当于视图层   
 * @author: 
 * @date:   2021年5月10日 下午4:00:38      
 * @Copyright:  
 */
public class BankMain {

	public static void main(String[] args) {
		Scanner sc = new Scanner(System.in);
		BankController bankcontroller = new BankController();
		//一级界面完成管理员和普通用户功能的选择调用		
		System.out.println("*************欢迎使用太平洋银行管理系统***********");
		System.out.println("1.管理员登录");
		System.out.println("2.普通用户登录");
		System.out.println("********************************************");
		System.out.println("请输入您的选择：");
		int key1=sc.nextInt();
		switch (key1) {
		case 1://管理员登录
			System.out.println("请输入管理员账户名：");
			String ManagerName=sc.next();
			System.out.println("请输入管理员密码：");
			String ManagerPwd=sc.next();
			BankManager bm = new BankManager();
			bm.setMname(ManagerName);
			bm.setMpass(ManagerPwd);
			String mname=bankcontroller.ManagerLogin(bm);
			if(mname!=null) {
				System.out.println("欢迎管理员："+mname+"使用本系统！");
			}
			boolean Flag1=true;
			while(Flag1) {
				System.out.println("===================");
				System.out.println("1.新增用户信息");
				System.out.println("2.新增银行卡信息");
				System.out.println("3.修改银行卡密码");
				System.out.println("4.删除银行卡");
				System.out.println("5.查看所有银行卡信息");
				System.out.println("6.根据手机号查看银行卡信息");
				System.out.println("7.查看所有用户信息");
				System.out.println("===================");
				System.out.println("请输入您的选择：");
				int key2=sc.nextInt();
				switch (key2) {
				case 1://新增用户信息
					BankUser bu = new BankUser();
					System.out.println("请输入用户名：");
					bu.setUname(sc.next());
					System.out.println("请输入手机号：");
					bu.setUphone(sc.nextInt());
					System.out.println("请输入公司名称：");
					bu.setCompany(sc.next());
					System.out.println("请输入籍贯：");
					bu.setHometown(sc.next());
					boolean f=bankcontroller.Finduserbyphone(bu);
					if(!f) {
						if(bankcontroller.adduserInfo(bu)) {
							System.out.println("添加成功！");
						}
					}else {
						System.out.println("该手机号已存在！无法进行添加。");
					}
					break;
				case 2://新增银行卡信息
					BankCard bc=new BankCard();
					BankUser bu2=new BankUser();
					bc.setBankuser(bu2);
					List<BankCard> list=new ArrayList<BankCard>();
					System.out.println("请输入新建银行卡的密码：");
					bc.setCpssword(sc.nextInt());
					System.out.println("请输入新建银行卡的预存金额：");
					bc.setCmoney(sc.nextDouble());
					boolean f2=true;
					while(f2) {//如果不按照正确的提示输入则一直循环，提醒重新输入为预期值为止
						System.out.println("请输入新建银行卡的类型(储蓄卡/信用卡)");
						String ctype=sc.next();
						if(ctype.equals("储蓄卡")||ctype.equals("信用卡")) {
							bc.setCtype(ctype);
							f2=false;
						}else{
							System.out.println("请按提示重新输入!");
						}
					}
					List<BankUser> list4=bankcontroller.showAllBankUserInfo();
					for (BankUser bu4 : list4) {
						System.out.println(bu4.getUid()+"——"+bu4.getUname()+"——"+bu4.getUphone());
					}
					System.out.println("请输入新建银行卡的新ID：");
					bc.getBankuser().setUid(sc.nextInt());
					if(bankcontroller.addcardInfo(bc)) {
						System.out.println("添加成功！");
					}
					break;
				case 3://修改银行卡信息
					System.out.println("请输入要修改密码的银行卡卡号：");
					Long cid=sc.nextLong();
					boolean f3=bankcontroller.FindBankcardbycid(cid);
					if(f3) {
						System.out.println("请输入要修改的密码：");
						int pwd=sc.nextInt();
						boolean f4=true;
						while(f4) {
							System.out.println("请再次输入新密码：");
							int newpwd=sc.nextInt();
							if(pwd==newpwd) {
								if(bankcontroller.updatecardpwd(cid, newpwd)) {
									System.out.println("修改成功！");
									f4=false;
								}
							}else {
								System.out.println("两次密码输入不一致！");
							}
						}
					}else {
						System.out.println("该银行卡不存在！无法进行密码修改。");
					}
					break;
				case 4://删除银行卡
					System.out.println("请输入要修改密码的银行卡卡号：");
					Long ncid=sc.nextLong();
					boolean f4=bankcontroller.FindBankcardbycid(ncid);
					if(f4) {
						if(bankcontroller.deletecardbycid(ncid)) {
							System.out.println("删除成功！");
						}
					}else {
						System.out.println("该银行卡不存在！无需操作");
					}
					break;
				case 5://查看所有银行卡信息
					List<BankCard> list1=bankcontroller.showAllBankCardInfo();
					System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
					System.out.println("银行卡号"+"\t\t"+"密码"+"\t\t"+"余额"+"\t\t"+"银行卡类型"+"\t\t"
							 +"用户号"+"\t\t"+"用户名"+"\t\t"+"电话"+"\t\t\t"+"公司"+"\t\t"+"籍贯");
					for (BankCard bc2 : list1) {
						System.out.println(bc2);
					}
					System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
					break;
				case 6://根据条件(手机号)查看银行卡信息
					System.out.println("请输入所绑定的手机号：");
					int userphone=sc.nextInt();
					List<BankCard> list2=bankcontroller.showBankCardInfobyphone(userphone);
					if(list2.isEmpty()) {
						System.out.println("对不起，您输入的手机号未绑定过任何银行卡！");
					}else {
						System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
						System.out.println("银行卡号"+"\t\t"+"密码"+"\t\t"+"余额"+"\t\t"+"银行卡类型"+"\t\t"
								 +"用户号"+"\t\t"+"用户名"+"\t\t"+"电话"+"\t\t\t"+"公司"+"\t\t"+"籍贯");
						for (BankCard bc3 : list2) {
							System.out.println(bc3);
						}
						System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
					}
					
					break;
				case 7://查看所有用户信息
					List<BankUser> list3=bankcontroller.showAllBankUserInfo();
					System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
					System.out.println("用户号"+"\t\t"+"姓名"+"\t\t"+"电话"+"\t\t\t"+"公司名"+"\t\t"+"籍贯");
					for (BankUser bu1 : list3) {
						System.out.println(bu1);
					}
					System.out.println("---------------------------------------------------------------------------------------------------------------------------------------------------");
					break;
				default:
					System.out.println("您的输入有误！");
					break;
				}
				System.out.println("是否继续? Y/N");
				if(sc.next().equals("N")) {
					Flag1=false;
					System.out.println("欢迎下次使用！");
				}
			}
			
			break;
		case 2://普通用户登录
			System.out.println("请输入您的银行卡号：");
			Long cardid=sc.nextLong();
			System.out.println("请输入您的密码：");
			int cardpwd=sc.nextInt();
			BankCard bc=new BankCard();
			bc.setCid(cardid);
			bc.setCpssword(cardpwd);
			boolean flag=bankcontroller.CardLogin(bc);
			if(flag) {
				System.out.println("登陆成功！");
			}else {
				System.out.println("登陆失败！");
			}
			boolean Flag2=true;
			while(Flag2) {
				System.out.println("===================");
				System.out.println("1.取钱功能");
				System.out.println("2.存钱功能");
				System.out.println("3.转账功能");
				System.out.println("4.查看自己银行卡信息");
				System.out.println("5.修改密码功能");
				System.out.println("===================");
				System.out.println("请输入您的选择：");
				int key3=sc.nextInt();
				switch (key3) {
				case 1:
					
					break;
				case 2:
					
					break;
				case 3:
					
					break;
				case 4:
					
					break;
				case 5:
	
					break;
				default:
					System.out.println("您的输入有误！");
					break;
				}
				System.out.println("是否继续? Y/N");
				if(sc.next().equals("N")) {
					Flag1=false;
					System.out.println("欢迎下次使用！");
				}
			}
			break;
		default:
			System.out.println("您的输入有误！程序退出");
			System.exit(0);
			break;
		}

	}

}