import java.sql.*;
import java.util.Scanner;
public class 图书管理 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("创建驱动成功");
Connection con=DriverManager.getConnection("jdbc:odbc:book","sa","");
System.out.println("连接数据库成功");
Statement stmt=con.createStatement();//数据库能与SQL语句互换
//添加图书
Scanner yi=new Scanner(System.in);
System.out.print("请输入一个需要添加的书名:");
String h=yi.next();
System.out.print("请输入作者名:");
String g=yi.next();
System.out.print("请输入出版日期(格式:xxxx-xx-xx)");
String j=yi.next();
System.out.print("请输入价格:");
String f=yi.next();
System.out.print("请输入数量");
String v=yi.next();
String sql="Insert into books(bookname, writer, publicationday, price, number) Values('h','g','j','f','v')";
stmt.executeUpdate(sql);
System.out.println("添加成功");
}
}
高手帮我看看那里错了阿