一段很简单很简单的jdbc源码,但就是有问题!!!
import java.sql.*;
class test
{
public static void main(String[] args)
{
Connection con=null;
try
{
Class.forName("oracle.jdbc.OracleDriver");
}
catch(Exception e)
{
System.out.println("could not load drive!");
System.exit(-1);
}
try
{
con=DriverManager.getConnection(args[0]);
}
catch(Exception e)
{
System.out.println("can not get connection!");
System.out.println(e.getMessage());
System.exit(-1);
}
try
{
Statement stmt=con.createStatement();
int res=stmt.executeUpdate("create table employees3"
+"(emp_id number(10,0)not null primary key"
+",first_name varchar2(20)not null"
+",surname varchar2(100)not null)");
System.out.println("create Employee tables res="+res);
stmt.executeUpdate("insert into employees3"
+"values(1,'gale','bird')");
stmt.executeUpdate("insert into employees3"
+"values(2,'Jack','London')");
System.out.println("create two employees res");
stmt.close();
con.close();
}
catch(Exception e)
{
System.out.println("unexperted sql errors!");
System.out.println(e.getMessage());
System.exit(-1);
}
}
}
import java.sql.*;
class test
{
public static void main(String[] args)
{
Connection con=null;
try
{
Class.forName("oracle.jdbc.OracleDriver");
}
catch(Exception e)
{
System.out.println("could not load drive!");
System.exit(-1);
}
try
{
con=DriverManager.getConnection(args[0]);
}
catch(Exception e)
{
System.out.println("can not get connection!");
System.out.println(e.getMessage());
System.exit(-1);
}
try
{
Statement stmt=con.createStatement();
int res=stmt.executeUpdate("create table employees3"
+"(emp_id number(10,0)not null primary key"
+",first_name varchar2(20)not null"
+",surname varchar2(100)not null)");
System.out.println("create Employee tables res="+res);
res+=stmt.executeUpdate("insert into employees3"
+"values(1,'gale','bird')");
res+=stmt.executeUpdate("insert into employees3"
+"values(2,'Jack','London')");
System.out.println("create two employees res="+res);
stmt.close();
con.close();
}
catch(Exception e)
{
System.out.println("unexperted sql errors!");
System.out.println(e.getMessage());
System.exit(-1);
}
}
}
---------------------------------------------------------------------
于是我执行java test
"jdbc:oracle:thin:system/birdyan@localhost:1521:birdyan"
birdyan是我数据库的名字,执行后输出如下:
create Employee tables res=0
unexperted sql errors!
缺少select关键字
看来是插入时的问题,问题在哪里呢?和select什么关系啊?