数据库更新

package com.edu;
import java.sql.*;//导入包

public class TestUpdate {

public static void main(String[] args) {
try {
//加载并注册驱动程序
Class.forName("com.mysql.jdbc.Driver");
//定义连接字符串
String url="jdbc:mysql:///test";
//连接数据库
Connection conn=DriverManager.getConnection(url, "root", "root");
//sql语句
String sql="update users set name=?,sex=?,age=?,addr=? where name=?";
//预置对象
PreparedStatement pstmt=conn.prepareStatement(sql);
//设置占位符值
pstmt.setString(1, "张三");
pstmt.setString(2, "男");
pstmt.setInt(3, 20);
pstmt.setString(4, "河北省石家庄市");
pstmt.setString(5, "lili");

//执行sql语句，返回影响行数
int res=pstmt.executeUpdate();
if(res>0){
System.out.println("更新数据成功");
}
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}