java往access数据库中插入不进去记录
数据库连接成功,查询操作已经可以,但是插入操作编译,运行都通过,但就是数据库中没有插入进去记录.帮忙看看错误在那里.
public static void insertIntoDB(Packet pkt) //将标记信息存入数据库
{
Connection con;
Statement stml;
ResultSet rs;
// int rows=0;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:hbf","hbf","123");
stml=con.createStatement();
String sql = "insert into marking values("+1+","+pkt.distance+","+pkt.offset+","+pkt.mark+")";
stml.executeUpdate(sql);
con.close();}
catch(SQLException e2){}
//return rows;
}