Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class JDBCGetAutoIncKeys {
- private static final String DBURL =
- "jdbc:mysql://localhost:3306/mydb?user=usr&password=sql" +
- "&useUnicode=true&characterEncoding=UTF-8";
- private static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
- static {
- try {
- Class.forName(DBDRIVER).newInstance();
- } catch (Exception e){
- e.printStackTrace();
- }
- }
- private static Connection getConnection()
- {
- Connection connection = null;
- try {
- connection = DriverManager.getConnection(DBURL);
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- return connection;
- }
- public static void main(String[] args) {
- Statement stmt = null;
- ResultSet rs = null;
- Connection conn = null;
- try {
- conn = getConnection();
- stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
- java.sql.ResultSet.CONCUR_UPDATABLE);
- stmt.executeUpdate("DROP TABLE IF EXISTS autoincSample");
- stmt.executeUpdate(
- "CREATE TABLE autoincSample ("
- + "id INT NOT NULL AUTO_INCREMENT, "
- + "data VARCHAR(64), PRIMARY KEY (id))");
- stmt.executeUpdate(
- "INSERT INTO autoincSample (data) "
- + "values ('Record ----- 1')",
- Statement.RETURN_GENERATED_KEYS);
- rs = stmt.getGeneratedKeys();
- while (rs.next()) {
- System.out.println("Key returned from getGeneratedKeys():"
- + rs.getInt(1));
- }
- rs.close();
- }
- catch(Exception e) {
- e.printStackTrace();
- }
- finally {
- if (rs != null) {
- try {
- rs.close();
- } catch (SQLException ex) {
- }
- }
- if (stmt != null) {
- try {
- stmt.close();
- } catch (SQLException ex) {
- }
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement