搭建SSM框架
1.通过maven创建webapp项目
File->new->Project->Maven
选择本地JDK,记住勾选上那个选项,选择maven-archetype-webapp,点击next
任意名字填入GroupId和ArtifactId,点击next
在下拉栏中选择自己本地maven所在的位置,并点击右侧“+”,Name填入archetypeCatalog,Value填入internal,点击next
然后点击finish,完成项目的创建
选择本地maven,设置setting.xml和repository,在maven目录下创建repository目录jb
由于数据源在国外,因此第一次创建会下载很久,不过可以更换为阿里镜像,会快很多。
找到maven安装目录下conf里的**setting.xml文件
在mirrors镜像集标签下添加如下阿里云镜像
alimaven
central
aliyun maven
http://maven.aliyun.com/nexus/content/repositories/central/
2.创建数据库和表
3. dao层添加IUserDao接口类
package com.zhongruan.dao;
import com.zhongruan.bean.UserInfo;
import java.util.List;
public interface IUserDao {
public List findAll();
}
4.bean层添加UserInfo类
package com.zhongruan.bean;
public class UserInfo {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "UserInfo{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
5.在controller层添加UserController类
package com.zhongruan.controller;
import com.zhongruan.bean.UserInfo;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private IUserService userService;
@RequestMapping("/findAll.do")
public ModelAndView findAll(){
List all=userService.findAll();
ModelAndView mv=new ModelAndView();
mv.addObject(“userInfos”,all);
mv.setViewName(“allUser”);
return mv;
}
}
6.在service层添加IUserService接口类,在impl文件夹下新建UserService类
package com.zhongruan.service;
import com.zhongruan.bean.UserInfo;
import java.util.List;
public interface IUserService {
public List findAll();
}
package com.zhongruan.service.impl;
import com.zhongruan.bean.UserInfo;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserService implements IUserService {
@Autowired
private IUserDao userDao;
@Override
public List<UserInfo> findAll() {
return userDao.findAll();
}
}
7.在resources下添加配置文件applicationContext.xml,db.properties,log4j.properties,spring-mvc.xml
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<context:property-placeholder location=“classpath:db.properties”/>
<!-- 2.配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="maxPoolSize" value="30"/>
<property name="minPoolSize" value="2"/>
</bean>
<!-- 3.配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据库连接池 -->
<property name="dataSource" ref="dataSource"/>
<!-- 扫描bean包 使用别名 -->
<property name="typeAliasesPackage" value="com.zhongruan.bean"></property>
<!--配置加载映射文件 UserMapper.xml-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- 自动生成dao,mapper-->
<!-- 4.配置扫描Dao接口包,动态实现Dao接口,注入到spring容器中 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 给出需要扫描Dao接口包 -->
<property name="basePackage" value="com.zhongruan.dao"/>
<!-- 注入sqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!--自动扫描-->
<context:component-scan base-package="com.zhongruan"/>
<!-- 配置事务-->
<!-- 5.配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 6.开启事务注解-->
<tx:annotation-driven></tx:annotation-driven>
db.properties
在下方代码3306/后改为自己数据库的名称,密码改为自己所设置的密码
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/idea?useSLL=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123
log4j.properties
#Global logging configuration
log4j.rootLogger=DEBUG, stdout
#Console output…
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?><!-- 1.注解扫描位置-->
<context:component-scan base-package="com.zhongruan.controller" />
<!-- 2.配置映射处理和适配器-->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/>
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"/>
<!-- 3.视图的解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
8.在mapper下添加UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?> select * from userinfo9.在webapp下新建jsp文件夹,添加jsp文件
allUser.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8” isELIgnored=“false”%>
<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
基于SSM框架的管理系统:简单实现增、删、改、查。
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>新增用户</small>
</h1>
</div>
</div>
</div>
<form action="${pageContext.request.contextPath}/user/save.do"
method="post">
用 户 id:<input type="text" name="id"><br><br><br>
用户姓名:<input type="text" name="username"><br><br><br>
用户密码:<input type="text" name="password"><br><br><br>
<input type="submit" value="添加" >
</form>
10.修改index.jsp
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8” isELIgnored=“false”%>
到这里,ssm框架搭建基本完成
连接tomcat发布项目
1.点击run,打开Edit Configuration
找到tomcat server->local
在Server中选择本地tomcat和JRE
在Deployment中点击+号,加入war包,确定
配置好后,如图所示,点击运行按钮,部署成功,会弹出浏览器窗口
点击查询全部,会跳转到新页面显示所有用户信息
至此,一个简单的基于SSM框架的用户查询项目搭建完成!