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

ShandongUniversityofScience1andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書山東科技大學(xué)課程設(shè)計(jì)報(bào)告銀行存儲(chǔ)系統(tǒng)制作人：曹汪洋信息管理與信息系統(tǒng)2011-1課程設(shè)計(jì)模塊圖銀行業(yè)務(wù)員登陸退出開注修查顯存取戶銷改詢示款款賬信信信戶息息息輸輸輸入入入基注注修修儲(chǔ)賬儲(chǔ)賬賬賬本銷銷改改戶號(hào)戶號(hào)號(hào)號(hào)儲(chǔ)賬用手信信信信戶戶戶機(jī)息息息息登陸表user1（username1，password1）儲(chǔ)戶表user2（zh，name，date，phonenum）1ShandongUniversityofScience2andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書賬戶表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("*****歡迎使用銀行存儲(chǔ)系統(tǒng)*****");while(true){Scannerscanner=newScanner(System.in);System.out.println("請(qǐng)輸入員工名：");Stringusername2=scanner.next( );System.out.println("請(qǐng)輸入密碼：");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學(xué)生課程設(shè)計(jì)計(jì)劃書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("請(qǐng)選擇功能_");stmt=conn.createStatement( );intdd=scanner.nextInt( );switch(dd){case1:intwdv=0;while(wdv!=1){System.out.println("1輸入要注冊(cè)的用戶信息");System.out.println("2返回上一級(jí)");intddf=scanner.nextInt( );switch(ddf){case1:intgf=0;while(gf!=1){System.out.println("請(qǐng)輸入要注冊(cè)的賬戶信息以逗號(hào)分開分別為賬戶號(hào)姓名開戶時(shí)間手機(jī)號(hào)");Stringst=scanner.next( );3ShandongUniversityofScience4andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書String[]splitst=st.split(",");Stringa1;Stringa2;Stringa3;Stringa4;if(splitst.length<4){System.out.println("信息缺失請(qǐng)重新輸入");continue;}if(splitst.length>4){System.out.println("信息超出請(qǐng)重新輸入");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("注冊(cè)成功!");}}System.out.println("可否連續(xù)注冊(cè)yn返回上一層");Stringk=scanner.next( );if(k.startsWith("y"))4ShandongUniversityofScience5andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書{System.out.println( );};if(k.startsWith("n")){gf=1;System.out.println( );};}break;case2:wdv=1;break;case3:default:System.out.println("輸入錯(cuò)誤,請(qǐng)重新輸入");break;}}break;case2:intwdvv=0;while(wdvv!=1){System.out.println("*************1注銷用戶基本信息*************");//System.out.println("*************2注銷賬戶信息*************");System.out.println("*************2返回上一級(jí)**************");intddf=scanner.nextInt( );switch(ddf){5ShandongUniversityofScience6andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書case1:intvvv=0;intjjj=0;while(vvv!=1||jjj!=1){System.out.println("請(qǐng)輸入所要注銷的賬號(hào)");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("賬號(hào)姓名開戶日期手機(jī)號(hào)");System.out.println(a+""+b+""+c+""+d);kkk++;}if(kkk==0){System.out.println("沒有這個(gè)人，請(qǐng)重新輸入");}else{System.out.println("您可否真的要?jiǎng)h除?y/n");Stringk=scanner.next( );if(k.startsWith("y"))6ShandongUniversityofScience7andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書{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學(xué)生課程設(shè)計(jì)計(jì)劃書vvv=1;break;};break;}}}break;case2:wdvv=1;break;case3:default:System.out.println("輸入錯(cuò)誤,請(qǐng)重新輸入");break;}}break;case3:intggg=0;while(ggg!=1){System.out.println("請(qǐng)選綱要更正的項(xiàng)目");System.out.println("1賬號(hào)");System.out.println("1用戶名");System.out.println("2手機(jī)號(hào)");System.out.println("3金額");System.out.println("5返回上一級(jí)");intww=scanner.nextInt( );switch(ww){case1:intgggg=0;while(gggg!=1)8ShandongUniversityofScience9andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書{System.out.println("請(qǐng)輸入被更正人的賬號(hào)");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("賬號(hào)姓名開戶日期手機(jī)號(hào)");System.out.println(a+""+b+""+c+""+d);x++;}if(x==0){System.out.println("查無此人,請(qǐng)重新輸入");break;}System.out.println("請(qǐng)輸入姓名");Stringnl=scanner.next( );Stringrd="updateuser2setname='"+nl+"'wherezh='"+zh1+"'";inti=stmt.executeUpdate(rd);if(i==0){System.out.println("沒有這個(gè)人無法更正");9ShandongUniversityofScience10andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書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("賬號(hào)姓名開戶日期手機(jī)號(hào)");System.out.println(a+""+b+""+c+""+d);}System.out.println( );}System.out.println("可否連續(xù)更正手機(jī)號(hào)？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){gggg=1;System.out.println( );};10ShandongUniversityofScience11andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書}break;case2:intwwww=0;while(wwww!=1){System.out.println("請(qǐng)輸入被更正人的賬號(hào)");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("賬號(hào)姓名注冊(cè)日期手機(jī)號(hào)");System.out.println(a+""+b+""+c+""+d);x++;}if(x==0){System.out.println("查無此人,請(qǐng)重新輸入");break;}System.out.println("請(qǐng)輸下手機(jī)號(hào)");Stringsj=scanner.next( );Stringrd="updateuser2setphonenum='"+sj+"'where11ShandongUniversityofScience12andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書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("賬號(hào)姓名開戶日期手機(jī)號(hào)");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學(xué)生課程設(shè)計(jì)計(jì)劃書break;case5:ggg=1;break;case6:default:System.out.println("輸入錯(cuò)誤,請(qǐng)重新輸入");break;}}break;case4:intddd=0;while(ddd!=1){System.out.println("1盤問賬戶信息");System.out.println("2盤問儲(chǔ)戶基本信息");System.out.println("3返回");System.out.println("請(qǐng)選擇功能_");intzz=scanner.nextInt( );switch(zz){case1:intrr=0;while(rr!=1){System.out.println("請(qǐng)入賬號(hào):");Stringff=scanner.next( );Stringsql1="SELECT*FROMuser3wherezh='"+ff+"'";rs=stmt.executeQuery(sql1);intx=0;13ShandongUniversityofScience14andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書while(rs.next( )){Stringa=rs.getString(1);Stringb=rs.getString(2);System.out.println("賬號(hào)金額");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("查無此人,請(qǐng)重新輸入");}}break;case2:intkkkk=0;while(kkkk!=1){System.out.println("請(qǐng)輸入賬號(hào)和用戶名,中間用逗號(hào)分開");Stringxh3=scanner.next( );String[]splitst=xh3.split(",");14ShandongUniversityofScience15andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書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("賬號(hào)號(hào)姓名開戶日期手機(jī)號(hào)");System.out.println(a+","+b+","+c+","+d);x++;System.out.println("可否連續(xù)盤問賬號(hào)信息？y/nn返回上一層");Stringk=scanner.next( );if(k.startsWith("y")){System.out.println( );};if(k.startsWith("n")){kkkk=1;System.out.println( );};15ShandongUniversityofScience16andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書}if(x==0){System.out.println("查無此人,請(qǐng)重新選擇");break;}}break;case3:ddd=1;break;case4:default:System.out.println("輸入錯(cuò)誤");break;}}break;case5:Stringsql="SELECT*FROMuser2";rs=stmt.executeQuery(sql);System.out.println("儲(chǔ)戶信息以下");System.out.println("賬號(hào)姓名開戶日期手機(jī)號(hào)");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學(xué)生課程設(shè)計(jì)計(jì)劃書}Stringsql1="SELECT*FROMuser3";rs=stmt.executeQuery(sql1);System.out.println("賬戶戶信息以下");System.out.println("賬號(hào)金額");while(rs.next( )){Stringe=rs.getString(1);Stringf=rs.getString(2);System.out.println(e+""+f);}break;case6:while(true){System.out.println("請(qǐng)輸入銀行賬號(hào)：");Stringzhanghao=scanner.next( );System.out.println("請(qǐng)輸入取款數(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("-*-取款中請(qǐng)稍候-*-");yue=yue-qukuan;17ShandongUniversityofScience18andTechnology學(xué)生課程設(shè)計(jì)計(jì)劃書Stringsqlqukuan1="updateuser3"+"setm