Spring
1 IOC 控制反转 控制权的转移 帮我们New对象
2 DI 依赖注入
3 AOP面向切面
使用spring
1 导jar包
2 配置xml
Spring注解
1 xml开启扫描
2在类上加注解
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="com.gm"></context:component-scan>
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/zjgm?characterEncoding=utf-8"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
import java.util.List;
@Component
public class UserDao implements IUserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public List<User> findAll() {
String sql = "select * from fuser";
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 fuser where id =?";
jdbcTemplate.update(sql,id);
}
@Override
public void update(int id, String username, String password) {
String sql = "update fuser set username=?,password=? where id=?";
jdbcTemplate.update(sql,username,password,id);
}
@Override
public void insert(String username, String password) {
String sql = "insert into fuser(username,password,type) value(?,?,1)";
jdbcTemplate.update(sql,username,password);
}
import java.util.List;
@Service
public class UserService implements IUserService {
@Autowired
private IUserDao userDao;
@Override
public List<User> findAll() {
List<User> users = userDao.findAll();
return users;
}
@Override
public void insert(String username, String password) {
userDao.insert(username,password);
}
@Override
public void update(int id, String username, String password) {
userDao.update(id,username,password);
}
@Override
public void delete(int id) {
userDao.delete(id);
}
}