银行储蓄系统 java连接数据库

1、20Shandong University of Science and Technology 学生课程设计计划书山东科技大学课程设计报告银行储蓄系统制作人：曹汪洋 信息管理与信息系统2011-1 注销账户退出修改手机号注销账户信息注销储户信息取款存款开户账号信息储户信息修改用户名输入基本信息显示信息查询信息修改信息储户信息账号信息输入账号输入账号银行业务员登陆课程设计模块图 登陆表 user1 （username1，password1）储户表 user2 （ zh，name，date，phonenum）账户表 user3 （zh，money）源代码import java.sql.*;impo

2、rt java.util.*;public class beiyong public static void main(String args) throws Exception Connection conn=null; Statement stmt=null; ResultSet rs=null; Scanner input = new Scanner(System.in); /Scanner scanner=new Scanner(System.in); System.out.println("*欢迎使用银行储蓄系统*");while(true) Scanner sc

3、anner=new Scanner(System.in); System.out.println("请输入员工名："); String username2=scanner.next(); System.out.println("请输入密码："); String password2=scanner.next(); if(!(username2.equals(" ")|password2.equals(" ") try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver&q

4、uot;); conn=DriverManager.getConnection("jdbc:odbc:yinhang","",""); stmt=conn.createStatement(); String sql0="select * from user1 where username1='"+username2+"'" rs=stmt.executeQuery(sql0); if (rs.next() if(rs.getString("password1"

5、).trim().equals(password2) System.out.println(username2+": 欢迎登录本系统"); while(true) System.out.println(" 1 开户"); System.out.println(" 2 注销账户"); System.out.println(" 3 修改账户信息"); System.out.println(" 4 查询信息"); System.out.println(" 5 显示信息"); Sys

6、tem.out.println(" 6 取款"); System.out.println(" 7 存款"); System.out.println(" 8 退出系统"); System.out.println("请选择功能_"); stmt =conn.createStatement(); int dd=scanner.nextInt(); switch(dd) case 1: int wdv=0; while(wdv!=1) System.out.println(" 1 输入要注册的用户信息"

7、); System.out.println(" 2 返回上一级"); int ddf=scanner.nextInt(); switch(ddf) case 1: int gf=0; while(gf!=1) System.out.println("请输入要注册的账户信息以逗号隔开分别为账户号 姓名 开户时间 手机号"); String st=scanner.next(); String splitst=st.split(","); String a1; String a2; String a3; String a4; if(spli

8、tst.length<4) System.out.println("信息缺失 请重新输入"); continue; if(splitst.length>4) System.out.println("信息超出 请重新输入"); continue; if(splitst.length=4) a1=splitst0; a2=splitst1; a3=splitst2; a4=splitst3; String bbb="INSERT INTO user2(zh,name,date,phonenum) VALUES('"+a

9、1+"','"+a2+"','"+a3+"','"+a4+"')" int i=stmt.executeUpdate(bbb); String bbbc="INSERT INTO user3(zh) VALUES('"+a1+"')" int iu=stmt.executeUpdate(bbbc); if(i!=0) System.out.println("注册成功!"); Syste

10、m.out.println("是否继续注册y n返回上一层"); String k=scanner.next(); if(k.startsWith("y") System.out.println(); ; if(k.startsWith("n") gf=1; System.out.println(); ; break; case 2: wdv=1; break; case 3: default: System.out.println( "输入错误,请重新输入"); break; break; case 2: int

11、 wdvv=0; while(wdvv!=1) System.out.println("* 1 注销用户基本信息*"); /System.out.println("* 2 注销账户信息*"); System.out.println("* 2 返回上一级 *"); int ddf=scanner.nextInt(); switch(ddf) case 1: int vvv=0; int jjj=0; while(vvv!=1|jjj!=1) System.out.println( "请输入所要注销的账号"); Str

12、ing z=scanner.next(); String sql1= "SELECT * FROM user2 where zh ='"+z+"'" rs= stmt.executeQuery(sql1); int kkk=0; while(rs.next() String a =rs.getString(1); String b =rs.getString(2); String c =rs.getString(3); String d =rs.getString(4); System.out.println("账号 姓名 开户

13、日期 手机号"); System.out.println(a+" "+b+" "+c+" "+d); kkk+; if(kkk=0) System.out.println( "没有这个人，请重新输入"); else System.out.println( "您是否真的要删除? y/n"); String k=scanner.next(); if(k.startsWith("y") String deleSql= "DELETE FROM user2 WHE

14、RE zh='"+z+"'" ; int i=stmt.executeUpdate(deleSql); String deleSql1= "DELETE FROM user3 WHERE zh='"+z+"'" ; int ii=stmt.executeUpdate(deleSql1); System.out.println(); System.out.println("是否继续删除？y/n n返回上一层"); String l=scanner.next(); if(l.s

15、tartsWith("y") System.out.println(); ; if(l.startsWith("n") jjj=1; break; ; ; if(k.startsWith("n") System.out.println("是否继续删除？y/n n返回上一层"); String w=scanner.next(); if(w.startsWith("y") System.out.println(); ; if(w.startsWith("n") vvv=1; br

16、eak; ; break; break; case 2: wdvv=1; break; case 3: default: System.out.println( "输入错误,请重新输入"); break; break; case 3: int ggg=0; while(ggg!=1) System.out.println("请选择要修改的项目"); / System.out.println("1 账号"); System.out.println("1 用户名"); System.out.println("

17、2 手机号"); / System.out.println("3 金额"); System.out.println("5 返回上一级"); int ww=scanner.nextInt(); switch(ww) case 1: int gggg=0; while(gggg!=1) System.out.println("请输入被修改人的账号"); String zh1=scanner.next(); String sql1= "SELECT * FROM user2 where zh ='"+z

18、h1+"'" rs= stmt.executeQuery(sql1); int x=0; while(rs.next() String a =rs.getString(1); String b =rs.getString(2); String c =rs.getString(3); String d =rs.getString(4); / String e =rs.getString(5); /String f =rs.getString(6); /String g =rs.getString(7); System.out.println("账号 姓名 开

19、户日期 手机号 "); System.out.println(a+" "+b+" "+c+" "+d); x+; if(x=0) System.out.println("查无此人,请重新输入"); break; System.out.println("请输入姓名"); String nl=scanner.next(); String rd = "update user2 set name='"+nl+"' where zh='&qu

20、ot;+zh1+"'" int i=stmt.executeUpdate(rd); if(i=0) System.out.println("没有这个人无法修改"); System.out.println(); if(i!=0) System.out.println("已修改"); String sql2= "SELECT * FROM user2 where zh ='"+zh1+"'" rs= stmt.executeQuery(sql2); while(rs.next

21、() String a =rs.getString(1); String b =rs.getString(2); String c =rs.getString(3); String d =rs.getString(4); System.out.println("账号 姓名 开户日期 手机号 "); System.out.println(a+" "+b+" "+c+" "+d); System.out.println(); System.out.println("是否继续修改手机号？y/n n返回上一层&q

22、uot;); String k=scanner.next(); if(k.startsWith("y") System.out.println(); ; if(k.startsWith("n") gggg=1; System.out.println(); ; break; case 2: int wwww=0; while(wwww!=1) System.out.println("请输入被修改人的账号"); String zh2=scanner.next(); String sql1= "SELECT * FROM user

23、2 where zh ='"+zh2+"'" rs= stmt.executeQuery(sql1); int x=0; while(rs.next() String a =rs.getString(1); String b =rs.getString(2); String c =rs.getString(3); String d =rs.getString(4); / String e =rs.getString(5); /String f =rs.getString(6); /String g =rs.getString(7); System.

24、out.println("账号 姓名 注册日期 手机号"); System.out.println(a+" "+b+" "+c+" "+d); x+; if(x=0) System.out.println("查无此人,请重新输入"); break; System.out.println("请输入手机号"); String sj=scanner.next(); String rd = "update user2 set phonenum='"+sj+

25、"' where zh='"+zh2+"'" int i=stmt.executeUpdate(rd); if(i!=0) System.out.println("已修改"); String sql2= "SELECT * FROM user2 where zh ='"+zh2+"'" rs= stmt.executeQuery(sql2); while(rs.next() String a =rs.getString(1); String b =rs.g

26、etString(2); String c =rs.getString(3); String d =rs.getString(4); System.out.println("账号 姓名 开户日期 手机号 "); System.out.println(a+" "+b+" "+c+" "+d); System.out.println(); System.out.println("是否继续修改？y/n n返回上一层"); String k=scanner.next(); if(k.startsWith

27、("y") System.out.println(); ; if(k.startsWith("n") wwww=1; System.out.println(); ; break; case 5: ggg=1; break; case 6: default: System.out.println( "输入错误,请重新输入"); break; break; case 4: int ddd=0; while(ddd!=1) System.out.println(" 1 查询账户信息"); System.out.println(" 2 查询储户基本信息"); System.out.println