ssm框架整合

创建以使用maven为管理的web项目完成简单的增删改查功能(数据库使用mysql)

1.创建web项目

2.pom.xml配置文件的改变(增加各个框架的jar包)

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>bird</groupId>
<artifactId>sdibt_ssm</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>sdibt_ssm Maven Webapp</name>
<url>http://maven.apache.org</url>
<!-- spring版本,mybatis版本,其他jar包:日志 数据库驱动包 -->
<properties>
<!-- spring版本号 -->
<spring.version>4.1.5.RELEASE</spring.version>
<!-- mybatis版本号 -->
<mybatis.version>3.2.6</mybatis.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.7.7</slf4j.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<!-- springjar包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>


<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis jar 包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- 其他jar -->
<!-- 导入Mysql数据库链接jar包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>


<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>


<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- 上传组件包 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<!-- 协助编码 -->
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.9</version>
</dependency>
<!-- springmvc @responsebody将对象自动转为json字符串 -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.6.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.6.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.6.3</version>
</dependency>
</dependencies>
<build>
<finalName>sdibt_ssm</finalName>
</build>

</project>

3.修改web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
          http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
<display-name>Archetype Created Web Application</display-name>
<servlet>
     <init-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath:spring-mvc.xml</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
     <servlet-name>dispatcher</servlet-name>
     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  </servlet>
  <servlet-mapping>
     <servlet-name>dispatcher</servlet-name>
     <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!-- 配置监听器 监听spring上下文中对象的创建 -->

<!--web.xml加入spring监听器启动时候需要加载的javabean,比如daoservice等等-->

  <context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>  
            classpath*:spring-mybatis.xml
        </param-value>  
    </context-param> 
  <listener>
     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

</web-app>

4.加入spring-mvc.xml(项目配置文件都在resources包)


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<context:component-scan base-package="sdibt.bird.controller" />
<!-- 自动注入两个bean,requestmappinghandler,requestmappinghandleradapter -->
<mvc:annotation-driven>
<!-- 加入消息转换器 -->
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/plain;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<bean
class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<!--返回字符串格式json -->
<value>application/json;charset=UTF-8</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>

<!-- 不拦截静态资源 -->
<mvc:default-servlet-handler />


<!-- 专门处理文件上传的处理器 -->
<bean id="multipartResolver"
class="org.springframework.web.multipart.support.StandardServletMultipartResolver">
</bean>


<!-- 配置结果跳转到什么页面 -->
<!-- 视图名称的解析 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"
p:viewClass="org.springframework.web.servlet.view.JstlView"
    p:prefix="/"
p:suffix=".jsp" />

</beans>

5.spring与mybatis配置文件整合(spring-mybatis.xml)

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans  
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd  
                        http://www.springframework.org/schema/context 
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd  
                        http://www.springframework.org/schema/mvc  
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
                        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
                        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" >
<!-- 开启事务注解驱动 -->  
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" /> 
<!-- 引入配置文件 -->
    <!-- 官方解释 A property resource configurer that resolves placeholders in bean property values of context definitions. It pulls values from a properties file into bean definitions.
      The default placeholder syntax follows the Ant / Log4J / JSP EL style:
      ${...} -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties" />
</bean>


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</bean>

{这里采用的是dbcp连接池}

<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath:sdibt/bird/entity/*.xml"></property>
</bean>


<!-- DAO接口所在包名,Spring会自动查找其下的类 
Mybatis MapperScannerConfigurer 自动扫描 将Mapper接口生成代理注入到Spring
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="sdibt.bird.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>



<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>


<!-- 自动扫描 -->
<context:component-scan base-package="sdibt.bird">
<context:exclude-filter type="regex" expression="sdibt.bird.controller.*"/>
<!-- <context:exclude-filter type="annotation"  expression="org.springframework.stereotype.Controller" /> -->
</context:component-scan>

</beans>

将dbcp连接池改为druid连接池:

1.导入druid jar包

2.

.

6.将jdbc.properties放到resources包下(mysql数据库)

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/ssm?characterEncoding=UTF-8
username=root

password=root

7.开始做后台用户增删改查等功能

顺序:mysql数据库(用户表)-实体类User-实体类映射文件:User.xml-UserDao(接口)-UserService(接口)-UserServiceImpl-UserController-jsp

项目目录:


1.UserDao 接口:


2.UserService接口与UserDao一样

2.UserServiceImpl实现类:

package sdibt.bird.service.impl;


import java.util.List;
import java.util.Map;


import javax.annotation.Resource;


import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;


import sdibt.bird.dao.UserDao;
import sdibt.bird.entity.User;
import sdibt.bird.service.IUserService;
@Service
public class UserServiceImpl implements IUserService {
@Resource
private UserDao userDao;
public UserDao getUserDao() {
return userDao;
}


public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}


@Override
public List<User> allUsers() {
// TODO Auto-generated method stub
return this.userDao.allUsers();
}


@Override
@Transactional
public boolean insertUser(Map map) {
// TODO Auto-generated method stub
boolean b=true;
try {
this.userDao.insertUser(map);
} catch (Exception e) {
// TODO Auto-generated catch block
b=false;
e.printStackTrace();
}
return b;
}


@Override
@Transactional
public boolean delUser(int id) {
boolean b=true;
try {
this.userDao.delUser(id);
} catch (Exception e) {
// TODO Auto-generated catch block
b=false;
e.printStackTrace();
}
return b;
      
}


@Override
public User findUserById(int id) {
// TODO Auto-generated method stub
return this.userDao.findUserById(id);
}


@Override
@Transactional
public  boolean alterUser(User user) {
boolean b=true;
try {
this.userDao.alterUser(user);
} catch (Exception e) {
// TODO Auto-generated catch block
b=false;
e.printStackTrace();
}
return b;
     
}

}

UserController:

package sdibt.bird.controller;


import java.util.HashMap;
import java.util.List;
import java.util.Map;


import javax.annotation.Resource;


import org.springframework.http.HttpRequest;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;


import sdibt.bird.entity.User;
import sdibt.bird.service.IUserService;


@Controller
public class UserController {
@Resource
private IUserService userService;


public IUserService getUserService() {
return userService;
}


public void setUserService(IUserService userService) {
this.userService = userService;
}


/**
* 查询所有用户列表
*/
@RequestMapping("findUsers")
public String findUsers(Map map) {
List<User> users = this.userService.allUsers();
map.put("users", users);
return "user_list";
}
/**
* 增加一个用户
*/
@RequestMapping(value="/insertUser")
public String insertUser(String username,String password){
Map map = new HashMap();
map.put("username", username);
map.put("password", password);
boolean b = this.userService.insertUser(map);
if(b){
return "redirect:/findUsers";
}else{
return "error";
}

}
/**
* 删除一个用户
*/
@RequestMapping(value="/delUser")
public String delUser(@RequestParam(value="id")int id){
boolean b = this.userService.delUser(id);
if(b){
return "redirect:/findUsers";
}else{
return "error";
}
}
/**
* 根据id查到某个用户
*/
@RequestMapping(value="/findUserById")
public String findUserById(Map map,int id){
User user = this.userService.findUserById(id);
map.put("user", user);
return "user_alter";
}
/**
* 更改用户
*/
@RequestMapping(value="/alterUser")
public String alterUser(User user){
//System.out.println(user.getId());
boolean b = this.userService.alterUser(user);
if(b){
return "redirect:/findUsers";
}else{
return "error";
}
}
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值