Java实习 通过JDBC方式操作数据库-1800字-计算机网络程序员软件工程文库

通过 JDBC 方式操作数据库1．实验目的（1）掌握通过 JDBC 方式操作数据库的基本步骤。（2）掌握增、删、改记录的方法。（3）掌握查询记录以及遍历查询结果的方法。2．实验内容实验题 1 学生信息管理函数。数据库中的信息参考 Exp9.1.txt，这些命令用来创建 student 表，包含学生的学号、姓名、年龄信息。① 根据学号，可以查询到学生的姓名和年龄；② 给定学生的学号、姓名、年龄，在表中追加一行信息；③ 给定学生的学号，可以从表中删除该学生的信息；[基本要求] 对上面的每一个功能编写相应的函数，并测试。具体实现的代码为：package loncyKao;import java.sql.*;import java.util.Scanner;public class MyJDBC {private static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生信息";private static final String USER_NAME = "sa";private static final String PASSWORD = "123456";private Connection conn;private Statement statement;static {try {Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");} catch (ClassNotFoundException e){e.printStackTrace();}}public MyJDBC() throws SQLException {conn = DriverManager.getConnection(URL,USER_NAME,PASSWORD);statement = conn.createStatement();}public void selectFunction(String number){String temp = "SELECT * FROM Student";System.out.println("----------查询的结果为：");try {ResultSet rs = statement.executeQuery(temp);System.out.printf("---学号-------姓名----年龄---\n");while(rs.next()){String No = rs.getString(1);String name = rs.getString(2);int age = rs.getInt(3);if(No.equals(number)){System.out.printf("%s %6s %4s\n",No,name,age);break;}}} catch (SQLException e) {e.printStackTrace();}return ;}public boolean appendFunction(String number,String name,int age){String str = "SELECT * FROM Student";String temp = "INSERT INTO Student VALUES('" + number + "','" + name + "'," + age + ")";System.out.println(temp);System.out.print("追加状态：");try {ResultSet rs = statement.executeQuery(str);while(rs.next()){String No = rs.getString(1);if(No.equals(number))break;}if(rs.next()){System.out.println("失败，原因：已存在主键为" + number + "的元组!");return false;}statement.executeUpdate(temp);System.out.println("成功!");} catch (SQLException e){e.printStackTrace();}return true;}public void deleteFunction(String number){String temp = "DELETE FROM Student WHERE Sno = " + number;try {statement.executeUpdate(temp);} catch (SQLException e){e.printStackTrace();} finally{System.out.println("删除成功!");}}public void closeFunction(){try {conn.close();statement.close();} catch (SQLException e) {e.printStackTrace();}return ;}public static void main(String[] args) {try {MyJDBC myJDBC = new MyJDBC();Scanner scanner = new Scanner(System.in);System.out.print("请输入要查询的学生的学号：");String No = scanner.next();myJDBC.selectFunction(No);System.out.println("------------------------------");System.out.println("请输入所要追加学生的信息：");System.out.print("学号：");No = scanner.next();System.out.print("姓名：");String name = scanner.next();System.out.print("年龄：");int age = scanner.nextInt();myJDBC.appendFunction(No, name, age);System.out.println("------------------------------");System.out.print("请输入所要删除学生信息的学号：");No = scanner.next();myJDBC.deleteFunction(No);myJDBC.closeFunctio...