欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

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

来源: javaer 分享于  点击 11599 次 点评:126

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


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();              }          }      }  }  
相关栏目:

用户点评