public void updateData(){
String sql = "update t_a set fok = 1 where fid = ?";
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(0,"001");
ps.executeUpdate();
ps.close();
conn.close();
}
String sql = "update t_a set fok = 1 where fid = ?";
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(0,"001");
ps.executeUpdate();
ps.close();
conn.close();
}
2.int iRst = ps.executeUpdate();
最好将数据库操作写成存储过程,哪怕是一句sql,也会出现操作异常。
try {
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(0,"001");
ps.executeUpdate();
} catch(Exception e) {
} finally {
ps.close();
conn.close();
}
不会看错吧?
ps.setString(1,"001");