MVC模板
mybatis-config
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| <?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>
<settting>
<setting value="LOG4J" name="logImpl"/>
</settting>
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"/>
<dataSource type="UNPOOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/demo"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper class="my.mapper.UserMapper"/>
</mappers>
</configuration>
|
InitSession类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| package my.tool;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class InitSession {
private static SqlSessionFactory factory;
static {
InputStream in;
try {
in = Resources.getResourceAsStream("mybatis-config.xml");
factory = new SqlSessionFactoryBuilder().build(in);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSession() {
return factory.openSession();
}
}
|
生成mapper对象的方法
业务类功能需要对数据库进行操作，需要用到mapper接口链接数据库
1
2
|
SqlSession session = InitSession.getSession();
|
1
2
|
UserMapper mapper = session.getMapper(UserMapper.class);
|
注：这两条可以使用全局变量
JSP实现连接数据库（利用JSTL）
1
2
3
4
5
6
7
8
9
10
| <sql:setDataSource driver="com.mysql.jdbc.Driver "
url="jdbc:mysql://43.143.152.156:3060/usermanager"
user="root"
password="Zhuwenxue2002"
var="snapshot"
/>
<sql:query var="result"
sql="SELECT password from user WHERE ${username};"
dataSource="${snapshot}"
/>
|