import com.gctx.framework.dao.IGenericJdbcDAO;
import com.gctx.framework.logs.Logit;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;
public Integer insert(final String sql, final Object[] objs)
{
Logit.debugLog(sql);
KeyHolder keyHolder = new GeneratedKeyHolder();
getJdbcTemplate().update(new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection conn) {
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql, 1);
if ((objs != null) && (objs.length > 0))
for (int i = 0; i < objs.length; i++)
ps.setObject(i + 1, objs[i]);
}
catch (SQLException e)
{
Logit.errorLog(e.getMessage(), e);
}
return ps;
}
}
, keyHolder);
if ((keyHolder == null) || (keyHolder.getKey() == null)) {
return Integer.valueOf(0);
}
return Integer.valueOf(keyHolder.getKey().intValue());
}
import com.gctx.framework.logs.Logit;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;
public Integer insert(final String sql, final Object[] objs)
{
Logit.debugLog(sql);
KeyHolder keyHolder = new GeneratedKeyHolder();
getJdbcTemplate().update(new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection conn) {
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql, 1);
if ((objs != null) && (objs.length > 0))
for (int i = 0; i < objs.length; i++)
ps.setObject(i + 1, objs[i]);
}
catch (SQLException e)
{
Logit.errorLog(e.getMessage(), e);
}
return ps;
}
}
, keyHolder);
if ((keyHolder == null) || (keyHolder.getKey() == null)) {
return Integer.valueOf(0);
}
return Integer.valueOf(keyHolder.getKey().intValue());
}