当前页面: 开发资料首页 → J2EE 专题 → 书中的例子 现在有点错误 ，怎样更改

书中的例子 现在有点错误 ，怎样更改

摘要: 书中的例子 现在有点错误 ，怎样更改

我使用的access数据库 odbc 已经设置完毕
import java.sql.*;
public class InsertDataApp{
public InsertDataApp(){
}
public void insertData(){
Connection con=null;
try {
Class.forName("Sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Movie Catalog","","");
Statement Statement=con.CreateStatement();
Statement.executeUpdate("Insert into titles"+
"values(0,'the addentures of buckaroo banzai',"+
"'pg',19.95,10,0,4)");
Statement.executeUpdate("Insert into titles"+
"values(1,'saving private ryan',"+
"'r',19.95,10,0,4)");
}
catch(SQLException sqle){
// System.err.println(sqle.getMessage())
System.err.println(sqle.getMessage());
}
catch(ClassNotFoundException cnfe){
System.err.println(cnfe.getMessage());
}
catch(Exception e){
System.err.println(e.getMessage());
}
finally{
try{
if (con!=null){
con.close();
}
}
catch (SQLException sqle){
System.err.println(sqle.getMessage());
}
}
}
public static void main(String[] args){
InsertDataApp insertDataApp=new InsertDataApp();
InsertDataApp.insertData();
}
}



错误提示

F:/mycode/jdbc/InsertDataApp>
F:/mycode/jdbc/InsertDataApp>javac InsertDataApp.java
InsertDataApp.java:10: cannot resolve symbol
symbol : method CreateStatement ()
location: interface java.sql.Connection
Statement Statement=con.CreateStatement();
^
InsertDataApp.java:41: non-static method insertData() cannot be referenced from
a static context
InsertDataApp.insertData();
^
2 errors

F:/mycode/jdbc/InsertDataApp>

---

Statement Statement=con.createStatement();

注意大小写

---

InsertDataApp.insertData();

insertDataApp.insertData(); //还是大小写。。。。

---

谢谢 楼上的

我发错了，Statement Statement=con.createStatement(); 是这样的
错误提示是：
F:/mycode/jdbc/InsertDataApp>javac InsertDataApp.java
InsertDataApp.java:41: non-static method insertData() cannot be referenced from
a static context
InsertDataApp.insertData();
^
1 error

F:/mycode/jdbc/InsertDataApp>

---

哦 谢谢了 ，我为什么看不清楚 他是大写还是 小写呢

---