package com.csdn.jdbc; import java.sql.*; public class GetAutoColumnValues { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.cj.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///fruitdb", "root", "123456"); String sql = "insert into t_fruit values(0,?,?,?,?)"; PreparedStatement psmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); //填充参数 psmt.setString(1,"哈密瓜"); psmt.setInt(2, 23); psmt.setInt(3, 230); psmt.setString(4, "很好吃"); int count = psmt.executeUpdate(); System.out.println(count > 0 ? "保存成功" : "保存失败"); ResultSet rs = psmt.getGeneratedKeys(); if (rs.next()) { long id = rs.getLong(1); System.out.println("这条记录的自增列的值是:" + id); } psmt.close(); } }
10-16
135
10-11
830
10-11
1200
10-05
584
博客
阿里云域名解析和备案
10-02
597
博客
阿里云域名注册购买和备案
10-01
631
09-30
232
博客
串行化执行、并行化执行
09-29
599