【JDBC与Mysql连接操作成功但是表格未更新 _JDBC 】

JDBC与Mysql连接操作成功但是表格未更新

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

JDBC

详细描述

public class StudentDAOImpl implements StudentDao {

Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

@Override
    public void addStudent(Student stu) {
        String sql = "INSERT INTO stu (id,create_at,update_at,name,qq,job,start_time,college,number,daily_url,wish,brother,referee,city,review) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
//    String sql = "INSERT INTO stu (create_at,update_at,name,qq,job,start_time,college,number,daily_url,wish,brother,referee,city,review) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

try {
            conn = DBUtil.getConnecttion();
            System.out.println(conn+"************************");
            pstmt = conn.prepareStatement(sql);
            pstmt.setLong(1, stu.getId());
            pstmt.setLong(2, stu.getCreate_at());
            pstmt.setLong(3, stu.getUpdate_at());
            pstmt.setString(4, stu.getName());
            pstmt.setInt(5, stu.getQq());
            pstmt.setString(6, stu.getJob());
            pstmt.setLong(7, stu.getStart_time());
            pstmt.setString(8, stu.getCollege());
            pstmt.setInt(9, stu.getNumber());
            pstmt.setString(10, stu.getDaily_url());
            pstmt.setString(11, stu.getWish());
            pstmt.setString(12, stu.getBrother());
            pstmt.setString(13, stu.getReferee());
            pstmt.setString(14, stu.getCity());
            pstmt.setString(15, stu.getReview());
            System.out.println("添加学生成功");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.closeAll(rs, pstmt, conn);
        }
    }

public class Test {
    public static void main(String[] args) {

//添加
        StudentDao sd=new StudentDAOImpl();
        sd.addStudent(new Student(11l,1l,2l,"曹非凡",123,"爪哇",3l,"牧专",123,"com",
                "money","王汇通","zhihu","zhengz","通过"));

错误截图

编辑于2024-11-21