第一部分：基本实现
@参考文章，在此基础上略作修改
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'', 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同目录下：
至此，大事告成！
此时博主已整合了大量项目业务，不便将源码包发给大家，思路有了，我也写的很清晰，读者自行整理吧