编译结果:
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 Test1.main(Test1.java:13)
import java.sql.*;
public class Test1 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
Statement sm=null;
try {
//加载驱动(把需要的驱动加入内存)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//得到连接(指定连接到哪个数据源)
ct=DriverManager.getConnection("jdbc:odbc:mytest");
//statement主要用于发送sql语句
sm=ct.createStatement();
//执行(crud)
//添加一条数据到dept表中
int i=sm.executeUpdate("insert into dept values('50','security','beijing')");
if(i==1)
{
System.out.println("insert success");
}
else
{
System.out.println("insert erro");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
//关闭资源
try {
if(sm!=null)
{
sm.close();
}
if(ct!=null){
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}