java学习之项目实战(信息管理信息系统)

这是一个使用Java编写的信用卡信息管理系统实战项目。系统包括银行工作人员和持卡消费者的登录功能,支持账户资料管理、信用管理、欠款管理及账单查询等操作。通过对象序列化进行数据持久化存储。
摘要由CSDN通过智能技术生成

信息管理系统实战:

代码:

测试类:

package com.lifeng.card;

import java.util.ArrayList;

import java.util.List;

import java.util.Scanner;

import com.lifeng.util.ObjectStreamUtil;

public class MainFrame {

//创建公共访问的对象

static  Scanner scanner=new Scanner(System.in);

public static List<AccountVo> list=new ArrayList<AccountVo>();

public static List<BillVo> billList=new ArrayList<BillVo>();

public static void main(String[] args) {

welcome();

}

public static void welcome() {

//如果account.txt是空的,初始化4个账户,存入account.txt.否则读取account.txt中的对象

initAccount();//初始化几个默认值

System.out.println("======================================");

System.out.println("欢迎登录信用卡系统 ");

System.out.println("======================================");

System.out.println("请选择用户类型");

System.out.println("---------------------------------");

System.out.println("1.银行工作人员");

System.out.println("2.持卡消费者");

System.out.println("3.退出");

System.out.println("---------------------------------");

int input = 0;

try {

System.out.println("请选择:");

input = scanner.nextInt();

} catch (Exception e) {

System.out.println("您输入的数据有问题,请重新输入。");

returnMenu();

}

switch(input) {

case 1:

banklogin();

break;

case 2:

userlogin();

break;

case 3:// 退出

System.exit(0);

break;

default:

System.out.println("错误操作,请重新选择");

returnMenu();

}

}

private static void returnMenu() {

System.out.println("---------------------------------");

System.out.print("输入0为您返回主菜单");

// 判断用户是否需要返回主菜单

int input = scanner.nextInt();

System.out.println("---------------------------------");

// 输入0则返回主菜单

if (0 == input) {

welcome();

} else {

System.out.println("您输入的有误,自动为您返回主菜单");

welcome();

}

}

private static void banklogin() {

System.out.println("请输入银行管理员用户名:");

String user = scanner.next();

if (user.equals("admin")) {

System.out.println("请输入用户密码:");

String pw = scanner.next();

if (pw.equals("admin")) {

System.out.println("登录成功!");

LoginManagerFrame.Managerwelcome();

} else {

System.out.println("密码错误!,请重新操作");

banklogin();}

} else {

System.out.println("用户名不存在!,请重新操作");

banklogin();}}

private static void userlogin() {//用户登录

System.out.println("请输入卡号:");

String cardnum = scanner.next();

for(int i=0;i<list.size();i++) {

AccountVo account = list.get(i);

if (account.cardNo.equals(cardnum)) {

System.out.println("请输入密码");

String passw = scanner.next();

if (account.password.equals(passw)) {

System.out.println("登录成功");

LoginPerson.Personwelcome();//登陆成功之后的转换

break;

} else {

System.out.println("密码错误,请重新输入:");

while (!scanner.next().equals(account.password)) {

System.out.println("密码错误,请重新输入:");}

System.out.println("登录成功");

LoginPerson.Personwelcome();

break;}}

if (i == list.size() - 1){//防止漏输

System.out.println("卡号不存在 ,请重新输入");

userlogin();}}}

private static void initAccount() {

//如果account.txt是空的,初始化4个账户,存入account.txt.否则读取account.txt中的对象

list=ObjectStreamUtil.getAccountVoList();

if(list.isEmpty()) {

AccountVo user1 = new AccountVo("100010", "100010", "user1");

AccountVo user2 = new AccountVo("100011", "100011", "user2");

AccountVo user3 = new AccountVo("100012", "100012", "user3");

AccountVo user4 = new AccountVo("100013", "100013", "user4");

list.add(user1);//把对象一一写入

list.add(user2);

list.add(user3);

list.add(user4);

ObjectStreamUtil.saveAccountVoList(list);}}}

对象:

管理员:

package com.lifeng.card;

import java.util.List;

import java.util.Scanner;

import com.lifeng.util.ObjectStreamUtil;

public class LoginManagerFrame {

public static void Managerwelcome(){

System.out.println("***********************************");

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("====请选择:");

int input = MainFrame.scanner.nextInt();

switch(input) {

case 1:

try {

Thread.currentThread().sleep(1000);

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}// 延迟1秒

accountManager();//账户资料管理

break;

case 2:

try {

Thread.currentThread().sleep(1000);

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}// 延迟1秒

accountCreditManager();//账户信用管理

break;

case 3:

try {

Thread.currentThread().sleep(1000);

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}// 延迟1秒

accountOwerCheck();//账户欠款查询

break;

case 4:

try {

Thread.currentThread().sleep(1000);

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}// 延迟1秒

billCheck();//账单查询

break;

case 5:// 退出

Managerwelcome();

break;

default:

System.out.println("错误操作,请重新选择");}}

private static void accountManager() {

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("请选择操作:");

int input = MainFrame.scanner.nextInt();

switch(input) {

case 1:

System.out.println("请输入添加的卡号:");

String cardNo1 = MainFrame.scanner.next();

System.out.println("请输入添加的账户密码:");

String password1 = MainFrame.scanner.next();

System.out.println("请输入添加的账户名:");

String username1 = MainFrame.scanner.next();

AddAccount(cardNo1,password1,username1);

break;

case 2:

System.out.println("请输入需要修改的账户卡号:");

package cn.com.dao.chivementdao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import cn.com.util.DBConnection; import cn.com.util.DBSql; import cn.com.vo.chivementvo.ChivementVo; public class ExamDao { private Connection conn = DBConnection.getConnectionOracle(); private ChivementVo examVo; public ExamDao() { } public ExamDao(ChivementVo examVo) { super(); this.examVo = examVo; } /** * 全部查询 */ public Object[][] selectAll() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_ALL); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberAll(DBSql.SELECT_ALL_COUNT)][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据学号查询 */ public Object[][] selectBySid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_S_ID); ps.setInt(1, examVo.getS_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_S_ID_COUNT, examVo .getS_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据组号查询 */ public Object[][] selectByGid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_G_ID); ps.setInt(1, examVo.getG_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_G_ID_COUNT, examVo .getG_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据课程号查询 */ public Object[][] selectByCid() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_C_ID); ps.setInt(1, examVo.getC_id()); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumber(DBSql.SELECT_BY_C_ID_COUNT, examVo .getC_id())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { // System.out.println( examVo.getG_id()); date[i][j] = rs.getObject(j+1); } i++; } // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据姓名模糊查询 * * @return */ public Object[][] selectByName() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_S_NAME); ps.setString(1, examVo.getS_name()); ps.setString(2, "%" + examVo.getS_name() + "%"); ps.setString(3, "%" + examVo.getS_name()); ps.setString(4, examVo.getS_name() + "%"); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberByName(DBSql.SELECT_BY_S_NAME_COUNT, examVo.getS_name())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 根据课程名称模糊查询 * * @return */ public Object[][] selectByClassName() { Object date[][] = null; int max = 0; int i = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.SELECT_BY_CLASS_NAME); ps.setString(1, examVo.getClass_name()); ps.setString(2, "%" + examVo.getClass_name() + "%"); ps.setString(3, "%" + examVo.getClass_name()); ps.setString(4, examVo.getClass_name() + "%"); rs = ps.executeQuery(); // 得到列数 max = rs.getMetaData().getColumnCount(); date = new Object[getnumberByName(DBSql.SELECT_BY_CLASS_COUNT, examVo.getClass_name())][max]; while (rs.next()) { for (int j = 0; j < max; j++) { date[i][j] = rs.getObject(j + 1); } i++; } } catch (SQLException e) { e.printStackTrace(); } return date; } /** * 修改选中学生的成绩 * */ public void updatSelectClass() { PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(DBSql.UPDATE_EXAM_BY_STUID); ps.setInt(1, examVo.getClassExamChivement()); ps.setInt(2, examVo.getS_id()); ps.setInt(3, examVo.getC_id()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } /** * 得到所有课程号和课程名 * * @return */ public String[] getClassNoName() { String[] classNoName = null; PreparedStatement ps = null; ResultSet rs = null; int j = 0; try { int i = getnumberAll(DBSql.SELECT_CLASS_NAME_COUNT); classNoName = new String[i + i]; ps = conn.prepareStatement(DBSql.SELECT_CLASS_NAME); rs = ps.executeQuery(); while (rs.next()) { classNoName[j] = rs.getString(1); classNoName[j + i] = rs.getString(2); j++; } } catch (SQLException e) { e.printStackTrace(); } return classNoName; } /** * 根据科目修改成绩 查询学号 姓名 成绩 * */ public void SelectClassStuName() { int i = 0; PreparedStatement ps = null; ResultSet rs = null; int j = getnumberBySelectClassName( DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM_COUNT, examVo.getC_id()); int[] sNum = new int[j]; String[] sName = new String[j]; int[] classExam = new int[j]; try { ps = conn.prepareStatement(DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM); ps.setInt(1, examVo.getC_id()); rs = ps.executeQuery(); while (rs.next()) { sNum[i] = rs.getInt(1); sName[i] = rs.getString(2); classExam[i] = rs.getInt(3); i++; } } catch (SQLException e) { e.printStackTrace(); } examVo.setSid(sNum); examVo.setSname(sName); examVo.setClassExam(classExam); } /** * 根据科目修改成绩 查询学号 姓名 成绩 后修改成绩 * */ public void UpdateClassStuName() { // int i = 0; PreparedStatement ps = null; ResultSet rs = null; int j = getnumberBySelectClassName( DBSql.SELECT_CLASS_STU_SNO_SNAME_EXAM_COUNT, examVo.getC_id()); try { ps = conn.prepareStatement(DBSql.UPDATE_CHIVEMENT_BY_CLASS); for(int i =0;i<j;i++){ ps.setInt(1, examVo.getClassExam()[i]); ps.setInt(2, examVo.getSid()[i]); ps.setInt(3, examVo.getC_id()); ps.executeUpdate(); } } catch (SQLException e) { e.printStackTrace(); } } /** * 全部查询获得行数 * * @return */ public int getnumberAll(String str) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return number; } /** * 根据学号 根据组号 根据课程号查询 获得行数 * * @return */ public int getnumber(String str, int i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setInt(1, i); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); // rs.close(); // ps.close(); // conn.close(); } catch (SQLException e) { e.printStackTrace(); } return number; } /** * 根据姓名 课程名 查询 获得行数 * */ public int getnumberByName(String str, String i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setString(1, i); ps.setString(2, "%" + i + "%"); ps.setString(3, "%" + i); ps.setString(4, i + "%"); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); } catch (SQLException e) { e.printStackTrace(); } return number; } // /** // * 根据课程名查询 获得行数 // * // */ // // public int getnumberByClassName(String str, String i) { // int number = 0; // PreparedStatement ps = null; // ResultSet rs = null; // try { // ps = conn.prepareStatement(str); // ps.setString(1, i); // ps.setString(2, "%" + i + "%"); // ps.setString(3, "%" + i); // ps.setString(4, i + "%"); // rs = ps.executeQuery(); // rs.next(); // number = rs.getInt(1); // } catch (SQLException e) { // e.printStackTrace(); // } // return number; // } /** * * 根据课程名修改成绩获得行数 * * @param str * @param i * @return */ public int getnumberBySelectClassName(String str, int i) { int number = 0; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(str); ps.setInt(1, i); rs = ps.executeQuery(); rs.next(); number = rs.getInt(1); } catch (SQLException e) { e.printStackTrace(); } return number; } }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值