久久建筑网 百度网盘,商用营销型网站建设优化建站,如何分析网站设计,网站建设 好大家好#xff0c;我是雄雄#xff0c;欢迎关注微信公众号【雄雄的小课堂】。前言书接前文#xff0c;昨天带着大家下载且配置了maven#xff0c;以及在idea中创建maven项目#xff0c;今天#xff0c;我们就结合ssm框架#xff0c;在idea中实现一个增删改查案例。昨天的… 大家好我是雄雄欢迎关注微信公众号【雄雄的小课堂】。前言书接前文昨天带着大家下载且配置了maven以及在idea中创建maven项目今天我们就结合ssm框架在idea中实现一个增删改查案例。昨天的文章手把手教你搭建Maven项目01配置pom文件通常我们需要使用ssm框架的时候需要加载一系列的jar包在未使用maven的时候我们则采用的是将所需jar包统统复制到项目的lib目录中现在我们不必那样做了只需要简单的在pom文件中配置即可。那么怎么配置呢我们以mysql的驱动jar为例其他jar包配置方式一样可执行按此配置mysql的驱动jar包我采用的是mysql-connector-java-8.0.23配置方式如下1maven官网为我们提供了jar包在pom文件中的配置方式打开官网https://search.maven.org/我们在输入框中输入需要配置的jar包名如下可以在左边框中的下拉列表里选择版本在右边的Apache Maven下面复制所有代码。复制到项目中pom文件的这里如果你不知道ssm需要哪些jar包可以去百度搜索pom中配置方式是一样的在这就不一一列举了下面是整个pom.xml文件的代码?xml version1.0 encodingUTF-8?project xmlnshttp://maven.apache.org/POM/4.0.0 xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdcom.xiongxiong/groupIdartifactIdBookManageSys/artifactIdversion1.0-SNAPSHOT/versionpackagingwar/packagingnameBookManageSys Maven Webapp/name!-- FIXME change it to the projects website --urlhttp://www.example.com/urlpropertiesproject.build.sourceEncodingUTF-8/project.build.sourceEncodingmaven.compiler.source1.7/maven.compiler.sourcemaven.compiler.target1.7/maven.compiler.target/propertiesdependencies!--配置jar包--dependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.11/versionscopetest/scope/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.23/version/dependency!--spring的jar包--!--springmvc的jar包--dependencygroupIdjavaee/groupIdartifactIdjavaee-api/artifactIdversion5/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-core/artifactIdversion4.2.5.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-beans/artifactIdversion4.2.2.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-context/artifactIdversion4.2.2.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-tx/artifactIdversion4.1.9.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-aspects/artifactIdversion4.2.1.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-context-support/artifactIdversion4.1.9.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion4.2.3.release/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-test/artifactIdversion4.1.9.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-web/artifactIdversion4.2.3.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion4.1.9.RELEASE/version/dependencydependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.2.2/version/dependencydependencygroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactIdversion1.3.0/version/dependencydependencygroupIdorg.javassist/groupIdartifactIdjavassist/artifactIdversion3.17.1-GA/version/dependencydependencygroupIdcglib/groupIdartifactIdcglib/artifactIdversion2.2.2/version/dependencydependencygroupIdc3p0/groupIdartifactIdc3p0/artifactIdversion0.9.1.2/version/dependency!--加载jstl的包--dependencygroupIdjstl/groupIdartifactIdjstl/artifactIdversion1.2/version/dependency/dependenciesbuildfinalNameBookManageSys/finalNamepluginManagement!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) --pluginspluginartifactIdmaven-clean-plugin/artifactIdversion3.1.0/version/plugin!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging --pluginartifactIdmaven-resources-plugin/artifactIdversion3.0.2/version/pluginpluginartifactIdmaven-compiler-plugin/artifactIdversion3.8.0/version/pluginpluginartifactIdmaven-surefire-plugin/artifactIdversion2.22.1/version/pluginpluginartifactIdmaven-war-plugin/artifactIdversion3.2.2/version/pluginpluginartifactIdmaven-install-plugin/artifactIdversion2.5.2/version/pluginpluginartifactIdmaven-deploy-plugin/artifactIdversion2.8.2/version/plugin/plugins/pluginManagement/build
/project这是最后导入的jar包02在main目录中创建resources资源文件夹该资源文件夹用来存放ssm的配置文件applicationContext.xml,springmvc-servlet.xml,mybatis-config.xml。各配置文件代码如下applicationContext.xml文件?xml version1.0 encodingUTF-8?
beansxmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:mvchttp://www.springframework.org/schema/mvcxmlns:contexthttp://www.springframework.org/schema/contextxsi:schemaLocationhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd!-- 配置数据源--bean iddataSource classorg.springframework.jdbc.datasource.DriverManagerDataSourceproperty namedriverClassName valuecom.mysql.jdbc.Driver/propertyproperty nameurl valuejdbc:mysql://localhost:3306/schooldb/propertyproperty nameusername valueroot/propertyproperty namepassword valueroot/property/bean!--sqlSessionFactory --bean idsqlSessionFactory classorg.mybatis.spring.SqlSessionFactoryBeanproperty namedataSource refdataSource/propertyproperty nameconfigLocation valueclasspath:mybatis-config.xml/propertyproperty namemapperLocationslistvalueclasspath:com/dao/*.xml/value/list/property/bean!-- 配置自动映射器 --bean classorg.mybatis.spring.mapper.MapperScannerConfigurerproperty namebasePackage valuecom.dao/property/bean!-- 扫描所有注解信息 --context:component-scan base-packagecom.dao,com.service,com.web/mvc:annotation-driven//beansspringmvc-servlet.xml文件?xml version1.0 encodingUTF-8?
beansxmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:phttp://www.springframework.org/schema/pxmlns:aophttp://www.springframework.org/schema/aopxmlns:mvchttp://www.springframework.org/schema/mvcxmlns:contexthttp://www.springframework.org/schema/contextxsi:schemaLocationhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsdhttp://www.springframework.org/schema/p http://www.springframework.org/schema/p/spring-p-3.1.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd!-- 扫描注解 --context:component-scan base-packagecom.web,com.dao,com.service/mvc:annotation-driven/!--扫描静态资源文件--mvc:default-servlet-handler/!-- 配置前缀和后缀 --bean classorg.springframework.web.servlet.view.InternalResourceViewResolverproperty nameprefix value//propertyproperty namesuffix value.jsp/property/bean/beansmybatis-config.xml文件?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configurationsettings!-- 打印sql语句 --setting namelogImpl valueSTDOUT_LOGGING//settings!-- 起别名 --typeAliasespackage namecom.entity//typeAliases/configuration03配置web.xml文件web.xml文件所在的路径src/main/webapp/WEB/INF/wen.xml代码如下!DOCTYPE web-app PUBLIC-//Sun Microsystems, Inc.//DTD Web Application 2.3//ENhttp://java.sun.com/dtd/web-app_2_3.dtd web-app xmlnshttp://xmlns.jcp.org/xml/ns/javaeexmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsdversion4.0display-nameArchetype Created Web Application/display-namewelcome-file-listwelcome-file//welcome-file/welcome-file-list!-- springmvc的配置 --servletservlet-namespringmvc/servlet-nameservlet-classorg.springframework.web.servlet.DispatcherServlet/servlet-classinit-paramparam-namecontextConfigLocation/param-nameparam-valueclasspath:springmvc-servlet.xml/param-value/init-paramload-on-startup1/load-on-startup/servletservlet-mappingservlet-namespringmvc/servlet-nameurl-pattern//url-pattern/servlet-mapping!-- spring --context-paramparam-namecontextConfigLocation/param-nameparam-valueclasspath:applicationContext.xml/param-value/context-param!-- 监听配置 --listenerlistener-classorg.springframework.web.context.ContextLoaderListener/listener-class/listener!-- 解决springmvc传递值乱码问题 --filterfilter-nameencodingFilter/filter-namefilter-classorg.springframework.web.filter.CharacterEncodingFilter/filter-classinit-paramparam-nameencoding/param-nameparam-valueutf-8/param-value/init-paraminit-paramparam-nameforceEncoding/param-nameparam-valuetrue/param-value/init-param/filterfilter-mappingfilter-nameencodingFilter/filter-nameurl-pattern/*/url-pattern/filter-mapping
/web-app04创建src资源资源文件夹在main文件夹中创建资源文件夹src,且在里面创建实体层、Dao层、Service层和web层。下面我们来在src中创建包com包名随便起,在com中分别创建entity、dao、service以及web包Package,分别在各个包中创建对应的类其目录结构如下下面是各个类的代码BookManage.javapackage com.entity;import org.springframework.format.annotation.DateTimeFormat;import java.util.Date;public class BookManage {private int bid;private String bname;private String bauthor;DateTimeFormat(pattern yyyy-MM-dd)private Date btime;private int btype;public int getBid() {return bid;}public void setBid(int bid) {this.bid bid;}public String getBname() {return bname;}public void setBname(String bname) {this.bname bname;}public String getBauthor() {return bauthor;}public void setBauthor(String bauthor) {this.bauthor bauthor;}public Date getBtime() {return btime;}public void setBtime(Date btime) {this.btime btime;}public int getBtype() {return btype;}public void setBtype(int btype) {this.btype btype;}
}BookManageMapper.javapackage com.dao;import com.entity.BookManage;import java.util.List;public interface BookManageMapper {//查询全部ListBookManage findBookAll();//添加int addBook(BookManage bookManage);//删除int delBook(int bid);
}BookManageMapper.xml?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.dao.BookManageMapper!-- 查询全部 --select idfindBookAll resultTypeBookManageselect * from BookManage;/select!-- 添加 --insert idaddBook parameterTypeBookManageinsert into bookmanage (bname,bauthor,btime,btype)value(#{bname},#{bauthor},#{btime},#{btype});/insert!-- 删除 --delete iddelBook parameterTypeintdelete from BookManage where bid #{bid};/delete/mapperIBookManageService.javapackage com.service;import com.entity.BookManage;import java.util.List;public interface IBookManageService {//查询全部ListBookManage findBookAll();//添加int addBook(BookManage bookManage);//删除int delBook(int bid);
}BookManageServiceImpl.javapackage com.service.impl;import com.dao.BookManageMapper;
import com.entity.BookManage;
import com.service.IBookManageService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;Service(bookManageService)
public class BookManageServiceImpl implements IBookManageService {Autowiredprivate BookManageMapper bookManageMapper;Overridepublic ListBookManage findBookAll() {return bookManageMapper.findBookAll();}Overridepublic int addBook(BookManage bookManage) {return bookManageMapper.addBook(bookManage);}Overridepublic int delBook(int bid) {return bookManageMapper.delBook(bid);}public BookManageMapper getBookManageMapper() {return bookManageMapper;}public void setBookManageMapper(BookManageMapper bookManageMapper) {this.bookManageMapper bookManageMapper;}
}IndexController.javapackage com.web;import com.entity.BookManage;
import com.service.IBookManageService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;import java.util.List;Controller
RequestMapping(/)
public class IndexController {//创建Service的对象Autowiredprivate IBookManageService bookManageService;//默认进入首页RequestMapping(/)public String index(Model model){ListBookManage bookManageList bookManageService.findBookAll();model.addAttribute(bookManageList,bookManageList);return index;}//删除RequestMapping(delBook)public String delBook(Model model,int bid){bookManageService.delBook(bid);index(model);return index;}//添加RequestMapping(addBook)public String addBook(BookManage bookManage,Model model){bookManageService.addBook(bookManage);index(model);return index;}public IBookManageService getBookManageService() {return bookManageService;}public void setBookManageService(IBookManageService bookManageService) {this.bookManageService bookManageService;}
}05引入jQuery环境将jquery的环境拷贝到项目中的webapp下06首页修改index.jsp,使其实现进入页面即查询数据库中所有数据功能代码如下%--Created by IntelliJ IDEA.User: 24519Date: 2021/1/20Time: 10:38To change this template use File | Settings | File Templates.
--%
% page isELIgnoredfalse%
% page contentTypetext/html;charsetUTF-8 languagejava %
%taglib prefixc urihttp://java.sun.com/jsp/jstl/core %
%taglib prefixf urihttp://java.sun.com/jsp/jstl/fmt %
htmlheadtitle首页/title/headbodyh1图书信息/h1table border1trtd图书名称/tdtd图书作者/tdtd购买时间/tdtd图书分类/tdtd操作/td/trc:forEach items${bookManageList} varbooktrtd${book.bname}/tdtd${book.bauthor}/tdtdf:formatDate value${book.btime} patternyyyy-MM-dd/f:formatDate/tdtdc:if test${book.btype1}计算机/软件/c:ifc:if test${book.btype2}小说/文摘/c:ifc:if test${book.btype3}杂项/c:if/tdtda hrefdelBook?bid${book.bid}删除/a/td/tr/c:forEach/tablea hrefaddBook.jsp stylecolor:red新增图书信息/ascript srcjs/jquery-1.12.4.js typetext/javascript/scriptscript typetext/javascript$(function(){$(tr:even).css(background,green);$(tr:first).css(background,blue);});/script/body
/html07添加图书的页面创建添加数据的页面addBook.jsp,代码如下注意addBook.jsp和index.jsp都需要放在webapp目录下。08配置tomcat配置tomcat测试发现正常运行。最后附数据库脚本代码/*
SQLyog Professional v12.08 (32 bit)
MySQL - 5.5.27 : Database - schooldb
*********************************************************************
*//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE*/;/*!40014 SET OLD_UNIQUE_CHECKSUNIQUE_CHECKS, UNIQUE_CHECKS0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS0 */;
/*!40101 SET OLD_SQL_MODESQL_MODE, SQL_MODENO_AUTO_VALUE_ON_ZERO */;
/*!40111 SET OLD_SQL_NOTESSQL_NOTES, SQL_NOTES0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/schooldb /*!40100 DEFAULT CHARACTER SET utf8 */;USE schooldb;/*Table structure for table bookmanage */DROP TABLE IF EXISTS bookmanage;CREATE TABLE bookmanage (bid int(11) NOT NULL AUTO_INCREMENT,bname varchar(40) NOT NULL,bauthor varchar(40) NOT NULL,btime datetime NOT NULL,btype int(11) NOT NULL,PRIMARY KEY (bid)
) ENGINEInnoDB AUTO_INCREMENT5 DEFAULT CHARSETutf8;/*Data for the table bookmanage */insert into bookmanage(bid,bname,bauthor,btime,btype) values (1,三国演义,罗贯中,2021-09-08 00:00:00,2),(2,水浒传,施耐庵,2021-09-08 00:00:00,2),(3,狂人日记,魯迅,2021-09-08 00:00:00,3),(4,改善java的151个建议,秦少波,2021-09-08 00:00:00,1);/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;今天的分享就到这里了明天见往期精彩手把手教你搭建Maven项目2021-02-22 java中采用异常链传递异常既友好又方便2021-02-20 新春视频剪辑2021-02-21 提倡异常封装2021-02-19 想着看你手头宽裕的话帮我周转一下……2021-02-17 点分享点点赞点在看
