package jbdc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import tools.DBUtil;
public class _5_update {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = DBUtil.getConn();
Statement smt = null;
/// 修改 //
try {
smt = conn.createStatement();
String sql = "update user set id = '20003' where xm='王妃'";
int i = smt.executeUpdate(sql);//如果修改成功那么返回的值大于0,不成功就返回0
if(i!=0)
System.out.println("修改成功");
else
System.out.println("修改失败");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Java—JDBC——Java操作数据库实现更新信息的功能
最新推荐文章于 2023-10-27 09:19:38 发布