第一天:
SSM项目整合开发从入门到精通
SSHSpring + Struts + Hibernate
SSM (用的非常多) 轻量化,简单Spring + Spring MVC + Mybatis
(struts) (hibernate)
A(IoC容器) + B(MVC框架) + C(ORM框架) object-reation mapping=对象和关系(表)的映射
也可以有其他搭配方式
spring + struts + mybatis
spring + springmvc + hibernate
实际并不常见,只要掌握了SSH和SSM的整合,其他两种整合也容易处理,网上也有相关文章介绍。
直接搜索以上组合的关键字既可。
第二天:
mybatis,前身ibatis,是一个orm框架 orm=object(对象) relation(关系,表) mapping(映射)
1.新建Java项目,引入jar包,mybatis的jar包和mysql的jar包
src
mybatis的jar包下载
https://github.com/mybatis/mybatis-3/releases
2.建立数据库users,建立表user(id,userName,userPwd)
3.引入mybatis的主配置文件mybatis-config.xml(名字在代码中要用到)
百度解决
http://mybatis.github.io/mybatis-3/getting-started.html
<?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="mysql">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost/users" />
<property name="username" value="root" />
<property name="password" value="" />
</dataSource>
</environment>
</environments>
<!-- mapping 文件路径配置 -->
<mappers>
<!-- <mapper class="javastudy.UserMapper" /> -->
<!-- <mapper resource="userMapper.xml"/> -->
</mappers>
</configuration>
4.将数据库连接信息写入单独的properties文件
(1)主配置文件中将连接参数修改为变量
<property name="driver" value="${db.driver}" />
<property name="url" value="${db.url}" />
<property name="username" value="${db.user}" />
<property name="password" value="${db.password}" />
(2)引入db.properties文件
<properties resource="db.properties"></properties>
(3)在src目录下添加db.properties文件
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost/users
db.username=root
db.password=
5.编写实体类User
User(id,userName,userPwd)
6.在实体类所在包下,编写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="javastudy.userMapper">
<select id="selectUser" parameterType="int" resultType="javastudy.User">
select * from User where id = #{id}
</select>
</mapper>
7.编写测试程序
(1)编写MyBatis的工具类
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 MybatisUtils {
public static SqlSession openSession() throws IOException
{
String resource = "mybatis-config.xml";
InputStream in = Resources.getResourceAsStream(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in,"mysql");
return sessionFactory.openSession();
}
}