1. 在数据库中创建一个表格 score, 用于存储学生成绩。 使用 JDBC 连接 Oracle 数据库, 向数据库中插入一条数据。 表格字段有: 学号、 姓名、 语文、 计算机、 数学。 2. 使用批处理方式删除上一题插入的数据, 并执行插入 10 条新数据。 3. 使用 JDBC 连接数据库, 更新上一题插入的前两条信息, 将数学成绩和计算机成绩对 换。 4. 使用 JDBC 连接数据库, 查询 score 表中所有数据。 5. 使用 JDBC 连接数据库, 删除 score 表中所有数据。

1. 创建 score 表格并插入一条数据：

import java.sql.*;

public class ScoreJDBC {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 创建 score 表格
            String createTable = "CREATE TABLE score (id NUMBER(10) PRIMARY KEY, name VARCHAR2(50), "
                    + "chinese NUMBER(3), computer NUMBER(3), math NUMBER(3))";
            stmt.executeUpdate(createTable);

            // 插入一条数据
            String insertData = "INSERT INTO score VALUES (1, '张三', 80, 90, 85)";
            stmt.executeUpdate(insertData);

            System.out.println("插入成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

2. 批量删除上一题插入的数据并插入 10 条新数据：

import java.sql.*;

public class ScoreJDBC {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 批量删除之前插入的数据
            String deleteData = "DELETE FROM score WHERE id = 1";
            stmt.addBatch(deleteData);
            stmt.executeBatch();

            // 批量插入新数据
            for (int i = 2; i <= 11; i++) {
                String insertData = "INSERT INTO score VALUES (" + i + ", '学生" + i + "', " 
                        + (60 + i) + ", " + (70 + i) + ", " + (80 + i) + ")";
                stmt.addBatch(insertData);
            }
            stmt.executeBatch();

            System.out.println("操作成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

3. 更新前两条数据的数学成绩和计算机成绩：

import java.sql.*;

public class ScoreJDBC {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 更新前两条数据的数学成绩和计算机成绩
            String updateData1 = "UPDATE score SET math=computer, computer=math WHERE id = 2";
            String updateData2 = "UPDATE score SET math=computer, computer=math WHERE id = 3";
            stmt.executeUpdate(updateData1);
            stmt.executeUpdate(updateData2);

            System.out.println("更新成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

4. 查询 score 表中所有数据：

import java.sql.*;

public class ScoreJDBC {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM score")) {

            System.out.println("id\tname\tchinese\tcomputer\tmath");
            while (rs.next()) {
                System.out.println(rs.getInt("id") + "\t" + rs.getString("name") + "\t" 
                        + rs.getInt("chinese") + "\t" + rs.getInt("computer") + "\t" 
                        + rs.getInt("math"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

5. 删除 score 表中所有数据：

import java.sql.*;

public class ScoreJDBC {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 删除 score 表中所有数据
            String deleteAllData = "DELETE FROM score";
            stmt.executeUpdate(deleteAllData);

            System.out.println("删除成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}