| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
fp34
10年前发布

jdbc连接mysql数据库执行insert语句后获取自增长的主键值

import java.sql.Connection;    import java.sql.PreparedStatement;    import java.sql.ResultSet;    import java.sql.SQLException;    import java.sql.Statement;        import cn.baokx.db.DatabaseConnection0;            public class Test1 {        public static void main(String[] args) {            Connection conn = new DatabaseConnection0().getConnection();            PreparedStatement pst = null;            ResultSet rs = null;            String sql = "INSERT INTO dz(date,time,s,w,deep,level,location)" +                    "VALUES('2014-01-01','05:03:44',25.6,122.4,260,6.2,'俄罗斯')";            try {                pst = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);                pst.executeUpdate();                rs = pst.getGeneratedKeys();                if(rs.next()){                    System.out.println(rs.getObject(1));                }            } catch (SQLException e) {                e.printStackTrace();            } finally{                try {                    rs.close();                    pst.close();                    conn.close();                } catch (SQLException e) {                    // TODO Auto-generated catch block                    e.printStackTrace();                }            }        }    }