String sql =
"insert into b_bjygksftfy (nian,yue,ri,ksmc,xm,zy,je) values ('" +
i_nian + "," + i_yue + "," + i_ri + "," + s_ksmc + "," + s_xm + "," +
s_zy + "," + f_je + "')";
语句的单引号有问题,字符串型的字段要用''
"insert into b_bjygksftfy (nian,yue,ri,ksmc,xm,zy,je) values ('" +
i_nian + "," + i_yue + "," + i_ri + "," + s_ksmc + "," + s_xm + "," +
s_zy + "," + f_je + "')";
语句的单引号有问题,字符串型的字段要用''
1.把sql打印出来到sqlplus执行
2.把各exception打印出来看出什么错以后有问题了,自己就知道解决了
{
con = java.sql.DriverManager.getConnection(databaseURL,user,password);
System.out.println("thdata数据库连接成功");
con.close(); //?? close 是否早些了;应在完成与数据库操作最后
才close的
}
说的试试,把con.close();去掉错误信息是什么?
con.close(); 数据库都关了,还提交个屁呀