Category Archives: jdbc

SqlExecuter vs JDBC

Posted on October 25, 2011 by lorddisk

public class CmdExec { public static void main(String argv[]) { executeSql(); } private static void executeSql() { final class SqlExecuter extends SQLExec { public SqlExecuter() { Project project = new Project(); project.init(); setProject(project); // setTaskType(“sql”); setTaskName(“sql”); } } SqlExecuter executer … Continue reading →

Posted in java, jdbc, mysql | Comments Off on SqlExecuter vs JDBC

how to get last insert id by java

Posted on October 19, 2011 by lorddisk

public static int getLastInsertID(Connection conn, String statment)throws SQLException { int lastInsertedId = -1; PreparedStatement ps = conn.prepareStatement(statment,PreparedStatement.RETURN_GENERATED_KEYS); ps.executeUpdate(); ResultSet rskey = ps.getGeneratedKeys(); if (rskey != null && rskey.next()) { lastInsertedId = rskey.getInt(1); } return lastInsertedId; }

Posted in java, jdbc, mysql | Tagged , , , | Comments Off on how to get last insert id by java