框架版增删改查

package com.zhongruan.dao.impl;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;
@Component
public class UserDao implements IUserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public List findALL() {
String sql=“select * from tb_user”;
BeanPropertyRowMapper rowMapper =new BeanPropertyRowMapper<> (User.class);
List users = jdbcTemplate.query (sql,rowMapper);
return users;
}

@Override
public void delete(int id) {
    String sql="delete from tb_user where id=?";
    jdbcTemplate.update (sql,id);
}

@Override
public void add(String username, String password) {

String sql=“insert into tb_user(username,password) values (?,?)”;
jdbcTemplate.update (sql,username,password);

}

@Override
public void update(int id, String username, String Password) {
    String sql="update tb_user set username=?,password=? where id=?";
    jdbcTemplate.update (sql,username,Password,id);
}

}package com.zhongruan.test;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class Test {
public static void main(String[] args){
/* User user = new User ();
user.setUsername (“hualili”);
user.setPassword (“123”);*/
ApplicationContext context=new ClassPathXmlApplicationContext (“spring.xml”);
/IUserService userService =(IUserService) context.getBean (“userService”);
userService.findAll ();/
/User user=(User) context.getBean (“user”);
user.setUsername();
user.serPassword();
System.out.print (user);/
IUserDao userDao=(IUserDao)context.getBean (“userDao”);
List users =userDao.findALL ();
userDao.delete (23);
userDao.add (“vbc”,“1111”);
userDao.update (25,“wcl”,“111111”);
System.out.println (users);
}
}