简单的 spring + springMVC + mybaties 框架搭建

不念不忘少年蓝@ 2022-07-14 15:54 194阅读 0赞

![Center][]

1.创建BaseDAO

public class BaseDAO \{  
    static\{  
        try \{  
            //获取基本配置文件的字符流  
            Reader reader = Resources.getResourceAsReader("SqlConfig.xml");  
            //构建SqlSessionFactory  
            factory = new SqlSessionFactoryBuilder().build(reader);  
  
        \} catch (IOException e) \{  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        \}  
          
    \}  
    public static SqlSessionFactory factory;  
    public SqlSession getSession()\{  
        return factory.openSession();  
    \}  
\}  
  
2. 实心类

package com.yuan.dao.impl;  
  
import org.apache.ibatis.session.SqlSession;  
import org.springframework.stereotype.Repository;  
  
import com.yuan.bean.Student;  
import com.yuan.dao.BaseDAO;  
import com.yuan.dao.IStudentDAO;  
  
@Repository  
public class StudentDAOImpl extends BaseDAO implements IStudentDAO\{  
  
    @Override  
    public void study() \{  
        System.out.println("不断学习...");  
    \}  
  
    public Student getStudent()\{  
        SqlSession session = this.getSession();  
        Student newStudent = new Student();  
        newStudent.setId(1);  
        Student student = session.selectOne("selectStudentById", newStudent);  
        session.commit();  
        session.close();  
          
        return student;  
    \}  
      
\}

bean xml 配置

mybaties 增删改查语法 :

\------------------------------------------------------------------------------------------------- 此代码只是语法，和本架构无关

<?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="UserBeanNS">  
      
    <resultMap type="UserBean" id="UserBeanRS">  
        <id property="id" column="u\_id"/>  
        <result property="name" column="u\_name"/>  
        <result property="age" column="u\_age"/>  
        <result property="born" column="u\_born"/>  
    </resultMap>  
    <insert id="addUser" >  
        insert into t\_user(u\_id,u\_name,u\_age,u\_born) values(seq\_id.nextval,\#\{name\},\#\{age\},\#\{born,jdbcType=DATE\})  
    </insert>  
    <update id="updateUser">  
        update t\_use  
        <set>  
            <if test="username!=null">u\_username=\#\{username\},</if>  
            <if test="pwd!=null">u\_pwd=\#\{pwd\}</if>  
        </set>  
        where u\_id=\#\{id\}  
    </update>  
    <select id="selectAllUser" resultType="UserBean">  
        select u\_id id,u\_username username,u\_pwd pwd,u\_born born from t\_user  
    </select>  
    <select id="selectUserById" resultMap="UserBeanRS">  
        select \* from t\_user where u\_id=\#\{id\}  
    </select>  
    <select id="selectUserByCondition" resultMap="UserBeanRS" >  
        select \* from t\_user  
        <where>  
            <if test="username != null">  
                u\_name=\#\{username\}  
            </if>  
            <if test="pwd != null">  
                and u\_pwd=\#\{pwd\}  
            </if>  
        </where>  
    </select>  
</mapper>

\------------------------------------------------------------------------------------------------- 此代码只是语法，和本架构无关

3. applicationContext.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:aop="http://www.springframework.org/schema/aop"    
       xmlns:tx="http://www.springframework.org/schema/tx"    
       xmlns:context="http://www.springframework.org/schema/context"    
       xmlns:mvc="http://www.springframework.org/schema/mvc"    
       
       xsi:schemaLocation="     
            http://www.springframework.org/schema/beans  
            http://www.springframework.org/schema/beans/spring-beans-2.5.xsd     
            http://www.springframework.org/schema/aop  
            http://www.springframework.org/schema/aop/spring-aop-2.5.xsd     
            http://www.springframework.org/schema/tx  
            http://www.springframework.org/schema/tx/spring-tx-2.5.xsd  
            http://www.springframework.org/schema/context  
            http://www.springframework.org/schema/context/spring-context-2.5.xsd  
            http://www.springframework.org/schema/mvc  
            http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd ">  
     
    <aop:aspectj-autoproxy/>    
           
      
    <context:component-scan base-package="com.yuan"/>     
     
</beans>

4. srping-servlet.xml

5.SqlConfig.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>  
        <typeAlias type="com.yuan.bean.Student" alias="StudentBean" />  
    </typeAliases>  
    <environments default="development">  
        <environment id="development">  
            <transactionManager type="JDBC" />  
            <dataSource type="POOLED">  
                <property name="driver" value="com.mysql.jdbc.Driver" />  
                <property name="url" value="jdbc:mysql://localhost:3306/test" />  
                <property name="username" value="root" />  
                <property name="password" value="123" />  
            </dataSource>  
        </environment>  
    </environments>  
      
    <mappers>  
        <mapper resource="com/yuan/bean/StudentBean.xml" />  
    </mappers>  
</configuration>  
  
  
6.jdbc.properties 是多余的,因为已经配置了地址

[Center]: /images/20220709/e96c669b5c9346c594f19d1daadc57b4.png