一、要求:通过Mybatis和Spring的整合,对数据库mybatis中user表的用户实现模糊查询。并将结果输出到控制台。
二、实验步骤
1.数据库的创建。
2.项目结构。
3.相关文件。
(1).UserController.java
package Control;
import Dao.UserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import Po.User;
import java.util.List;
@Controller("userController")
public class UserController {
@Autowired
@Qualifier("userDao")
private UserDao userDao;
public void test(String name){
//查询功能
String uname = "%"+ name +"%";
List<User> users = userDao.selectUserByName(uname);
for(User user : users){
System.out.println(user);
}
}
}
(2).UserDao.java
package Dao;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import Po.User;
import java.util.List;
@Repository("userDao")
@Mapper
public interface UserDao {
public User selectUserById(Integer uid);
public List<User> selectUserByName(String uname);
public List<User> selectAllUser();
public int addUser(User user);
public int updateUser(User user);
public int deleteUser(Integer uid);
}
(3).User.java
package Po;
public class User {
private int uid;
private String uname;
private String usex;
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUsex() {
return usex;
}
public void setUsex(String usex) {
this.usex = usex;
}
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", uname='" + uname + '\'' +
", usex='" + usex + '\'' +
'}';
}
}
(4).ControllerTest.java
package Test;
import Control.UserController;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class ControllerTest {
@Test
public void test(){
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
UserController userController = (UserController) applicationContext.getBean("userController");
userController.test("王");
}
}
模糊输出姓王的用户信息 。
(5).log4j.properties
# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.mybatis=DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
(6).applicationContext.xml(spring的配置文件)
<?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:lang="http://www.springframework.org/schema/lang"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
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/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
http://www.springframework.org/schema/lang
http://www.springframework.org/schema/lang/spring-lang.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd">
<!--指定需要扫描的包(包括子包〉,使注解生效-->
<context:component-scan base-package="Dao"/>
<context:component-scan base-package="Control"/>
<!--1.配置数据源-->
<bean id="dataSource" class=
"org.springframework.jdbc.datasource.DriverManagerDataSource">
<!--数据库驱动-->
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<!--连接数据库的url-->
<property name="url" value=
"jdbc:mysql://localhost:3306/mybatis?useSSL=false&userServerPrepStmts=true&characterEncoding=utf8"/>
<!--连接数据库的用户名-->
<property name="username" value="root"/>
<!--连接数据库的密码-->
<property name="password" value="123456"/>
</bean>
<!--2配置JDBC模板-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
<!--默认必须使用数据源-->
<property name="dataSource" ref="dataSource"/>
</bean>
<!--配置MyBatis工厂,同时指定数据源,并与MyBatis完美整合-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!--configLocation的属性值为MyBatis的核心配置文件...-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!--Mapper代理开发,使用Spring自动扫描MyBatis的接口并装配
(Spring将指定包中所有被@Mapper注解标注的接口自动装配为MyBatis的映射接口)-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--mybatis-spring组件的扫描器,com.dao只需要接口(接口方法与SQL映射文件中的相同)-->
<property name="basePackage" value="dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 事务管理器,依赖于数据源-->
<bean id="transactionManager" class=
"org.springframework.jdbc.datasource.DataSourceTransactionManager" >
<property name="dataSource" ref="dataSource" />
</bean>
<!--注册事务管理器驱动-->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
(7).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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<!--配置数据源:创建Connection对象-->
<dataSource type="POOLED">
<!--driver:驱动内容-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<!--连接数据库的url-->
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8"/>
<!--用户名-->
<property name="username" value="root"/>
<!--密码-->
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--指定其他mapper文件的位置目的是找到其他mapper文件的sql语句-->
<mappers>
<!--使用mapper的resource属性指定mapper文件的路径这个路径是从target/classes路径开启的使用注意:resource="mapper"文件的路径,使用 / 分割路径一个resource指定一个mapper文件-->
<mapper resource="UserMapper.xml"/>
</mappers>
</configuration>
其中我的数据库为mybatis,注意修改成自己的数据库、用户名和密码。
(8).UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="Dao.UserDao">
<select id="findAll" resultType="Po.User">
SELECT * FROM account;
</select>
<!-- 根据uid查询用户信息-->
<select id="selectUserById" resultType="Po.User">
select * from user where uid = #{uid}
</select>
<!-- 根据uname模糊查询用户信息-->
<select id="selectUserByName" parameterType="String" resultType="Po.User">
select * from user where uname like #{uname}
</select>
<!-- 查询所有用户信息-->
<select id="selectAllUser" resultType="Po.User">
select * from user
</select>
<!--添加一个用户-->
<insert id="addUser" parameterType="Po.User">
insert into user (uname,usex) values(#{uname},#{usex})
</insert>
<!--修改一个用户-->
<update id="updateUser" parameterType="Po.User">
usex= #{usex} where uid = #{uid}
</update>
<!-- 删除一个用户-->
<delete id="deleteUser" parameterType="Po.User">
delete from user where uid = #{uid}
</delete>
</mapper>
这里定义了很多语句,其中我只用到了模糊查询。
结果截图:
问题遗留:
其中我曾将UserMapper.xml文件放在Mapper包中,但出现了无法找到这个文件的报错信息,所以才将其放在资源根目录下的。