SSM框架的搭建并实现查询操作-白红宇

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

阅读量：3905 次

发布时间：2019-05-23

本文共 4439 字，大约阅读时间需要 14 分钟。

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

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;}@Overridepublic 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 {

@Autowiredprivate IUserDao userDao;@Overridepublic List
   
     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”/>

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"?>

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=“” %>

新增用户