快死人了,大家帮忙看看吧 那就commit一下看看还有ex.printStackTrace(); 难道没有异常报出来吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 就是根据打印出的update的SQL没有提交 首先确定哪里的问题在你觉得可疑的地方加句System.out.println()常规的调试方法,还是要先学习一下的 如果System.out.println(sql)打印不出来的话肯定有问题了........你有没有部署上去....你可以用debug看一下..你一步一步的看... String sql = ...System.out.println(sql);把打印出来的sql 手工执行一下看看吧 我把打印出的SQL执行过了,就是因为没有提交 你要把sql打印出来..最好在输出的时候像这样,容易找到.System.out.println(sql + "---------------------sql-------------------");exception 有吗... public class JdbcTemplate extends JdbcAccessor implements JdbcOperations { // Fields private NativeJdbcExtractor nativeJdbcExtractor; private boolean ignoreWarnings; private int fetchSize; private int maxRows; // Constructors public JdbcTemplate() { } public JdbcTemplate(DataSource dataSource) { } public JdbcTemplate(DataSource dataSource, boolean lazyInit) { } // Methods public void setNativeJdbcExtractor(NativeJdbcExtractor extractor) { } public NativeJdbcExtractor getNativeJdbcExtractor() { return null;} public void setIgnoreWarnings(boolean ignoreWarnings) { } public boolean isIgnoreWarnings() { return false;} public void setFetchSize(int fetchSize) { } public int getFetchSize() { return 0;} public void setMaxRows(int maxRows) { } public int getMaxRows() { return 0;} public Object execute(ConnectionCallback action) throws DataAccessException { return null;} protected Connection createConnectionProxy(Connection con) { return null;} public Object execute(StatementCallback action) throws DataAccessException { return null;} public void execute(String sql) throws DataAccessException { } public Object query(String sql, ResultSetExtractor rse) throws DataAccessException { return null;} public List query(String sql, RowCallbackHandler rch) throws DataAccessException { return null;} public List query(String sql, RowMapper rowMapper) throws DataAccessException { return null;} public Map queryForMap(String sql) throws DataAccessException { return null;} public Object queryForObject(String sql, RowMapper rowMapper) throws DataAccessException { return null;} public Object queryForObject(String sql, Class requiredType) throws DataAccessException { return null;} public long queryForLong(String sql) throws DataAccessException { return 0L;} public int queryForInt(String sql) throws DataAccessException { return 0;} public List queryForList(String sql, Class elementType) throws DataAccessException { return null;} public List queryForList(String sql) throws DataAccessException { return null;} public SqlRowSet queryForRowSet(String sql) throws DataAccessException { return null;} public int update(String sql) throws DataAccessException { return 0;} public int[] batchUpdate(String[] sql) throws DataAccessException { return null;} public Object execute(PreparedStatementCreator psc, PreparedStatementCallback action) throws DataAccessException { return null;} public Object execute(String sql, PreparedStatementCallback action) throws DataAccessException { return null;} public Object query(PreparedStatementCreator psc, PreparedStatementSetter pss, ResultSetExtractor rse) throws DataAccessException { return null;} public Object query(PreparedStatementCreator psc, ResultSetExtractor rse) throws DataAccessException { return null;} public Object query(String sql, PreparedStatementSetter pss, ResultSetExtractor rse) throws DataAccessException { return null;} public Object query(String sql, Object[] args, int[] argTypes, ResultSetExtractor rse) throws DataAccessException { return null;} public Object query(String sql, Object[] args, ResultSetExtractor rse) throws DataAccessException { return null;} public List query(PreparedStatementCreator psc, RowCallbackHandler rch) throws DataAccessException { return null;} public List query(String sql, PreparedStatementSetter pss, RowCallbackHandler rch) throws DataAccessException { return null;} public List query(String sql, Object[] args, int[] argTypes, RowCallbackHandler rch) throws DataAccessException { return null;} public List query(String sql, Object[] args, RowCallbackHandler rch) throws DataAccessException { return null;} public List query(PreparedStatementCreator psc, RowMapper rowMapper) throws DataAccessException { return null;} public List query(String sql, PreparedStatementSetter pss, RowMapper rowMapper) throws DataAccessException { return null;} public List query(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) throws DataAccessException { return null;} public List query(String sql, Object[] args, RowMapper rowMapper) throws DataAccessException { return null;} public Object queryForObject(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) throws DataAccessException { return null;} public Object queryForObject(String sql, Object[] args, RowMapper rowMapper) throws DataAccessException { return null;} public Object queryForObject(String sql, Object[] args, int[] argTypes, Class requiredType) throws DataAccessException { return null;} public Object queryForObject(String sql, Object[] args, Class requiredType) throws DataAccessException { return null;} public Map queryForMap(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;} public Map queryForMap(String sql, Object[] args) throws DataAccessException { return null;} public long queryForLong(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0L;} public long queryForLong(String sql, Object[] args) throws DataAccessException { return 0L;} public int queryForInt(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0;} public int queryForInt(String sql, Object[] args) throws DataAccessException { return 0;} public List queryForList(String sql, Object[] args, int[] argTypes, Class elementType) throws DataAccessException { return null;} public List queryForList(String sql, Object[] args, Class elementType) throws DataAccessException { return null;} public List queryForList(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;} public List queryForList(String sql, Object[] args) throws DataAccessException { return null;} public SqlRowSet queryForRowSet(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;} public SqlRowSet queryForRowSet(String sql, Object[] args) throws DataAccessException { return null;} protected int update(PreparedStatementCreator psc, PreparedStatementSetter pss) throws DataAccessException { return 0;} public int update(PreparedStatementCreator psc) throws DataAccessException { return 0;} public int update(PreparedStatementCreator psc, KeyHolder generatedKeyHolder) throws DataAccessException { return 0;} public int update(String sql, PreparedStatementSetter pss) throws DataAccessException { return 0;} public int update(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0;} public int update(String sql, Object[] args) throws DataAccessException { return 0;} public int[] batchUpdate(String sql, BatchPreparedStatementSetter pss) throws DataAccessException { return null;} public Object execute(CallableStatementCreator csc, CallableStatementCallback action) throws DataAccessException { return null;} public Object execute(String callString, CallableStatementCallback action) throws DataAccessException { return null;} public Map call(CallableStatementCreator csc, List declaredParameters) throws DataAccessException { return null;} protected Map extractReturnedResultSets(CallableStatement cs, List parameters, int updateCount) throws SQLException { return null;} protected Map extractOutputParameters(CallableStatement cs, List parameters) throws SQLException { return null;} protected Map processResultSet(ResultSet rs, ResultSetSupportingSqlParameter param) throws SQLException { return null;} protected RowMapper getColumnMapRowMapper() { return null;} protected RowMapper getSingleColumnRowMapper(Class requiredType) { return null;} protected void applyStatementSettings(Statement stmt) throws SQLException { } private void throwExceptionOnWarningIfNotIgnoringWarnings(SQLWarning warning) throws SQLWarningException { } private static String getSql(Object sqlProvider) { return null;} // Inner classes class RowCallbackHandlerResultSetExtractor implements ResultSetExtractor { // Fields private final RowCallbackHandler rch; // Constructors public RowCallbackHandlerResultSetExtractor(RowCallbackHandler rch) { } // Methods public Object extractData(ResultSet rs) throws SQLException { return null;} } class ArgTypePreparedStatementSetter implements PreparedStatementSetter, ParameterDisposer { // Fields private final Object[] args; private final int[] argTypes; // Constructors public ArgTypePreparedStatementSetter(Object[] args, int[] argTypes) { } // Methods public void setValues(PreparedStatement ps) throws SQLException { } public void cleanupParameters() { } } class ArgPreparedStatementSetter implements PreparedStatementSetter, ParameterDisposer { // Fields private final Object[] args; // Constructors public ArgPreparedStatementSetter(Object[] args) { } // Methods public void setValues(PreparedStatement ps) throws SQLException { } public void cleanupParameters() { } } class SimpleCallableStatementCreator implements CallableStatementCreator, SqlProvider { // Fields private final String callString; // Constructors public SimpleCallableStatementCreator(String callString) { } // Methods public CallableStatement createCallableStatement(Connection con) throws SQLException { return null;} public String getSql() { return null;} } class SimplePreparedStatementCreator implements PreparedStatementCreator, SqlProvider { // Fields private final String sql; // Constructors public SimplePreparedStatementCreator(String sql) { } // Methods public PreparedStatement createPreparedStatement(Connection con) throws SQLException { return null;} public String getSql() { return null;} } class CloseSuppressingInvocationHandler implements InvocationHandler { // Fields private final Connection target; // Constructors public CloseSuppressingInvocationHandler(JdbcTemplate target, Connection null) { } // Methods public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { return null;} }} 我找了很久,错误原因可能是两点:1.数据有问题(但是你说没有问题)2.你没有配置事务,你应该配置一下(org.springframework.jdbc.datasource.DataSourceTransactionManager) 应该是lz没有做事务处理仔细阅读一下下面的文章:http://hi.baidu.com/lxx2844/blog/item/2545be9b64cb3ab6c8eaf401.html freemarker 循环问题 如何获取一个工程中方法的调用关系,寻觅很多年 关于Struts2 乱码问题!MySQL数据库一旦设置过编码就Unknown initial character set index '45' 初学AXIS 对初学者来说,这的确很奇怪.... ERP产品 Struts 问题,关于<html:checkbox>标签 如何在JBuilder9中使用JDOM Tomcat好像有JBoss-Tomcat,Jakarta-Tomcat什么的,我用哪一个? 很简单的问题,我很菜,请帮助!谢谢! 如何用Http协议传输XML的问题 问几个基础问题,关于java的数据结构等
在你觉得可疑的地方加句System.out.println()常规的调试方法,还是要先学习一下的
你有没有部署上去....
你可以用debug看一下..你一步一步的看...
System.out.println(sql);把打印出来的sql 手工执行一下看看吧
exception 有吗...
public class JdbcTemplate extends JdbcAccessor implements JdbcOperations { // Fields
private NativeJdbcExtractor nativeJdbcExtractor;
private boolean ignoreWarnings;
private int fetchSize;
private int maxRows; // Constructors
public JdbcTemplate() { }
public JdbcTemplate(DataSource dataSource) { }
public JdbcTemplate(DataSource dataSource, boolean lazyInit) { } // Methods
public void setNativeJdbcExtractor(NativeJdbcExtractor extractor) { }
public NativeJdbcExtractor getNativeJdbcExtractor() { return null;}
public void setIgnoreWarnings(boolean ignoreWarnings) { }
public boolean isIgnoreWarnings() { return false;}
public void setFetchSize(int fetchSize) { }
public int getFetchSize() { return 0;}
public void setMaxRows(int maxRows) { }
public int getMaxRows() { return 0;}
public Object execute(ConnectionCallback action) throws DataAccessException { return null;}
protected Connection createConnectionProxy(Connection con) { return null;}
public Object execute(StatementCallback action) throws DataAccessException { return null;}
public void execute(String sql) throws DataAccessException { }
public Object query(String sql, ResultSetExtractor rse) throws DataAccessException { return null;}
public List query(String sql, RowCallbackHandler rch) throws DataAccessException { return null;}
public List query(String sql, RowMapper rowMapper) throws DataAccessException { return null;}
public Map queryForMap(String sql) throws DataAccessException { return null;}
public Object queryForObject(String sql, RowMapper rowMapper) throws DataAccessException { return null;}
public Object queryForObject(String sql, Class requiredType) throws DataAccessException { return null;}
public long queryForLong(String sql) throws DataAccessException { return 0L;}
public int queryForInt(String sql) throws DataAccessException { return 0;}
public List queryForList(String sql, Class elementType) throws DataAccessException { return null;}
public List queryForList(String sql) throws DataAccessException { return null;}
public SqlRowSet queryForRowSet(String sql) throws DataAccessException { return null;}
public int update(String sql) throws DataAccessException { return 0;}
public int[] batchUpdate(String[] sql) throws DataAccessException { return null;}
public Object execute(PreparedStatementCreator psc, PreparedStatementCallback action) throws DataAccessException { return null;}
public Object execute(String sql, PreparedStatementCallback action) throws DataAccessException { return null;}
public Object query(PreparedStatementCreator psc, PreparedStatementSetter pss, ResultSetExtractor rse) throws DataAccessException { return null;}
public Object query(PreparedStatementCreator psc, ResultSetExtractor rse) throws DataAccessException { return null;}
public Object query(String sql, PreparedStatementSetter pss, ResultSetExtractor rse) throws DataAccessException { return null;}
public Object query(String sql, Object[] args, int[] argTypes, ResultSetExtractor rse) throws DataAccessException { return null;}
public Object query(String sql, Object[] args, ResultSetExtractor rse) throws DataAccessException { return null;}
public List query(PreparedStatementCreator psc, RowCallbackHandler rch) throws DataAccessException { return null;}
public List query(String sql, PreparedStatementSetter pss, RowCallbackHandler rch) throws DataAccessException { return null;}
public List query(String sql, Object[] args, int[] argTypes, RowCallbackHandler rch) throws DataAccessException { return null;}
public List query(String sql, Object[] args, RowCallbackHandler rch) throws DataAccessException { return null;}
public List query(PreparedStatementCreator psc, RowMapper rowMapper) throws DataAccessException { return null;}
public List query(String sql, PreparedStatementSetter pss, RowMapper rowMapper) throws DataAccessException { return null;}
public List query(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) throws DataAccessException { return null;}
public List query(String sql, Object[] args, RowMapper rowMapper) throws DataAccessException { return null;}
public Object queryForObject(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) throws DataAccessException { return null;}
public Object queryForObject(String sql, Object[] args, RowMapper rowMapper) throws DataAccessException { return null;}
public Object queryForObject(String sql, Object[] args, int[] argTypes, Class requiredType) throws DataAccessException { return null;}
public Object queryForObject(String sql, Object[] args, Class requiredType) throws DataAccessException { return null;}
public Map queryForMap(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;}
public Map queryForMap(String sql, Object[] args) throws DataAccessException { return null;}
public long queryForLong(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0L;}
public long queryForLong(String sql, Object[] args) throws DataAccessException { return 0L;}
public int queryForInt(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0;}
public int queryForInt(String sql, Object[] args) throws DataAccessException { return 0;}
public List queryForList(String sql, Object[] args, int[] argTypes, Class elementType) throws DataAccessException { return null;}
public List queryForList(String sql, Object[] args, Class elementType) throws DataAccessException { return null;}
public List queryForList(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;}
public List queryForList(String sql, Object[] args) throws DataAccessException { return null;}
public SqlRowSet queryForRowSet(String sql, Object[] args, int[] argTypes) throws DataAccessException { return null;}
public SqlRowSet queryForRowSet(String sql, Object[] args) throws DataAccessException { return null;}
protected int update(PreparedStatementCreator psc, PreparedStatementSetter pss) throws DataAccessException { return 0;}
public int update(PreparedStatementCreator psc) throws DataAccessException { return 0;}
public int update(PreparedStatementCreator psc, KeyHolder generatedKeyHolder) throws DataAccessException { return 0;}
public int update(String sql, PreparedStatementSetter pss) throws DataAccessException { return 0;}
public int update(String sql, Object[] args, int[] argTypes) throws DataAccessException { return 0;}
public int update(String sql, Object[] args) throws DataAccessException { return 0;}
public int[] batchUpdate(String sql, BatchPreparedStatementSetter pss) throws DataAccessException { return null;}
public Object execute(CallableStatementCreator csc, CallableStatementCallback action) throws DataAccessException { return null;}
public Object execute(String callString, CallableStatementCallback action) throws DataAccessException { return null;}
public Map call(CallableStatementCreator csc, List declaredParameters) throws DataAccessException { return null;}
protected Map extractReturnedResultSets(CallableStatement cs, List parameters, int updateCount) throws SQLException { return null;}
protected Map extractOutputParameters(CallableStatement cs, List parameters) throws SQLException { return null;}
protected Map processResultSet(ResultSet rs, ResultSetSupportingSqlParameter param) throws SQLException { return null;}
protected RowMapper getColumnMapRowMapper() { return null;}
protected RowMapper getSingleColumnRowMapper(Class requiredType) { return null;}
protected void applyStatementSettings(Statement stmt) throws SQLException { }
private void throwExceptionOnWarningIfNotIgnoringWarnings(SQLWarning warning) throws SQLWarningException { }
private static String getSql(Object sqlProvider) { return null;}
class RowCallbackHandlerResultSetExtractor implements ResultSetExtractor { // Fields
private final RowCallbackHandler rch; // Constructors
public RowCallbackHandlerResultSetExtractor(RowCallbackHandler rch) { } // Methods
public Object extractData(ResultSet rs) throws SQLException { return null;}
} class ArgTypePreparedStatementSetter implements PreparedStatementSetter, ParameterDisposer { // Fields
private final Object[] args;
private final int[] argTypes; // Constructors
public ArgTypePreparedStatementSetter(Object[] args, int[] argTypes) { } // Methods
public void setValues(PreparedStatement ps) throws SQLException { }
public void cleanupParameters() { }
} class ArgPreparedStatementSetter implements PreparedStatementSetter, ParameterDisposer { // Fields
private final Object[] args; // Constructors
public ArgPreparedStatementSetter(Object[] args) { } // Methods
public void setValues(PreparedStatement ps) throws SQLException { }
public void cleanupParameters() { }
} class SimpleCallableStatementCreator implements CallableStatementCreator, SqlProvider { // Fields
private final String callString; // Constructors
public SimpleCallableStatementCreator(String callString) { } // Methods
public CallableStatement createCallableStatement(Connection con) throws SQLException { return null;}
public String getSql() { return null;}
} class SimplePreparedStatementCreator implements PreparedStatementCreator, SqlProvider { // Fields
private final String sql; // Constructors
public SimplePreparedStatementCreator(String sql) { } // Methods
public PreparedStatement createPreparedStatement(Connection con) throws SQLException { return null;}
public String getSql() { return null;}
} class CloseSuppressingInvocationHandler implements InvocationHandler { // Fields
private final Connection target; // Constructors
public CloseSuppressingInvocationHandler(JdbcTemplate target, Connection null) { } // Methods
public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { return null;}
}
}