读书人

Mysql中回来PreparedStatement执行后影

发布时间: 2012-09-25 09:55:58 作者: rapoo

Mysql中返回PreparedStatement执行后影响的记录条数

boolean autoCommit = conn.getAutoCommit();//手动提交事务,保证数据库数据的一致性。 conn.setAutoCommit(false);  int rootid = -1;  String sql = "insert into article values(null, ?, ?, ?, ?, now(), ?)"; PreparedStatement pstmt = DB.getPstmt(conn, sql, Statement.RETURN_GENERATED_KEYS); pstmt.setInt(1,0); pstmt.setInt(2,rootid); pstmt.setString(3,title); pstmt.setString(4,cont); pstmt.setInt(5,0); pstmt.executeUpdate();  ResultSet rsKey = pstmt.getGeneratedKeys(); rsKey.next(); rootid = rsKey.getInt(1);  Statement stmt = DB.createStmt(conn); stmt.executeUpdate("update article set rootid = " + rootid + " where id = " + rootid);  conn.commit(); conn.setAutoCommit(autoCommit);

读书人网 >Mysql

热点推荐