项目目录
由于没有前台数据交互,在controller中代替
entity
package com.liu.demo.entity;
public class User {
int id;
String username;
String account;
String password;
public User() {
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", account='" + account + '\'' +
", password='" + password + '\'' +
'}';
}
public User(int id, String username, String account, String password) {
this.id = id;
this.username = username;
this.account = account;
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
dao
package com.liu.demo.dao;
import com.liu.demo.entity.User;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface UserMapper {
//1 查询全部用户
List<User> findAll();
//2 添加用户
void addUser(User user);
// //3 根据id修改用户
void updateUser(User user);
// //4 根据id删除用户
void deleteUser(User user);
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.liu.demo.dao.UserMapper">
<select id="findAll" resultType="user">
select * from users
</select>
<insert id="addUser">
insert into users values(#{id},#{username},#{account},#{password})
</insert>
<update id="updateUser" >
update users set username=#{username},account=#{account},password=#{password} where id=#{id}
</update>
<delete id="deleteUser" parameterType="int">
delete from users where id=${id}
</delete>
</mapper>
service
@Service
public class UserService {
@Autowired
UserMapper userMapper;
public List<User> findAll(){
return userMapper.findAll();
}
public void addUser(User user){
userMapper.addUser(user);
}
public void updateUser(User user){
userMapper.updateUser(user);
}
public void deleteUser(User user){
userMapper.deleteUser(user);
}
}
controller
@Controller
public class UserController {
public static void main(String[] args) {
//都spring配置文件
ApplicationContext context = new ClassPathXmlApplicationContext("springContext.xml");
UserService userService = (UserService) context.getBean("userService");
//查询
List<User> users = userService.findAll();
System.out.println(users);
//添加
// User user = new User(3,"黄忠","1003","333333");
// userService.addUser(user);
//更新
// User user1 = new User(3,"张飞","1003","333333");
// userService.updateUser(user1);
//删除
User user1 = new User(3,"张飞","1003","333333");
userService.deleteUser(user1);
}
}
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd" >
<configuration>
<!-- 别名-->
<typeAliases>
<package name="com.liu.demo"/>
</typeAliases>
<!-- mapper映射文件-->
<mappers>
<package name="com.liu.demo.dao"/>
</mappers>
</configuration>
springContext.xml
<?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 https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
<!--包扫描-->
<context:component-scan base-package="com.liu.demo"/>
<!-- 引入db配置文件-->
<context:property-placeholder file-encoding="UTF-8" location="db.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${driver}"></property>
<property name="url" value="${url}"></property>
<property name="username" value="${user}"></property>
<property name="password" value="${pwd}"></property>
</bean>
<!-- 配置SqlSessionFactory对象-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据库连接池-->
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="mybatis-config.xml"/>
</bean>
<!-- 配置studentMapper对象-->
<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.liu.demo.dao.UserMapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
</beans>