1. sqlserver 2008 r2 or later. 2. user name 01004 or 01005, password 01004, or 01005 3. login will insert a record into yb_rz and update a record in yc_yg. 4. login without commit will lock the tables and manully commit will unlock. transaction without a commit, e.g, TransactionStatus staus = this.transactionManager.getTransaction(this.def); { String sql = ""; sql = "delete yb_dbys5 where pkid = " + id; iReturn = this.jdbcTemplate.update(sql); } this.transactionManager.commit(staus); } catch (DataAccessException e) { this.transactionManager.rollback(staus); throw e; } return iReturn;