我的插入记录的代码为什么老报sql错误?
代码如下,一运行就报 INSERT INTO 语法错误,到底哪里出了问题了?
import java.sql.*;
import java.util.*;
public class sqltest
{
String sql = "insert into table2(name,number)values(?,?)";//表table2只有name和number 2个字段,一个文本,一个int
public void test()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cnn = DriverManager.getConnection("jdbc:odbc:board","","");
PreparedStatement pp = cnn.prepareStatement(sql);
pp.setString(1,"I am the First!!");
pp.setInt(2,2);
pp.executeUpdate();
System.out.println ("OK.");
}
catch(Exception e){e.printStackTrace();}
}
public static void main(String[] args)
{
sqltest tt = new sqltest();
tt.test();
}
}