用JAVA代碼寫(xiě)的連接數(shù)據(jù)庫(kù)學(xué)生信息管理系統(tǒng)

1、保證程序運(yùn)行無(wú)誤，我都云新過(guò)了！importjava.sql.*;importjava.util.*;publicclassStudent2privatestaticScannerscanner=newScanner(System.in);Stringdriver="org.hsqldb.jdbcDriver"Stringurl="jdbc:hsqldb:hsql:/localhost"/連接到本機(jī)上默認(rèn)的數(shù)據(jù)庫(kù)Stringuser="sa"Stringpass=""privateConnectioncon;pub

2、licvoidinit()throwsExceptionif(con!=null)return;/已經(jīng)初始化Class.forName(driver);/裝載驅(qū)動(dòng)con=DriverManager.getConnection(url,user,pass);/建立和數(shù)據(jù)庫(kù)之間的連接Stringsql="createtablestudent(idbigint,namevarchar(120),"sql+="osdecimal,mathdecimal,javadecimal)"Statementstmt=con.createStatement();stmt.e

3、xecuteUpdate(sql);/創(chuàng)建表，只執(zhí)行一次。/在表中插入數(shù)據(jù)以備使用publicvoidclose()throwsExceptionif(con!=null)con.close();/*創(chuàng)建student表，表中有id,name,math,os,java五列*/publicvoidAdd()throwsExceptionSystem.out.println("請(qǐng)輸入學(xué)生學(xué)號(hào)：(當(dāng)輸入學(xué)號(hào)為-1時(shí)停止)");longid=scanner.nextLong();while(id!=-1)System.out.println("請(qǐng)輸入該學(xué)生的名字：&quo

4、t;);Stringname=scanner.next();System.out.println("請(qǐng)連續(xù)輸入os,math,java各科成績(jī)：");doubleos=scanner.nextDouble();doublemath=scanner.nextDouble();doublejava=scanner.nextDouble();Stringsql="insertintostudentvalues(?,?,?,?,?)"PreparedStatementpstmt=con.prepareStatement(sql);pstmt.setLong(1,

5、id);pstmt.setString(2,name);pstmt.setDouble(3,os);pstmt.setDouble(4,math);pstmt.setDouble(5,java);pstmt.execute();pstmt.close();System.out.println("請(qǐng)輸入學(xué)生學(xué)號(hào)：(當(dāng)輸入學(xué)號(hào)為-1時(shí)停止)");id=scanner.nextLong();/*查詢時(shí)使用Statement的executeQuery方法，其它用executeUpdate方法*/publicvoiddispAll()throwsExceptionStatements

6、tmt=con.createStatement();/創(chuàng)建對(duì)象，該對(duì)象用來(lái)執(zhí)行命令Stringsql="select*fromstudent"ResultSetrs=stmt.executeQuery(sql);/執(zhí)行命令，返回執(zhí)行結(jié)果if(!rs.next()System.out.println("對(duì)不起，該數(shù)據(jù)庫(kù)可能還沒(méi)有創(chuàng)建信息!");while(rs.next()Stringid=rs.getString("id");Stringname=rs.getString("name");Stringmath=rs

7、.getString("math");Stringos=rs.getString("os");Stringjava=rs.getString("java");System.out.printf("%s,%s,%s,%s,%s%n",id,name,math,os,java);rs.close();stmt.close();/*按學(xué)號(hào)查詢學(xué)生信息*/publicvoidsearchByid()throwsExceptionSystem.out.print("請(qǐng)輸入所要查詢的學(xué)生的id號(hào)：");lo

8、ng_id=scanner.nextLong();Stringsql="select*fromstudentwhereid="+_id+""Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(sql);if(rs.next()longid=rs.getLong("id");Stringname=rs.getString("name");Doublemath=rs.getDouble("math");Doubleos=

9、rs.getDouble("os");Doublejava=rs.getDouble("java");System.out.println(id+""+name+""+math+""+os+"elseSystem.out.println("對(duì)不起，此學(xué)生信息不存在.");/*按學(xué)生姓名查詢*/publicvoidsearchByname()throwsExceptionSystem.out.print("請(qǐng)輸入所要查詢的學(xué)生的姓名：");Stri

10、ng_name=scanner.next();Stringsql="select*fromstudentwherename='"+_name+"'"Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(sql);if(rs.next()longid=rs.getLong("id");Stringname=rs.getString("name");Doublemath=rs.getDouble("math"

11、;);Doubleos=rs.getDouble("os");Doublejava=rs.getDouble("java");System.out.println(id+""+name+""+math+""+os+"elseSystem.out.println("對(duì)不起，此學(xué)生信息不存在.");publicvoiddeleteByid()throwsExceptionSystem.out.print("請(qǐng)輸入你要?jiǎng)h除學(xué)生信息的學(xué)號(hào)：");long

12、_id=scanner.nextLong();Stringsql="select*fromstudentwhereid="+_id+""Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(sql);"+java);"+java);"+java);if(rs.next()longid=rs.getLong("id");Stringname=rs.getString("name");Doublemath=rs.

13、getDouble("math");Doubleos=rs.getDouble("os");Doublejava=rs.getDouble("java");"+java);System.out.println(id+""+name+""+math+""+os+"elseSystem.out.println("對(duì)不起，此學(xué)生信息不存在.");Stringsql1="deletefromstudentwhereid="+

14、_id+""Statementstmt1=con.createStatement();stmt1.executeUpdate(sql1);publicstaticvoidmain(Stringargs)throwsExceptionStudent2stu=newStudent2();stu.init();/加載驅(qū)動(dòng)，創(chuàng)建鏈接。System.out.println("*歡迎進(jìn)入學(xué)生信息簡(jiǎn)單管理系統(tǒng)*");System.out.println("1.向數(shù)據(jù)庫(kù)中添加學(xué)生信息。");System.out.println("2.顯示數(shù)

15、據(jù)庫(kù)中所有學(xué)生信息。");System.out.println("3.按學(xué)號(hào)查詢學(xué)生信息。");System.out.println("4.按姓名查詢學(xué)生信息。");System.out.println("5.按學(xué)號(hào)刪除學(xué)生信息。");System.out.println("6.退出。");System.out.println(Il*");System.out.print("請(qǐng)輸入選擇序號(hào)：");intn=scanner.nextInt();while(n!=6)if(n=1

16、)stu.Add();elseif(n=2)stu.dispAll();elseif(n=3)stu.searchByid();elseif(n=4)stu.searchByname();elseif(n=5)stu.deleteByid();System.out.println（"*歡迎進(jìn)入學(xué)生信息簡(jiǎn)單管理系統(tǒng)*"）；System.out.println（"1.向數(shù)據(jù)庫(kù)中添加學(xué)生信息。”）;System.out.println（"2.顯示數(shù)據(jù)庫(kù)中所有學(xué)生信息。”）；System.out.println（"3.按學(xué)號(hào)查詢學(xué)生信息。"）

17、;System.out.println（"4.按姓名查詢學(xué)生信息。"）;System.out.println（"5.按學(xué)號(hào)刪除學(xué)生信息。"）;System.out.println（"6.退出。"）；System.out.println(System.out.println(“*“);System.out.print（"請(qǐng)輸入選擇序號(hào)："）;n=scanner.nextInt();stu.close();scanner.close();vDacunentsdCsttir£(sSAdninio'ti&

18、#39;atoi'o:*>2Java'vjova程嚴(yán)、實(shí)驗(yàn)穴E-ep.;hsqldt).Jaroi*g.hsqldh.SeurSet'ver(?19h4?e61-nipeadnainSinain1J:checkBunnln<faIse>enteredLSei'verl?19h4e61LEJweadnainSmainJ3:checkRunnin£f<false>exitedLServerl?19h49et:StartupsequenceinitiatedfranmiriOnetindSe%'verl?19hi19e6

19、J：LoadedpropertiesfrontE：javajaua程序買(mǎi)驗(yàn)六VsEPveE-ipFflpeirrieslServersocketopenedsuccessfullvin94msDcitahaeinclex=0.id=0.db=fHe：test.lias=JovenedsucessfuServersocketopenedsuccessfullvin94msDcitahaeinclex=0.id=0.db=fHe：test.lias=Jovenedsucessfu5et*ver(?19bS6:Initiatingstartupsequence-S&ruer«19b49eai：&Brverei9M9e&l：RtAPtiipRqnnr