sql update语句提示执行成功,但是结果却没有成功修改,这是为什么呢??急急急!!
下面是源代码
连接数据库代码
public static Connection getConnection() {
Connection conn=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println("失败1");
e.printStackTrace();
}
try {
conn=DriverManager.getConnection("jdbc:odbc:MYSQL", USER, PASSWORD);//账号密码都是对的
System.out.println("成功1");
} catch (SQLException e) {
System.out.println("失败2");
e.printStackTrace();
}
return conn;
}
下面这个方法是设置的2分钟执行一次,控制台打印的输出的内容:成功1
update equipment set ja_value = 100 where e_lifecalcway=1
但是我查看数据库中equipment 表中ja_value的值不为100.。这是为什么?
public void updateValueTask1(){
Connection conn = null;
PreparedStatement pst=null;
StringBuffer sql = new StringBuffer("update equipment set ja_value = 100 where e_lifecalcway=1");
try {
conn = CommUtil.getConnection();
pst = conn.prepareStatement(sql.toString());
System.out.println(sql.toString());
} catch (Exception e) {
e.printStackTrace();
System.out.println("失败3");
logger.debug(e.getMessage());
} finally {
try {
pst.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}