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

package cn.baokx;

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();
			}
		}
	}
}

展开阅读全文

没有更多推荐了,返回首页