纯java+maven+sqlserver使用mybatis

第一部分：基本实现

@参考文章，在此基础上略作修改

1，新建maven项目JavaMybatis导入依赖

<dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
        </dependency>
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>sqljdbc4</artifactId>
            <version>4.0</version>
        </dependency>
    </dependencies>

2，com.mybatis包下新建Yanan.java

package com.mybatis;

public class Yanan {
    private int iid;
    private String ifullname;
    private String iloginname;
    private String ipassword;

    public Yanan() {
    }

    public Yanan(int id, String name) {
        this.iid = id;
        this.ifullname = name;
    }

    public String getIfullname() {
        return ifullname;
    }

    public int getIid() {
        return iid;
    }

    public void setIid(int iid) {
        this.iid = iid;
    }

    public void setIfullname(String ifullname) {
        this.ifullname = ifullname;
    }

    public String getIloginname() {
        return iloginname;
    }

    public void setIloginname(String iloginname) {
        this.iloginname = iloginname;
    }

    public String getIpassword() {
        return ipassword;
    }

    public void setIpassword(String ipassword) {
        this.ipassword = ipassword;
    }
}

3，根目录下新建Yanan.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="Yanan">    
    <select id="selectUser" parameterType="int" resultType="Yanan">    
        SELECT * FROM Yanan WHERE id = #{id}    
    </select>    
        
    <select id="selectUsers" resultType="Yanan">    
        SELECT * FROM Yanan    
    </select>    
        
</mapper>

4，根目录下新建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>    
    <typeAliases>    
        <typeAlias alias="Yanan" type="com.mybatis.Yanan"></typeAlias>    
    </typeAliases>    
        
    <environments default="development">    
        <environment id="development">    
            <transactionManager type="JDBC"></transactionManager>    
            <dataSource type="POOLED">    
                <property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />    
                <property name="url" value="jdbc:sqlserver://localhost:1433;databaseName=test" />    
                <property name="username" value="sa" />    
                <property name="password" value="yanan" />    
            </dataSource>    
        </environment>    
    </environments>    
        
    <mappers>    
        <mapper resource="Yanan.xml"/>    
    </mappers>    
    
</configuration>

5.com.controller包下新建测试文件

package com.controller;

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.mybatis.Yanan;

public class Test {

    public static void main(String[] args) throws IOException {
        // TODO Auto-generated method stub
        String resource = "configuration.xml";    
        Reader reader = Resources.getResourceAsReader(resource);    
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);    
        SqlSession session = ssf.openSession();    
        try{    
            Yanan user = session.selectOne("selectUser", 1);    
            System.out.println(user.getIfullname());    
            System.out.println(user);    
            System.out.println("--------------分隔线---------------");    
            
            List<Yanan> users = session.selectList("selectUsers");    
            for(int i=0; i<users.size(); i++) {    
                System.out.println(users.get(i).getIfullname());    
            }    
                
        } catch (Exception e) {    
            e.printStackTrace();    
        } finally {    
            session.close();    
        }    
    }

}

源码包下载：JavaMybatis.rar

建表语句：

/*
Navicat SQL Server Data Transfer

Source Server         : .
Source Server Version : 105000
Source Host           : .:1433
Source Database       : test
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2018-09-04 13:49:17
*/


-- ----------------------------
-- Table structure for yanan
-- ----------------------------
DROP TABLE [dbo].[yanan]
GO
CREATE TABLE [dbo].[yanan] (
[id] int NOT NULL IDENTITY(1,1) ,
[ifullname] varchar(255) NULL ,
[iloginname] varchar(255) NULL ,
[ipassword] varchar(255) NULL 
)


GO

-- ----------------------------
-- Records of yanan
-- ----------------------------
SET IDENTITY_INSERT [dbo].[yanan] ON
GO
INSERT INTO [dbo].[yanan] ([id], [ifullname], [iloginname], [ipassword]) VALUES (N'1', N'sd', N'fd', N'sd')
GO
GO
SET IDENTITY_INSERT [dbo].[yanan] OFF
GO

-- ----------------------------
-- Indexes structure for table yanan
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table yanan
-- ----------------------------
ALTER TABLE [dbo].[yanan] ADD PRIMARY KEY ([id])
GO

项目结构展示：

第二部分：改造优化

上述方式能实现，但需要建实体类，影响开发和维护效率，下面改造成接口形式且无实体类方式：

为了便于区分（也便于我接下来的项目），把名称结构等做了修改

1,同上（项目名DeleteOrder）

2，cn.yanan.deleteorder.mapper下新建UserMapper接口

package cn.yanan.deleteorder.mapper;

import java.util.List;
import java.util.Map;

public interface UserMapper {
    Map<String,Object> selectUser(int id);
    List<Map<String,Object>> selectUsers();
}

3，根目录下新建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="cn.yanan.deleteorder.mapper.UserMapper">    
    <select id="selectUser" parameterType="int" resultType="java.util.Map">    
        SELECT * FROM Yanan WHERE id = #{id}    
    </select>    
        
    <select id="selectUsers" resultType="java.util.Map">    
        SELECT * FROM Yanan    
    </select>    
        
</mapper>

4，根目录下新建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.microsoft.sqlserver.jdbc.SQLServerDriver" />    
                <property name="url" value="jdbc:sqlserver://localhost:1433;databaseName=test" />    
                <property name="username" value="sa" />    
                <property name="password" value="yanan" />    
            </dataSource>    
        </environment>    
    </environments>    
        
    <mappers>    
        <mapper resource="UserMapper.xml"/>    
    </mappers>    
    
</configuration>

5，cn.yanan.deleteorder.controller包下新建测试文件

package cn.yanan.deleteorder.controller;

import java.io.IOException;
import java.io.Reader;
import java.util.List;
import java.util.Map;

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 cn.yanan.deleteorder.mapper.UserMapper;

public class MainController {
    public static void main(String[] args) throws IOException {
        String resource = "configuration.xml";    
        Reader reader = Resources.getResourceAsReader(resource);    
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);    
        SqlSession session = ssf.openSession();    
        try{    
            UserMapper mapper = session.getMapper(UserMapper.class);
            Map<String,Object> user = mapper.selectUser(1);
            List<Map<String,Object>> users = mapper.selectUsers();
            System.out.println(user.get("ifullname"));    
            System.out.println(user);    
            System.out.println("--------------分隔线---------------");      
            for(int i=0; i<users.size(); i++) {    
                System.out.println(users.get(i).get("ifullname"));    
            }    
        } catch (Exception e) {    
            e.printStackTrace();    
        } finally {    
            session.close();    
        }    
    }
}

源码包下载：DeleteOrder.rar

建表语句：同上

 项目结构展示：

第三部分：继续优化

经过第二部分的优化已经能满足大部分网友的需求了。但对于一些要将该项目导出可运行jar包的网友来说并不能很好地运行，摘自一位博客的说法：

“因为”…/ResourceJar.jar!/resource/….”并不是文件资源定位符的格式 (jar中资源有其专门的URL形式： jar:!/{entry} )”，详细论述@参考博客

所以我们使用如下的方式：

InputStream is=MainController.class.getResourceAsStream("/configuration.xml");   
BufferedReader br=new BufferedReader(new InputStreamReader(is));

经过上述步骤你会发现在eclipse下能够正常运行，但jar包还不能加载到配置文件，我们继续进行改造

src同目录下建资源包，并把配置文件拖拽进去，结构如下（上述.getResourceAsStream("/configuration.xml")配置不变）

如此，eclipse中与jar包中都能加载到配置文件了。但此时你会发现新的异常，加载不到configuration中的mapper.xml文件

我们继续改造，打开configuration.xml进行配置

 并将此二者拖拽到configuration.xml同目录下：

至此，大事告成！

此时博主已整合了大量项目业务，不便将源码包发给大家，思路有了，我也写的很清晰，读者自行整理吧