|
发表于 2023-12-17 16:04:36
|
显示全部楼层
好的,下面是一个基于SQL Server 2014数据库的图书管理系统的增删改查示例代码。请确保已正确安装了Java和相应的JDBC驱动程序。import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class LibraryManagementSystem { // 数据库连接字符串 static final String DB_URL = "jdbc:sqlserver://localhost:1433;databaseName=选课系统"; // 数据库用户名和密码 static final String USER = "your_username"; static final String PASS = "your_password"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; try { // 注册 JDBC 驱动 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 打开连接 conn = DriverManager.getConnection(DB_URL, USER, PASS); // 创建 Statement 对象 stmt = conn.createStatement(); Scanner scanner = new Scanner(System.in); int choice = 0; while (choice != 5) { System.out.println("请选择操作:"); System.out.println("1. 查询图书信息"); System.out.println("2. 添加图书"); System.out.println("3. 更新图书信息"); System.out.println("4. 删除图书"); System.out.println("5. 退出"); choice = scanner.nextInt(); scanner.nextLine(); switch (choice) { case 1: // 查询图书信息 String selectSql = "SELECT * FROM Book"; ResultSet rs = stmt.executeQuery(selectSql); while (rs.next()) { int id = rs.getInt("id"); String bookName = rs.getString("book_name"); String name = rs.getString("name"); String jieData = rs.getString("jie_data"); String huanData = rs.getString("huan_data"); System.out.println("ID: " + id); System.out.println("Book Name: " + bookName); System.out.println("Name: " + name); System.out.println("Jie Data: " + jieData); System.out.println("Huan Data: " + huanData); System.out.println(); } break; case 2: // 添加图书信息 System.out.println("请输入图书名称:"); String newBookName = scanner.nextLine(); System.out.println("请输入作者姓名:"); String newName = scanner.nextLine(); System.out.println("请输入借阅日期:"); String newJieData = scanner.nextLine(); System.out.println("请输入归还日期:"); String newHuanData = scanner.nextLine(); String insertSql = "INSERT INTO Book(book_name, name, jie_data, huan_data) " + "VALUES('" + newBookName + "', '" + newName + "', '" + newJieData + "', '" + newHuanData + "')"; stmt.execute(insertSql); System.out.println("添加成功!"); break; case 3: // 更新图书信息 System.out.println("请输入要更新的图书ID:"); int updateId = scanner.nextInt(); scanner.nextLine(); System.out.println("请输入新的图书名称:"); String updateBookName = scanner.nextLine(); System.out.println("请输入新的作者姓名:"); String updateName = scanner.nextLine(); System.out.println("请输入新的借阅日期:"); String updateJieData = scanner.nextLine(); System.out.println("请输入新的归还日期:"); String updateHuanData = scanner.nextLine(); String updateSql = "UPDATE Book SET book_name='" + updateBookName + "', name='" + updateName + "', jie_data='" + updateJieData + "', huan_data='" + updateHuanData + "' WHERE id=" + updateId; stmt.execute(updateSql); System.out.println("更新成功!"); break; case 4: // 删除图书信息 System.out.println("请输入要删除的图书ID:"); int deleteId = scanner.nextInt(); scanner.nextLine(); String deleteSql = "DELETE FROM Book WHERE id=" + deleteId; stmt.execute(deleteSql); System.out.println("删除成功!"); break; case 5: // 退出 break; default: System.out.println("无效的选择,请重新输入!"); break; } } scanner.close(); // 关闭资源 stmt.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); if (conn != null) conn.close(); } catch (Exception e) { e.printStackTrace(); } } }}注意:在使用上述代码之前,请先将`your_username`和`your_password`替换为SQL Server的用户名和密码。此外,请根据实际情况修改数据库连接字符串和SQL语句。希望这个示例对你有帮助!如果你有更多问题,请随时提问。
以上回复来自 FishC AI 小助理,如未能正确解答您的问题,请继续追问。 |
|