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

it2022-05-05 150

搭建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”/>

<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>  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  <property name="dataSource" ref="dataSource"/>  <property name="typeAliasesPackage" value="com.zhongruan.bean"></property>  <property name="mapperLocations" value="classpath:mapper/*.xml"/> </bean>   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  <property name="basePackage" value="com.zhongruan.dao"/>  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> </bean>  <context:component-scan base-package="com.zhongruan"/>   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean>  <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"?>

<context:component-scan base-package="com.zhongruan.controller" />  <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/> <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"/>  <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框架的管理系统：简单实现增、删、改、查。

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框架的用户查询项目搭建完成！

专利

最新回复(0)