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 testInsert {
    public static void insert(User u) throws SQLException {
        Connection connection = null;
        try {
            //获取连接
            connection = Utils.getConnection();
            //拼接带有占位符的sql字符串，将传入的数据使用占位符编写
            String sql = "insert into user(id,name)values(?,?)";
            //创建能处理预编译的sql语句的对象PreparedStatement
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            //使用参数对象替换预编译sql语句中的占位符
            preparedStatement.setInt(1, u.getId());
            preparedStatement.setString(2, u.getName());
            //执行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(5);
        u.setName("5");
        insert(u);
    }
}