sample-code.zip_netbean 学生_学生

import java.sql.*; public class BooksTestJDBC{ public static void main(String[] args)throws Exception{ int option; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // change path to where the database file is stored String database="jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:\\sd\\Books.accdb"; Connection connection=DriverManager.getConnection(database); do{ System.out.println("0:quit, 1:insert, 2:update price, 3:delete, 4: display"); option=Input.getInteger("select option: "); switch(option){ case 1: insert(connection); break; case 2: update(connection); break; case 3: delete(connection); break; case 4: display(connection); } }while(option!=0); connection.close(); } private static void delete(Connection connection) throws Exception{ display(connection); int id=Input.getInteger("select id: "); Statement statement=connection.createStatement(); statement.executeUpdate("delete from books where id="+id); statement.close(); } private static void display(Connection connection)throws Exception{ Statement statement=connection.createStatement(); ResultSet results=statement.executeQuery("select * from books"); System.out.println(String.format("%-10s%-20s%-30s%10s","ID","AUTHOR","TITLE","PRICE")); while(results.next()) System.out.println(String.format("%-10s%-20s%-30s%10.2f",results.getInt("Id"), results.getString("Author"),results.getString("Title"),results.getDouble("Price"))); results.close(); statement.close(); } private static void insert(Connection connection) throws Exception{ String author=Input.getString("input author: "); String title=Input.getString("input title: "); double price=Input.getDouble("input price: "); Statement statement=connection.createStatement(); statement.executeUpdate("insert into books (author,title,price) values('"+author+"','"+title+"',"+price+")"); statement.close(); } private static void update(Connection connection) throws Exception{ display(connection); int id=Input.getInteger("select id: "); double price=Input.getDouble("input new price: "); Statement statement=connection.createStatement(); statement.executeUpdate("update books set price="+price+" where id="+id); statement.close(); } }