PreparedStatement pstmt = conn.prepareStatement("update Message set Title=?,Content=?," +
"AbateTime=?,ReceiveNodeID=?,Receiver=?,PublishTime=getdate() where MessageID="+MessageID);
pstmt.setString(1,Title.trim()); pstmt.setString(2,Content);
pstmt.setString(3,AbateTime); pstmt.setString(4,ReceiveNodeID);
pstmt.setString(5,Receiver);
pstmt.executeUpdate();
"AbateTime=?,ReceiveNodeID=?,Receiver=?,PublishTime=getdate() where MessageID="+MessageID);
pstmt.setString(1,Title.trim()); pstmt.setString(2,Content);
pstmt.setString(3,AbateTime); pstmt.setString(4,ReceiveNodeID);
pstmt.setString(5,Receiver);
pstmt.executeUpdate();
PreparedStatement属于java.sql包,他提供了一种更为方便的访问数据库的方法。PreparedStatement pstmt = conn.prepareStatement("select * from table where field1=? and field2=?");
pstmt.setString(1,变量1);//设置第一个?处的值
pstmt.setString(2,变量2);//设置第二个?处的值pstmt.executeQuery();