package user.jdbctemplate;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
//操作用户的接口类
public class userTemplate {
private JdbcTemplate jdbcTemplate;
public void setDataSource(DataSource dataSource) {
jdbcTemplate = new JdbcTemplate(dataSource);
}
public int getallCount(String sql) {
System.out.println(sql);
int count = 1;
try {
count = jdbcTemplate.queryForInt(sql);
} catch (DataAccessException e) {
System.out.println("getallCount里面的报错是:" + e);
return count;
}
return count;
}
public String saveorupdate(String sql) {
System.out.println(sql);
try {
jdbcTemplate.update(sql);
} catch (DataAccessException e) {<