銀行儲蓄系統(tǒng)java連接數(shù)據(jù)庫

ShandongUniversityofScience1andTechnology學生課程設計計劃書山東科技大學課程設計報告銀行存儲系統(tǒng)制作人：曹汪洋信息管理與信息系統(tǒng)2011-1課程設計模塊圖銀行業(yè)務員登陸退出開注修查顯存取戶銷改詢示款款賬信信信戶息息息輸輸輸入入入基注注修修儲賬儲賬賬賬本銷銷改改戶號戶號號號儲賬用手信信信信戶戶戶機息息息息登陸表user1（username1，password1）儲戶表user2（zh，name，date，phonenum）1ShandongUniversityofScience2andTechnology學生課程設計計劃書賬戶表user3（zh，money）源代碼importjava.sql.*;importjava.util.*;publicclassbeiyong{publicstaticvoidmain(String[]args)throwsException{Connectionconn=null;Statementstmt=null;ResultSetrs=null;Scannerinput=newScanner(System.in);//Scannerscanner=newScanner(System.in);System.out.println("*****歡迎使用銀行存儲系統(tǒng)*****");while(true){Scannerscanner=newScanner(System.in);System.out.println("請輸入員工名：");Stringusername2=scanner.next( );System.out.println("請輸入密碼：");Stringpassword2=scanner.next( );if(!(username2.equals("")||password2.equals(""))){try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:yinhang","","");stmt=conn.createStatement( );Stringsql0="select*fromuser1whereusername1='"+username2+"'";rs=stmt.executeQuery(sql0);if(rs.next( )){if(rs.getString("password1").trim( ).equals(password2)){System.out.println(username2+":歡迎登錄本系統(tǒng)");2ShandongUniversityofScience3andTechnology學生課程設計計劃書while(true){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("8退出系統(tǒng)");System.out.println("請選擇功能_");stmt=conn.createStatement( );intdd=scanner.nextInt( );switch(dd){case1:intwdv=0;while(wdv!=1){System.out.println("1輸入要注冊的用戶信息");System.out.println("2返回上一級");intddf=scanner.nextInt( );switch(ddf){case1:intgf=0;while(gf!=1){System.out.println("請輸入要注冊的賬戶信息以逗號分開分別為賬戶號姓名開戶時間手機號");Stringst=scanner.next( );3ShandongUniversityofScience4andTechnology學生課程設計計劃書String[]splitst=st.split(",");Stringa1;Stringa2;Stringa3;Stringa4;if(splitst.length<4){System.out.println("信息缺失請重新輸入");continue;}if(splitst.length>4){System.out.println("信息超出請重新輸入");continue;}if(splitst.length==4){a1=splitst[0];a2=splitst[1];a3=splitst[2];a4=splitst[3];Stringbbb="INSERTINTOuser2(zh,name,date,phonenum)VALUES('"+a1+"','"+a2+"','"+a3+"','"+a4+"')";inti=stmt.executeUpdate(bbb);Stringbbbc="INSERTINTOuser3(zh)VALUES('"+a1+"')";intiu=stmt.executeUpdate(bbbc);if(i!=0){System.out.println("注冊成功!");}}System.out.println("可否連續(xù)注冊yn返回上一層");Stringk=scanner.next( );if(k.startsWith("y"))4ShandongUniversityofScience5andTechnology學生課程設計計劃書{System.out.println( );};if(k.startsWith("n")){gf=1;System.out.println( );};}break;case2:wdv=1;break;case3:default:System.out.println("輸入錯誤,請重新輸入");break;}}break;case2:intwdvv=0;while(wdvv!=1){System.out.println("*************1注銷用戶基本信息*************");//System.out.println("*************2注銷賬戶信息*************");System.out.println("*************2返回上一級**************");intddf=scanner.nextInt( );switch(ddf){5ShandongUniversityofScience6andTechnology學生課程設計計劃書case1:intvvv=0;intjjj=0;while(vvv!=1||jjj!=1){System.out.println("請輸入所要注銷的賬號");Stringz=scanner.next( );Stringsql1="SELECT*FROMuser2wherezh='"+z+"'";rs=stmt.executeQuery(sql1);intkkk=0;while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);System.out.println("賬號姓名開戶日期手機號");System.out.println(a+""+b+""+c+""+d);kkk++;}if(kkk==0){System.out.println("沒有這個人，請重新輸入");}else{System.out.println("您可否真的要刪除?y/n");Stringk=scanner.next( );if(k.startsWith("y"))6ShandongUniversityofScience7andTechnology學生課程設計計劃書{StringdeleSql="DELETEFROMuser2WHEREzh='"+z+"'";inti=stmt.executeUpdate(deleSql);StringdeleSql1="DELETEFROMuser3WHEREzh='"+z+"'";intii=stmt.executeUpdate(deleSql1);System.out.println( );System.out.println("可否連續(xù)刪除？y/nn返回上一層");Stringl=scanner.next( );if(l.startsWith("y")){System.out.println( );};if(l.startsWith("n")){jjj=1;break;};};if(k.startsWith("n")){System.out.println("可否連續(xù)刪除？y/nn返回上一層");Stringw=scanner.next( );if(w.startsWith("y")){System.out.println( );};if(w.startsWith("n")){7ShandongUniversityofScience8andTechnology學生課程設計計劃書vvv=1;break;};break;}}}break;case2:wdvv=1;break;case3:default:System.out.println("輸入錯誤,請重新輸入");break;}}break;case3:intggg=0;while(ggg!=1){System.out.println("請選綱要更正的項目");System.out.println("1賬號");System.out.println("1用戶名");System.out.println("2手機號");System.out.println("3金額");System.out.println("5返回上一級");intww=scanner.nextInt( );switch(ww){case1:intgggg=0;while(gggg!=1)8ShandongUniversityofScience9andTechnology學生課程設計計劃書{System.out.println("請輸入被更正人的賬號");Stringzh1=scanner.next( );Stringsql1="SELECT*FROMuser2wherezh='"+zh1+"'";rs=stmt.executeQuery(sql1);intx=0;while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);//Stringe=rs.getString(5);//Stringf=rs.getString(6);//Stringg=rs.getString(7);System.out.println("賬號姓名開戶日期手機號");System.out.println(a+""+b+""+c+""+d);x++;}if(x==0){System.out.println("查無此人,請重新輸入");break;}System.out.println("請輸入姓名");Stringnl=scanner.next( );Stringrd="updateuser2setname='"+nl+"'wherezh='"+zh1+"'";inti=stmt.executeUpdate(rd);if(i==0){System.out.println("沒有這個人無法更正");9ShandongUniversityofScience10andTechnology學生課程設計計劃書System.out.println( );}if(i!=0){System.out.println("已更正");Stringsql2="SELECT*FROMuser2wherezh='"+zh1+"'";rs=stmt.executeQuery(sql2);while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);System.out.println("賬號姓名開戶日期手機號");System.out.println(a+""+b+""+c+""+d);}System.out.println( );}System.out.println("可否連續(xù)更正手機號？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){gggg=1;System.out.println( );};10ShandongUniversityofScience11andTechnology學生課程設計計劃書}break;case2:intwwww=0;while(wwww!=1){System.out.println("請輸入被更正人的賬號");Stringzh2=scanner.next( );Stringsql1="SELECT*FROMuser2wherezh='"+zh2+"'";rs=stmt.executeQuery(sql1);intx=0;while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);//Stringe=rs.getString(5);//Stringf=rs.getString(6);//Stringg=rs.getString(7);System.out.println("賬號姓名注冊日期手機號");System.out.println(a+""+b+""+c+""+d);x++;}if(x==0){System.out.println("查無此人,請重新輸入");break;}System.out.println("請輸下手機號");Stringsj=scanner.next( );Stringrd="updateuser2setphonenum='"+sj+"'where11ShandongUniversityofScience12andTechnology學生課程設計計劃書zh='"+zh2+"'";inti=stmt.executeUpdate(rd);if(i!=0){System.out.println("已更正");Stringsql2="SELECT*FROMuser2wherezh='"+zh2+"'";rs=stmt.executeQuery(sql2);while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);System.out.println("賬號姓名開戶日期手機號");System.out.println(a+""+b+""+c+""+d);}System.out.println( );}System.out.println("可否連續(xù)更正？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){wwww=1;System.out.println( );};}12ShandongUniversityofScience13andTechnology學生課程設計計劃書break;case5:ggg=1;break;case6:default:System.out.println("輸入錯誤,請重新輸入");break;}}break;case4:intddd=0;while(ddd!=1){System.out.println("1盤問賬戶信息");System.out.println("2盤問儲戶基本信息");System.out.println("3返回");System.out.println("請選擇功能_");intzz=scanner.nextInt( );switch(zz){case1:intrr=0;while(rr!=1){System.out.println("請入賬號:");Stringff=scanner.next( );Stringsql1="SELECT*FROMuser3wherezh='"+ff+"'";rs=stmt.executeQuery(sql1);intx=0;13ShandongUniversityofScience14andTechnology學生課程設計計劃書while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);System.out.println("賬號金額");System.out.println(a+""+b);x++;System.out.println("可否連續(xù)盤問？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){rr=1;System.out.println( );};}if(x==0){System.out.println("查無此人,請重新輸入");}}break;case2:intkkkk=0;while(kkkk!=1){System.out.println("請輸入賬號和用戶名,中間用逗號分開");Stringxh3=scanner.next( );String[]splitst=xh3.split(",");14ShandongUniversityofScience15andTechnology學生課程設計計劃書Stringa1;Stringa2;a1=splitst[0];a2=splitst[1];Stringsql1="SELECT*FROMuser2wherezh='"+a1+"'andname='"+a2+"'";rs=stmt.executeQuery(sql1);intx=0;while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);System.out.println("賬號號姓名開戶日期手機號");System.out.println(a+","+b+","+c+","+d);x++;System.out.println("可否連續(xù)盤問賬號信息？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){kkkk=1;System.out.println( );};15ShandongUniversityofScience16andTechnology學生課程設計計劃書}if(x==0){System.out.println("查無此人,請重新選擇");break;}}break;case3:ddd=1;break;case4:default:System.out.println("輸入錯誤");break;}}break;case5:Stringsql="SELECT*FROMuser2";rs=stmt.executeQuery(sql);System.out.println("儲戶信息以下");System.out.println("賬號姓名開戶日期手機號");while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);Stringc=rs.getString(3);Stringd=rs.getString(4);//Stringe=rs.getString(5);//Stringf=rs.getString(6);//Stringg=rs.getString(7);System.out.println(a+""+b+""+c+""+d);16ShandongUniversityofScience17andTechnology學生課程設計計劃書}Stringsql1="SELECT*FROMuser3";rs=stmt.executeQuery(sql1);System.out.println("賬戶戶信息以下");System.out.println("賬號金額");while(rs.next( )){Stringe=rs.getString(1);Stringf=rs.getString(2);System.out.println(e+""+f);}break;case6:while(true){System.out.println("請輸入銀行賬號：");Stringzhanghao=scanner.next( );System.out.println("請輸入取款數(shù)額");intqukuan=input.nextInt( );Stringsqlqukuan="selectmoneyfromuser3wherezh='"+zhanghao+"'";//stmt=conn.createStatement( );rs=stmt.executeQuery(sqlqukuan);while(rs.next( )){intyue=rs.getInt("money");if(yue>=qukuan){//System.out.println("-*-取款中請稍候-*-");yue=yue-qukuan;17ShandongUniversityofScience18andTechnology學生課程設計計劃書Stringsqlqukuan1="updateuser3"+"setm