對這文章發表回應
發表限制: 非會員 可以發表
發表者: 冷日 發表時間: 2019/5/30 13:40:24
Java PreparedStatement - a SQL UPDATE example
Java SQL FAQ: Can you provide a Java PreparedStatement example that shows how to use a SQL UPDATE?
Sure. I have quite a few examples on this website, just see the "Related" section for those. But for now, here's a short sample method that performs a JDBC SQL UPDATE using a Java PreparedStatement:
// a java preparedstatement example
public static void updateDescriptionAndAuthor (
Connection conn,
String description,
int id,
int seqNum,
String author
)
throws SQLException
{
try
{
// create our java preparedstatement using a sql update query
PreparedStatement ps = conn.prepareStatement(
"UPDATE Messages SET description = ?, author = ? WHERE id = ? AND seq_num = ?");
// set the preparedstatement parameters
ps.setString(1,description);
ps.setString(2,author);
ps.setInt(3,id);
ps.setInt(4,seqNum);
// call executeUpdate to execute our sql update statement
ps.executeUpdate();
ps.close();
}
catch (SQLException se)
{
// log the exception
throw se;
}
}
I'll skip the description of this PreparedStatement
UPDATE example for now, but if you have any questions or comments, just leave them below, and I'll be glad to respond to them.
原文出處:Java PreparedStatement - a SQL UPDATE example | alvinalexander.com