SSM框架的搭建并实现查询操作

搭建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 userinfo

9.在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">
    用&nbsp;&nbsp;户&nbsp;&nbsp;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框架的用户查询项目搭建完成！