PreparedStatement修改数据

修改数据

package com.javakc.test1;

import com.javakc.db.Utils;
import com.javakc.vo.User;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class testUpdate {
    public static void update(User u) throws SQLException {
        Connection connection = null;
        try {
            //获得连接
            connection = Utils.getConnection();
            //拼接带有占位符的sql字符串，将传入的数据使用占位符编写
            String sql = "update user set name=? where id=?";
            //创建能处理预编译的sql语句的对象PreparedStatement
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            //使用参数对象替换预编译sql语句中的占位符
            preparedStatement.setString(1, u.getName());
            preparedStatement.setInt(2, u.getId());
            //执行sql,返回操作的条数
            int rows = preparedStatement.executeUpdate();
            System.out.println(rows);
            preparedStatement.close();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //关闭连接
            if (connection != null) {
                connection.close();
            }
        }
    }

    public static void main(String[] args) throws SQLException {
        User u = new User();
        u.setId(3);
        u.setName("3");
        update(u);
    }
}