下面的代码是书上的,我执行了。但是出现SQL错误,请高手知道,数据库配置的对的!import java.sql.*;public class DB1_1 {
public static void main(String[] args) {
String url="jdbc:odbc:Demo";
String query="select * from ssb";
try{
Class.forName("sun.jdbc.odbd.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){}
try{
//DriverManager.setLogStream(System.out);
Connection con=DriverManager.getConnection(url);
System.out.println("\nSQL错误\n");
Statement stmt=con.createStatement();
stmt.executeUpdate("update ssb set NL=19 where XM='张二'");
stmt.executeUpdate("delete from ssb where XM='丁五'");
stmt.executeUpdate("inseru into ssb(XH,XM,XB,NL) value ('0006','曹六','男','19')");
ResultSet r=stmt.executeQuery(query);
while(r.next()){
String r1=r.getString("XM");
String r2=r.getString("XB");
int r3=r.getInt("NL");
System.out.println(r1+" "+r1+" "+r3);
}
r.close();
stmt.close();
con.close();
}catch(SQLException se)
{System.out.println("\n**************SQL错误******************\n"); }
}
}
public static void main(String[] args) {
String url="jdbc:odbc:Demo";
String query="select * from ssb";
try{
Class.forName("sun.jdbc.odbd.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){}
try{
//DriverManager.setLogStream(System.out);
Connection con=DriverManager.getConnection(url);
System.out.println("\nSQL错误\n");
Statement stmt=con.createStatement();
stmt.executeUpdate("update ssb set NL=19 where XM='张二'");
stmt.executeUpdate("delete from ssb where XM='丁五'");
stmt.executeUpdate("inseru into ssb(XH,XM,XB,NL) value ('0006','曹六','男','19')");
ResultSet r=stmt.executeQuery(query);
while(r.next()){
String r1=r.getString("XM");
String r2=r.getString("XB");
int r3=r.getInt("NL");
System.out.println(r1+" "+r1+" "+r3);
}
r.close();
stmt.close();
con.close();
}catch(SQLException se)
{System.out.println("\n**************SQL错误******************\n"); }
}
}
粗粗一看,jdbc:odbc 桥接 的,什么数据库啊,道不深,没看出来....
应该是values吧