import java.sql.*;
public class JDBCTWO {
public static void main(String args[]){
Connection con;
Statement stmt;
//ResultSet re;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracl",
"jeff","oracle"
);
stmt = con.createStatement();
stmt.executeUpdate("insert into OracleEmployees values('02','zhou wei','joe')");
}catch(Exception e){System.out.println(e.getMessage());}
}
}错误代码
Exception in thread "main" java.lang.VerifyError: (class: oracle/jdbc/driver/OracleDriver, method: <clinit> signature: ()V) Bad type in putfield/putstatic
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at JDBCTWO.main(JDBCTWO.java:8)
public class JDBCTWO {
public static void main(String args[]){
Connection con;
Statement stmt;
//ResultSet re;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracl",
"jeff","oracle"
);
stmt = con.createStatement();
stmt.executeUpdate("insert into OracleEmployees values('02','zhou wei','joe')");
}catch(Exception e){System.out.println(e.getMessage());}
}
}错误代码
Exception in thread "main" java.lang.VerifyError: (class: oracle/jdbc/driver/OracleDriver, method: <clinit> signature: ()V) Bad type in putfield/putstatic
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at JDBCTWO.main(JDBCTWO.java:8)
String url = "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf-8";
String user = "";
String psw = "";
Connection con = DriverManager.getConnection(url,user,psw); 试试这种方式
at java.lang.Class.forName(Unknown Source)
at JDBCTWO.main(JDBCTWO.java:8)
--------------------------------------------缺少jar包
安装oracle驱动包
你打开源码,看看你的oracle.jdbc.driver.OracleDriver这个能找到吗?
1,检查开发工具版本.
2,检查项目中web-inf/bin/是否存在相关oraclejar包.
其次,跟oracle环境变量无关系。谢谢
public static void main(String args[]) {
Connection con;
Statement stmt;
// ResultSet re;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracl",
"jeff","oracle");
stmt = con.createStatement();
stmt.executeUpdate("insert into emp(empno) values(1233)");
// ResultSet rs=stmt.executeQuery("select * from emp");
// while (rs.next()) {
// System.out.println(rs.getString(1));
// }
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}验证过后没问题
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracl",
"jeff","oracle"
);
实例化自动向DriverManager注册,不需要显示的调用DriverManager.registerDriver方法
这个问题好像是因为版本不对造成的。可能是JDK的问题