• mybatis 和 mybatis-spring


    一、

     1. 实体bean     

    package com.mybatisBean;
    
    public class User {
        private Integer id;
        private String name;
        private String age;
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getName() {
            return name;
        }
        public void setName(String name) {
            this.name = name;
        }
        public String getAge() {
            return age;
        }
        public void setAge(String age) {
            this.age = age;
        }
        
    }

      2.dao类

      

    package com.mybatisDao;
    
    import java.util.List;
    
    import com.mybatisBean.User;
    
    
    public interface UserDao {
        public List<User> selectAll();
    }

      3.dao 映射文件

    <?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="com.mybatisDao.UserDao">
        <select id="selectAll" resultType="com.mybatisBean.User">
            select * from user
        </select>
    </mapper>

     4.配置文件

    <?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"></transactionManager>
                <dataSource type="POOLED">
                    <property name="driver" value="com.mysql.jdbc.Driver"/>
                    <property name="url" value="jdbc:mysql://localhost:3306/test_mysql?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"/>
                    <property name="username" value="root"/>
                    <property name="password" value="123456"/>
                </dataSource>
            </environment>
        </environments> -->
        <mappers>
            <mapper resource="mybatisMapper/UserMapper.xml"/>
        </mappers>
    </configuration>

      5. 测试

      

    package com.mybatisTest;
    
    import java.io.Reader;
    import java.util.List;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    
    import com.mybatisBean.User;
    import com.mybatisDao.UserDao;
    
    /*
     * mybatis 第一种方式
     * 1. 创建实体,2. 创建dao ,声明接口   3. 创建dao 对应的映射文件 
     * 4. 创建mybatis 配置文件,声明数据库连接,配置映射文件 5.通过mybatis配置文件和sessionfactoryBuilder引用
     * 第一种方式在 mybatis 配置文件中配置数据库链接
     */
    public class TestUser {
        public static void main(String[] args) throws Exception{
            String resource="mybatis-configuration.xml";
            Reader reader=Resources.getResourceAsReader(resource);
            SqlSessionFactoryBuilder bulider=new SqlSessionFactoryBuilder();
            SqlSessionFactory factory=bulider.build(reader);
            SqlSession session=factory.openSession();
            UserDao userdao=session.getMapper(UserDao.class);
            List<User> list=userdao.selectAll();
            for(User user:list){
                System.out.println(user.getName()+":"+user.getAge());
            }
            session.commit();
            session.close();
        }
    }

     jar 包 ,主要有 mybatis-3.1.1.jar  和 mysql-connector-java-5.1.jar

    二、

        多出的部分。

      1. service 接口和实现

    package com.mybatisService.User;
    
    import java.util.List;
    
    import com.mybatisBean.User;
    
    public interface UserService {
    	public List<User> selectAll();
    }
    
    
    package com.mybatisService.User;
    
    import java.util.List;
    
    import com.mybatisBean.User;
    import com.mybatisDao.UserDao;
    
    public class UserImpl implements UserService{
    	private UserDao userdao;
    	
    	public UserDao getUserdao() {
    		return userdao;
    	}
    
    	public void setUserdao(UserDao userdao) {
    		this.userdao = userdao;
    	}
    
    	@Override
    	public List<User> selectAll() {
    		return this.userdao.selectAll();
    	}
    	
    }
    

      2. 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"
        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/test_mysql?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:mybatis-configuration.xml"></property>
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="com.mybatisDao.UserDao"></property>
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
    </bean>
    <bean id="userservice" class="com.mybatisService.User.UserImpl">
        <property name="userdao" ref="userDao"></property>
    </bean>
    </beans>

     mybatis 配置文件中的 数据库链接不需要了 。

     基于以上  添加 mybatis 

    添加jar  包  mybats-3.1.jar  mysql-connector-java-5.1 mybatis-spring.jar ,commons-dbcp,commons-pool,spring-jdbc 等 

    UserDao.java

    package com.mybatisdao;
    
    import java.util.List;
    
    import com.bean.User;
    
    
    
    public interface UserDao {
        public List<User> selectAll();
    }

    UserDaoMapper.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="com.mybatisdao.UserDao">
        <select id="selectAll" resultType="com.bean.User">
            select * from user
        </select>
    </mapper>

    mybatis-configuration.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"></transactionManager>
                <dataSource type="POOLED">
                    <property name="driver" value="com.mysql.jdbc.Driver"/>
                    <property name="url" value="jdbc:mysql://localhost:3306/test_mysql?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"/>
                    <property name="username" value="root"/>
                    <property name="password" value="***"/>
                </dataSource>
            </environment>
        </environments> -->  <!--结合spring 时要在Spring  配置文件中配置 数据库链接-->
        <mappers>
            <mapper resource="com/mybatisMapper/UserDaoMapper.xml"/>
        </mappers>
    </configuration>

    更改HappyNewYearIml.java

    package com.service;
    
    
    
    import java.util.List;
    
    import javax.jws.WebService;
    
    
    import com.bean.Person;
    import com.bean.User;
    import com.mybatisdao.UserDao;
    
    
    @WebService(endpointInterface = "com.service.HappyNewYear")
    public class HappyNewYearImpl implements HappyNewYear 
    {
        private UserDao userdao;  //主要改动的地方
        
        public UserDao getUserdao() {
            return userdao;
        }
    
        public void setUserdao(UserDao userdao) {
            this.userdao = userdao;
        }
    
        public String sayHello(Person person) 
        {
            List<User> list=userdao.selectAll();
            String  ss="";
            for(User u:list){
                if(u.getId()+""==person.getFirstName()){
                    ss=u.getName()+"年龄"+u.getAge();
                }
            }
            
            return ss==""?"没有":ss;
        }
    
    
    
    }

    applicationContext.xml更改

    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:jaxws="http://cxf.apache.org/jaxws"
        xmlns:jaxrs="http://cxf.apache.org/jaxrs"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://cxf.apache.org/jaxws 
        http://cxf.apache.org/schemas/jaxws.xsd
        http://cxf.apache.org/jaxrs
        http://cxf.apache.org/schemas/jaxrs.xsd">
           
        <import resource="classpath:META-INF/cxf/cxf.xml" />
        <import resource="classpath:META-INF/cxf/cxf-extension-soap.xml" />
        <import resource="classpath:META-INF/cxf/cxf-servlet.xml" />
        <bean id="person" class="com.bean.Person"></bean>
        <bean id="restSample" class="com.rest.HelloLove"></bean>
        <context:component-scan base-package="com.*">
            <context:exclude-filter type="annotation" 
    
    expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
     <!--主要更改部分begin-->

    <!-- 下面3个bean 的 class 需要导入 mybatis-spring.jar ,commons-dbcp,commons-pool,spring-jdbc --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/test_mysql?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"/> <property name="username" value="root"/> <property name="password" value="123456"/> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="configLocation" value="classpath:com/resoureces/mybatis-configuration.xml"></property> <property name="dataSource" ref="dataSource"></property> </bean> <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="com.mybatisdao.UserDao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> <bean id="happyNewYearImpl" class="com.service.HappyNewYearImpl"> <property name="userdao" ref="userDao"></property> </bean> <!-- 当jaxws:endpoint的 implementor需要引入Spring bean 时 要加 # ,这是第一种方式 --> <jaxws:endpoint id="greetServicce" implementor="#happyNewYearImpl" address="/greetServicce" /> <!-- 第二种方式 --> <!-- <jaxws:endpoint id="greetServicce" implementorClass="com.service.HappyNewYearImpl" address="/greetServicce"> <jaxws:implementor> <bean ref="userDao"></bean> 找不到ref 属性 ,应该是版本问题 </jaxws:implementor> </jaxws:endpoint> --> <!--主要更改部分end--> <jaxrs:server id="restServiceContainer" address="/rest"> <jaxrs:serviceBeans> <ref bean="restSample"/> </jaxrs:serviceBeans> <jaxrs:extensionMappings> <entry key="json" value="application/json" /> <entry key="xml" value="application/xml" /> </jaxrs:extensionMappings> <jaxrs:languageMappings> <entry key="en" value="en-gb"/> </jaxrs:languageMappings> </jaxrs:server> </beans>

    测试 

    package com.test;
    
    import java.io.IOException;
    import java.io.Reader;
    import java.util.List;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    
    
    import com.bean.User;
    import com.mybatisdao.UserDao;
    
    public class testmybatis {
        public static void main(String[] args) throws IOException{
            String resource="com/resoureces/mybatis-configuration.xml";
            Reader reader=Resources.getResourceAsReader(resource);
            SqlSessionFactoryBuilder bulider=new SqlSessionFactoryBuilder();
            SqlSessionFactory factory=bulider.build(reader);
            SqlSession session=factory.openSession();
            UserDao userdao=session.getMapper(UserDao.class);
            List<User> list=userdao.selectAll();
            for(User u:list){
                System.out.println(u.getName()+"年龄"+u.getAge());
            }
            session.commit();
            session.close();
        }
    }

     请结合 http://www.cnblogs.com/zhangchenglzhao/p/3505176.html 

  • 相关阅读:
    css中的display以及position属性
    有人退税近4000元!个税年度汇算开始了,看看你能退多少?
    多维竞争
    阿里智能化接口测试平台--暴雪
    盗版网课有多猖狂?原价上万,只卖5元
    测试找BUG总结
    女程序员做了个梦。。。
    混沌的市场里,怎么一眼识别出「好房子」
    知乎扎心高赞:30岁还没有走到管理岗的人,后来怎么样了?
    自动化是在敏捷中提供连续测试的唯一方法
  • 原文地址:https://www.cnblogs.com/zhangchenglzhao/p/3456224.html
Copyright © 2020-2023  润新知