首先在配置文件中进行相关配置
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
<property name="url" value="jdbc:mysql:///itcast"></property>
<property name="username" value="root"></property>
<property name="password" value="12345678"></property>
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<context:component-scan base-package="com.kun.Spring5" use-default-filters="true"></context:component-scan>
在DAO层操作数据库
@Repository
public class BookDaoImpl implements BookDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public void add(User user) {
String sql = "insert into myisam(name,stu_id) values(?,?)";
Object[] args = {user.getName(),user.getStu_id()};
int count = jdbcTemplate.update(sql, args);
if (count == 1) {
System.out.println("添加成功");
}else {
System.out.println("添加失败");
}
}
public int select(){
String sql = "select count(*) from myisam";
int count = jdbcTemplate.queryForObject(sql,int.class);
return count;
}
public User selectByID(int id){
String sql = "select id,name,stu_id from myisam wherer id=?";
User user = jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper<User>(User.class),id);
return user;
}
public List<User> selectAll(){
String sql = "select * from myisam";
List<User> userList = jdbcTemplate.query(sql,new BeanPropertyRowMapper<User>(User.calss));
return userList;
}
public void batchAdd(List<Object[]> batchArgs){
String sql = "insert into myisam(name,stu_id) values(?,?)";
int[] nums = jdbcTemplate.batchUpdate(sql,batchArgs);
}
public void batchDelete(List<Object[]> batchArgs){
String sql = "delete from myisam where id=?"
int[] nums = jdbcTemplate.batchUpdate(sql,batchArgs);
}
}