用JAVA代码写的连接数据库学生信息管理系统.doc

保证程序运行无误，我都云新过了！import java.sql.*;import java.util.*;public class Student2 private static Scanner scanner =new Scanner(System.in); String driver = org.hsqldb.jdbcDriver; String url = jdbc:hsqldb:hsql:/localhost;/连接到本机上默认的数据库 String user=sa; String pass=; private Connection con; public void init()throws Exception if(con!=null) return;/已经初始化 Class.forName(driver); /装载驱动 con=DriverManager.getConnection(url,user,pass);/建立和数据库之间的连接 String sql=create table student(id bigint,name varchar(120),; sql+=os decimal,math decimal,java decimal); Statement stmt=con.createStatement(); stmt.executeUpdate(sql);/创建表，只执行一次。/在表中插入数据以备使用 public void close()throws Exception if(con!=null) con.close(); /*创建student 表，表中有id,name,math,os,java 五列*/ public void Add() throws Exception System.out.println(请输入学生学号：(当输入学号为-1时停止); long id=scanner.nextLong(); while(id!=-1) System.out.println(请输入该学生的名字：); String name=scanner.next(); System.out.println(请连续输入 os,math,java各科成绩：); double os=scanner.nextDouble(); double math=scanner.nextDouble(); double java=scanner.nextDouble(); String sql=insert into student values(?,?,?,?,?); PreparedStatement pstmt =con.prepareStatement(sql); pstmt.setLong(1,id); pstmt.setString(2,name); pstmt.setDouble(3,os); pstmt.setDouble(4,math); pstmt.setDouble(5,java); pstmt.execute(); pstmt.close(); System.out.println(请输入学生学号：(当输入学号为-1时停止); id=scanner.nextLong(); /*查询时使用Statement 的executeQuery 方法，其它用executeUpdate 方法*/ public void dispAll() throws Exception Statement stmt=con.createStatement(); /创建对象，该对象用来执行命令 String sql=select * from student; ResultSet rs=stmt.executeQuery(sql);/执行命令，返回执行结果 if(!rs.next() System.out.println(对不起，该数据库可能还没有创建信息!); while(rs.next() String id=rs.getString(id); String name=rs.getString(name); String math=rs.getString(math); String os=rs.getString(os); String java= rs.getString(java); System.out.printf(%s,%s,%s,%s,%s%n,id,name,math,os,java); rs.close();stmt.close(); /*按学号查询学生信息*/ public void searchByid()throws Exception System.out.print(请输入所要查询的学生的id号：); long _id=scanner.nextLong(); String sql=select*from student where id=+_id+; Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(sql); if(rs.next() long id=rs.getLong(id); String name=rs.getString(name); Double math=rs.getDouble(math); Double os=rs.getDouble(os); Double java=rs.getDouble(java); System.out.println(id+ +name+ +math+ +os+ +java); else System.out.println(对不起，此学生信息不存在.); /*按学生姓名查询*/ public void searchByname()throws Exception System.out.print(请输入所要查询的学生的姓名：); String _name=scanner.next(); String sql=select *from student where name=+_name+; Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(sql); if(rs.next() long id=rs.getLong(id); String name=rs.getString(name); Double math=rs.getDouble(math); Double os=rs.getDouble(os); Double java=rs.getDouble(java); System.out.println(id+ +name+ +math+ +os+ +java); else System.out.println(对不起，此学生信息不存在.); public void deleteByid()throws Exception System.out.print(请输入你要删除学生信息的学号：); long _id=scanner.nextLong(); String sql=select*from student where id=+_id+; Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(sql); if(rs.next() long id=rs.getLong(id); String name=rs.getString(name); Double math=rs.getDouble(math); Double os=rs.getDouble(os); Double java=rs.getDouble(java); System.out.println(id+ +name+ +math+ +os+ +java); else System.out.println(对不起，此学生信息不存在.); String sql1=delete from student where id=+_id+; Statement stmt1=con.createStatement(); stmt1.executeUpdate(sql1); public static void main(String args) throws Exception Student2 stu=new Student2(); stu.init();/加载驱动，创建链接。 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(*); System.out.print(请输入选择序号：); int n=scanner.nextInt(); while(n!=6) if(n=1) stu.Add(); else if(n=2) stu.dispAll(); else if(n=3) stu.searchByid(); else if(n=4) stu.searchByname(); else if(n=5) stu.deleteByid(); System.out.println(*欢迎进入学生信息简单管理系统*); System.out.println(1.向数据库中添加学生信息。); System.out.println(2.显示数据库中所有学生信息。); System.out.println(3.按学号查询学生信息。); System.out.println(4.按姓名查