(我是刚刚做数据库的,所以尽可能通熟易懂一点,麻烦了)
package teachertest;
import java.sql.*;
import java.io.*;
/**
*@ (#)UpdateEmp.java
*/
class UpdateEmp{
public static void main(String argv[]){
String empName="";
int empAge=0;
float empSal=0;
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
try{
System.out.print("请输入姓名:");
empName=br.readLine();
System.out.print("请输入年龄:");
empAge=Integer.parseInt(br.readLine());
System.out.print("请输入工资:");
empSal=Float.parseFloat(br.readLine());
}
catch(Exception e){System.out.println(e.toString());}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url= "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\数据\\eclipse workspace\\teachertest\\src\\teachertest\\employees.mdb";
Connection con=DriverManager.getConnection(url);
System.out.print(con);
Statement stmt=con.createStatement();
stmt.executeUpdate("insert into employee (name,age,salary) values('"+empName+"',"+empAge+","+empSal+")");
System.out.println("insert Successded");
stmt.close();
con.close();
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
错误:null
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:453)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at teachertest.UpdateEmp.main(UpdateEmp.java:32)