新建项目“spring1010”,结构如下
导jar包
复制jar中的包到“spring1010”下的“lib”包中,右键“lib”–“Add as Library”–“ok”
“lib”包内容如下
“bean”中“User”代码如下,并使用“Getter and Setter”和“toString”方法
private int id;
private String username;
private String password;
“UserDao”代码如下
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<User> findAll() {
String sql="select * from tb_user";
BeanPropertyRowMapper<User> rowMapper=new BeanPropertyRowMapper<>(User.class);
List<User> 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);
}
}
“IUserDao”代码如下
package com.zhongruan.dao;
import com.zhongruan.bean.User;
import java.util.List;
public interface IUserDao {
List<User> findAll();
void delete(int id);
}
“UserService”代码如下
package com.zhongruan.service.impl;
import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
/*<bean id="userService" class="com.zhongruan.service.impl.UserService"></bean>*/
public class UserService implements IUserService {
@Override
public List<User> findAll() {
System.out.println("hhhhhhhhhhhhhhh");
return null;
}
}
“IUserService”代码如下
package com.zhongruan.service;
import com.zhongruan.bean.User;
import java.util.List;
public interface IUserService {
List<User> findAll();
}
“Test”代码如下
package com.zhongruan.test;
import com.zhongruan.bean.User;
import com.zhongruan.dao.impl.UserDao;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.List;
import java.util.Scanner;
public class Test {
public static void main(String[] args) {
/*User user=new User();
user.setUsername("hualili");
user.setPassword("123");*/
/*IUserService userService=new UserService();
userService.findAll();*/
ApplicationContext context=new ClassPathXmlApplicationContext("spring.xml");
/*IUserService userService= (IUserService) context.getBean("userService");
userService.findAll();
User user= (User) context.getBean("user");
*//*user.setUsername("hualili");
user.setPassword("123");*//*
System.out.println(user);*/
UserDao userDao= (UserDao) context.getBean("userDao");
List<User> users=userDao.findAll();
userDao.delete(7);
System.out.println(users);
}
}