使用SSM框架实现增删改查

最新推荐文章于 2022-09-29 16:50:12 发布

banmao6200

最新推荐文章于 2022-09-29 16:50:12 发布

阅读量214

点赞数

原文链接：http://www.cnblogs.com/yangshuyuan1009/p/10972693.html

版权

一、目录结构：

二、数据库
数据库设计，数据脚本下载：https://download.csdn.net/download/qq_41879385/10696480，因为博客已经没有免费下载的功能了，所以C币只选最少的，1个就行。

三、项目开始
在pojo包中创建Novel.java（代表novel表）、Coltype.java（代表coltype），当然，里面的字段、类型跟这两张表是一样的。

但是我还要再加一张表：PageNovel.java，这个是分页的表，呃，实体类的话大家都会，我这里就不在贴出来了。贴出一个分页的类：

PageNovel.java：

package cn.item.pojo;

public class PageNovel {
private String novelName;
private String novelColumn;
private Integer page = 1;
private Integer start;
private Integer size = 10;

public String getNovelName() {
return novelName;
}
public void setNovelName(String novelName) {
this.novelName = novelName;
}
public String getNovelColumn() {
return novelColumn;
}
public void setNovelColumn(String novelColumn) {
this.novelColumn = novelColumn;
}
public Integer getPage() {
return page;
}
public void setPage(Integer page) {
this.page = page;
}
public Integer getStart() {
return start;
}
public void setStart(Integer start) {
this.start = start;
}
public Integer getSize() {
return size;
}
public void setSize(Integer size) {
this.size = size;
}

}
在Java Resources下创建一个与src同路径的文件夹config，注意包的名字

在config下创建ApplicationContext-dao.xml：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">


<context:property-placeholder location="classpath:db.properties" />

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="10" />
<property name="maxIdle" value="5" />
</bean>



<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource" />

<property name="configLocation" value="classpath:SqlMapConfig.xml" />
</bean>


<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.item.dao"/>
</bean>

</beans>
ApplicationContext-service.xml：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">


<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource" />
</bean>


<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>

<tx:method name="save*" propagation="REQUIRED" />
<tx:method name="insert*" propagation="REQUIRED" />
<tx:method name="delete*" propagation="REQUIRED" />
<tx:method name="update*" propagation="REQUIRED" />
<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
<tx:method name="get*" propagation="SUPPORTS" read-only="true" />
</tx:attributes>
</tx:advice>


<aop:config>
<aop:advisor advice-ref="txAdvice"
pointcut="execution(* cn.item.service.*.*(..))" />
</aop:config>

</beans>
db.properties：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/你的表名写这?characterEncoding=utf-8
jdbc.username=root
jdbc.password=你的密码写这
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
SpringMvc.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:dubbo="http://code.alibabatech.com/schema/dubbo" xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://code.alibabatech.com/schema/dubbo http://code.alibabatech.com/schema/dubbo/dubbo.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">


<context:property-placeholder location="classpath:resource.properties"/>


<context:component-scan base-package="cn.item.controller"></context:component-scan>


<mvc:annotation-driven conversion-service="conversionService"></mvc:annotation-driven>


<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">


<property name="prefix" value="/WEB-INF/jsp/"></property>

<property name="suffix" value=".jsp"></property>
</bean>


<bean id="conversionService"
class="org.springframework.format.support.FormattingConversionServiceFactoryBean">

</bean>

</beans>
SqlMapConfig.xml：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

</configuration>
web.xml：

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>NovelBook</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:ApplicationContext-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>springMvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:SpringMvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
<servlet-name>springMvc</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>
<filter>
<filter-name>CharacterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
以上的是配置文件，其实我都是直接复制的，然后在修改一下里面的一些包名。注意包名

业务层：service：

NovelService.java：

package cn.item.service;

import java.util.List;

import cn.item.pojo.Coltype;
import cn.item.pojo.Novel;
import cn.item.pojo.PageNovel;

public interface NovelService {

public List<Coltype> findDictByCode(String code);

public List<Novel> findCustomerByVo(PageNovel vo);
public Integer findCustomerByVoCount(PageNovel vo);

public Novel findNovelById(Long id);

public void updateNovelById(Novel novel);

public void deleteNovelById(long id);

public void insertNovelById(Novel novel);

}
NovelServiceImpl.java：

package cn.item.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.item.dao.DictMapper;
import cn.item.dao.NovelMapping;
import cn.item.pojo.Coltype;
import cn.item.pojo.Novel;
import cn.item.pojo.PageNovel;

@Service
public class NovelServiceImpl implements NovelService{

@Autowired
private DictMapper dictMapper;
@Autowired
private NovelMapping novelMapping;

@Override
public List<Coltype> findDictByCode(String code) {
List<Coltype> list = dictMapper.findDictByCode(code);
return list;
}

@Override
public List<Novel> findCustomerByVo(PageNovel vo) {
List<Novel> list = novelMapping.findCustomerByVo(vo);
return list;
}

@Override
public Integer findCustomerByVoCount(PageNovel vo) {
Integer count = novelMapping.findCustomerByVoCount(vo);
return count;
}

@Override
public Novel findNovelById(Long id) {
Novel novel = novelMapping.findNovelById(id);
return novel;
}

@Override
public void updateNovelById(Novel novel) {
novelMapping.updateNovelById(novel);
}

@Override
public void deleteNovelById(long id) {
novelMapping.deleteNovelById(id);
}

@Override
public void insertNovelById(Novel novel) {
novelMapping.insertNovelById(novel);
}

}
数据访问层：dao，也有人用Mapping，都可以：

NovelMapping.java：是小说主表的sql语句的方法，方法名是与service相同的：

package cn.item.dao;

import java.util.List;

import cn.item.pojo.Novel;
import cn.item.pojo.PageNovel;

public interface NovelMapping {

public List<Novel> findCustomerByVo(PageNovel vo);
public Integer findCustomerByVoCount(PageNovel vo);

public Novel findNovelById(Long id);

public void updateNovelById(Novel novel);

public void deleteNovelById(long id);

public void insertNovelById(Novel novel);

}
接下就写映射文件：NovelMapping.xml：注意名称空间不能有空格，之前有次做项目还因为名称空间多了一个空格，结果找了半天没找到原因，在这里提醒大家注意：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.item.dao.NovelMapping">

<sql id="novel_where">
<where>
<if test="novelName !=null and novelName !='' ">
and a.novel_name LIKE '%${novelName}%'
</if>
<if test="novelColumn !=null and novelColumn !='' ">
and a.novel_column=#{novelColumn}
</if>
</where>
</sql>

<select id="findCustomerByVo" parameterType="cn.item.pojo.PageNovel" resultType="cn.item.pojo.Novel">
SELECT a.`novel_id`,a.`novel_name`,a.`author_name`,a.`author_Introduction`,
a.`novel_content`,b.`col_name` novel_column
FROM `novel` a
LEFT JOIN `coltype` b ON a.`novel_column` = b.`col_id`

<include refid="novel_where"></include>

LIMIT #{start},#{size}

</select>

<select id="findCustomerByVoCount" parameterType="cn.item.pojo.PageNovel" resultType="int">
SELECT COUNT(*)
FROM novel a
LEFT JOIN coltype c ON a.novel_column = c.col_id
<include refid="novel_where"></include>
</select>

<select id="findNovelById" parameterType="long" resultType="cn.item.pojo.Novel">
SELECT * FROM novel WHERE novel_id=#{id}
</select>

<update id="updateNovelById" parameterType="cn.item.pojo.Novel">
UPDATE novel
<set>
<if test="novel_name !=null and novel_name !='' ">
novel_name=#{novel_name},
</if>
<if test="novel_column !=null and novel_column !='' ">
novel_column=#{novel_column},
</if>
<if test="author_name !=null and author_name !='' ">
author_name=#{author_name},
</if>
<if test="author_Introduction !=null and author_Introduction !='' ">
author_Introduction=#{author_Introduction},
</if>
<if test="novel_content !=null and novel_content !='' ">
novel_content=#{novel_content},
</if>
</set>
WHERE novel_id=#{novel_id}
</update>

<delete id="deleteNovelById" parameterType="long">
delete from novel where novel_id =#{id}
</delete>

<insert id="insertNovelById" parameterType="cn.item.pojo.Novel">
INSERT INTO `novel`(`novel_name`,`novel_column`,`author_name`,`author_Introduction`,`novel_content`)
VALUE(#{novel_name},#{novel_column},#{author_name},#{author_Introduction},#{novel_content});
</insert>

</mapper>
接下就写DictMapper.java，这个类是为了下拉做的：

package cn.item.dao;

import java.util.List;

import cn.item.pojo.Coltype;

public interface DictMapper {
public List<Coltype> findDictByCode(String code);

}
和DictMapper.java的映射文件：DictMapper.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.item.dao.DictMapper">
<select id="findDictByCode" parameterType="string" resultType="cn.item.pojo.Coltype">
select * from coltype a WHERE a.col_enable=1 AND a.col_code=#{code} ORDER BY a.col_sort
</select>
</mapper>
那么，实体类、数据访问层、业务层都写好了，接下可以写控制层：NovelController.java：

package cn.item.controller;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import cn.itcast.utils.Page;
import cn.item.dao.NovelMapping;
import cn.item.pojo.Coltype;
import cn.item.pojo.Novel;
import cn.item.pojo.PageNovel;
import cn.item.service.NovelService;

@Controller
@RequestMapping("/novel")
public class NovelController {
@Resource
private NovelMapping novelMapping;

@Autowired
private NovelService novelService;

@Value("${novel.col.name}")
private String column;

@RequestMapping("/list")
public String list(PageNovel vo,Model model) throws Exception{

//小说类型
List<Coltype> columnList=novelService.findDictByCode(column);

if(vo.getNovelName()!=null){
vo.setNovelName(new String(vo.getNovelName().getBytes("iso8859-1"),"utf-8"));
}
if(vo.getPage()==null){
vo.setPage(1);
}

vo.setStart((vo.getPage() - 1) * vo.getSize());

//查询数据库的全部数据
List<Novel> resultList = novelService.findCustomerByVo(vo);
Integer count = novelService.findCustomerByVoCount(vo);

Page<Novel> page= new Page<Novel>();
page.setTotal(count); //总条数
page.setSize(vo.getSize()); //每页显示条数
page.setPage(vo.getPage()); //总页数
page.setRows(resultList); //分页的数据

model.addAttribute("page", page);

//下拉菜单
model.addAttribute("fromType", columnList);

model.addAttribute("novelName", vo.getNovelName());
model.addAttribute("novelcolumn", vo.getNovelColumn());

return "novel";
}

@RequestMapping("/detail")
@ResponseBody
public Novel detail(Long id) throws Exception{
Novel novel = novelService.findNovelById(id);
return novel;
}

@RequestMapping("/update")
public String update(Novel novel) throws Exception{
novelService.updateNovelById(novel);
return "novel";
}

@RequestMapping("/delete")
public String delete(long id) throws Exception{
novelService.deleteNovelById(id);
return "novel";
}

@RequestMapping("/insert")
public String insert(Novel novel) throws Exception{
novelService.insertNovelById(novel);
return "novel";
}

}
嗯，控制层就这么一个：接下来可以写jsp了。

第一步，在WEB-INF下创建jsp文件夹，里面创建novel.jsp，在SpringMvc.xml中已经配置完整视图解析器了。

在novel.jsp头部创建c标签：

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
下面是完整的jsp页面代码：

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">

<title>网站</title>

<style type="text/css">
#qrcode-wrapper{
position:absolut;
left:80px;
top:500px;
}
</style>


<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">


<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">


<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">


<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">


<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet"
type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet"
type="text/css">





</head>

<body>

<div id="wrapper">

<div id="qrcode-wrapper" beoder="1">
<div id="qrcodeCanvas"></div>
</div>

<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-wrapper">小说书籍网</h1>
</div>


</div>


<div class="panel panel-default">
<div class="panel-body">
<form class="form-inline" action="${pageContext.request.contextPath }/novel/list.action" method="get">
<div class="form-group">
<label for="novelauthorname">小说名称</label>
<input type="text" class="form-control" id="novelauthorname" value="${novelName}" name="novelName"></input>
</div>
 
<div class="form-group">
<label for="novelColumnFrom">选择小说类型</label>
<select class="form-control" id="novelColumnFrom" name="novelColumn">
<option value="">--请选择--</option>
<c:forEach items="${fromType}" var="item">
<option value="${item.col_id}"<c:if test="${item.col_id == novelColumn}"> selected</c:if>>${item.col_name }</option>
</c:forEach>
</select>
</div>
<button type="submit" class="btn btn-primary">查询</button>
<div class="btn btn-primary" data-toggle="modal" data-target="#novelInsert" οnclick="editNovel(${row.zeng_id})">新增小说</div>
</form>
</div>
</div>

<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-heading">小说书籍网</div>

<table class="table table-bordered table-striped">
<thead>
<tr>
<th>ID</th>
<th>小说名称</th>
<th>所属栏目</th>
<th>小说作者</th>
<th>作者简介</th>
<th>小说摘要</th>
<th>操作</th>
</tr>

<tbody>
<c:forEach items="${page.rows}" var="row">
<tr>
<td>${row.novel_id}</td>
<td>${row.novel_name}</td>
<td>${row.novel_column}</td>
<td>${row.author_name}</td>
<td>${row.author_Introduction}</td>
<td>${row.novel_content}</td>
<td>
<a href="#" class="btn btn-primary btn-xs" data-toggle="modal" data-target="#novelUpdate" οnclick="editNovel(${row.novel_id})">修改</a>
<a href="#" class="btn btn-danger btn-xs" οnclick="deleteNovel(${row.novel_id})">删除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
<div class="col-md-12 text-right">
<itcast:page url="${pageContext.request.contextPath }/novel/list.action" />
</div>

</div>

</div>

</div>
</div>


</div>


<div class="modal fade" id="novelUpdate" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">

<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
<h4 class="modal-title" id="myModalLabel">修改小说图书信息</h4>
</div>

<div class="modal-body">
<form class="form-horizontal" id="edit_novel_form">

<input type="hidden" id="edit_novel_id" name="novel_id"/>
<div class="form-group">
<label for="edit_novel_Name" class="col-sm-2 control-label">小说名称</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_novel_Name" placeholder="小说名称" name="novel_name">
</div>
</div>
<div class="form-group">
<label for="edit_novelColumnFrom" style="float:left;padding:7px 15px 0 27px;">小说类型</label>
<div class="col-sm-10">
<select class="form-control" id="edit_novelColumnFrom" placeholder="小说类型" name="novel_column">
<option value="">--请选择--</option>
<c:forEach items="${fromType}" var="item">
<option value="${item.col_id}"<c:if test="${item.col_id == novelColumnFrom}"> selected</c:if>>${item.col_name }</option>
</c:forEach>
</select>
</div>
</div>
<div class="form-group">
<label for="edit_author_name" class="col-sm-2 control-label">小说作者</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_author_name" placeholder="小说作者" name="author_name">
</div>
</div>
<div class="form-group">
<label for="edit_author_Introduction" class="col-sm-2 control-label">作者简介</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_author_Introduction" placeholder="作者简介" name="author_Introduction">
</div>
</div>
<div class="form-group">
<label for="edit_novel_content" class="col-sm-2 control-label">小说内容</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_novel_content" placeholder="小说内容摘要" name="novel_content">
</div>
</div>

</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
<button type="button" class="btn btn-primary" οnclick="updateNovelById()">确定修改小说书籍信息</button>
</div>
</div>
</div>
</div>



<div class="modal fade" id="novelInsert" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">

<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
<h4 class="modal-title" id="myModalLabel">添加小说书籍</h4>
</div>

<div class="modal-body">
<form class="form-horizontal" id="edit_novel_zeng">
<input type="hidden" id="edit_novel_id" name="zeng_id"/>
<div class="form-group">
<label for="edit_novel_Name" class="col-sm-2 control-label">小说名称</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_novel_Name" placeholder="小说名称" name="novel_name">
</div>
</div>
<div class="form-group">
<label for="edit_novelColumnFrom" style="float:left;padding:7px 15px 0 27px;">小说类型</label>
<div class="col-sm-10">
<select class="form-control" id="edit_novelColumnFrom" placeholder="小说类型" name="novel_column">
<option value="">--请选择--</option>
<c:forEach items="${fromType}" var="item">
<option value="${item.col_id}"<c:if test="${item.col_id == novelColumnFrom}"> selected</c:if>>${item.col_name }</option>
</c:forEach>
</select>
</div>
</div>
<div class="form-group">
<label for="edit_author_name" class="col-sm-2 control-label">小说作者</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_author_name" placeholder="小说作者" name="author_name">
</div>
</div>
<div class="form-group">
<label for="edit_author_Introduction" class="col-sm-2 control-label">作者简介</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_author_Introduction" placeholder="作者简介" name="author_Introduction">
</div>
</div>
<div class="form-group">
<label for="edit_novel_content" class="col-sm-2 control-label">小说内容</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="edit_novel_content" placeholder="小说内容摘要" name="novel_content">
</div>
</div>

</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
<button type="button" class="btn btn-primary" οnclick="insertNovelById()">确定添加小说书籍</button>
</div>
</div>
</div>
</div>



<script src="<%=basePath%>js/jquery.min.js"></script>


<script src="<%=basePath%>js/jquery-1.11.1.js"></script>
<script src="<%=basePath%>js/jquery.qrcode.js"></script>
<script src="<%=basePath%>js/qrcode.js"></script>
<script src="<%=basePath%>js/utf.js"></script>


<script src="<%=basePath%>js/bootstrap.min.js"></script>


<script src="<%=basePath%>js/metisMenu.min.js"></script>


<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>


<script src="<%=basePath%>js/sb-admin-2.js"></script>

<script type="text/javascript">

function editNovel(id) {
$.ajax({
type:"get",
url:"<%=basePath%>novel/detail.action",
data:{"id":id},
success:function(data) {
$("#edit_novel_id").val(data.novel_id);
$("#edit_novel_name").val(data.novel_name);
$("#edit_novelColumnFrom").val(data.novel_column)
$("#edit_author_name").val(data.author_name);
$("#edit_author_Introduction").val(data.author_Introduction);
$("#edit_novel_content").val(data.novel_content)
}
});
}

function updateNovelById() {
$.post("<%=basePath%>novel/update.action",$("#edit_novel_form").serialize(),function(data){
alert("小说图书书籍更新成功！");
window.location.reload();
});
}

function deleteNovel(id) {
if(confirm('确实要删除该客户吗?')) {
$.post("<%=basePath%>novel/delete.action",{"id":id},function(data){
alert("小说删除更新成功！");
window.location.reload();
});
}
}

function insertNovelById(){
$.post("<%=basePath%>novel/insert.action",$("#edit_novel_zeng").serialize(),function(data){
alert("新增小说书籍成功");
window.location.reload();
})
}

jQuery('#qrcodeCanvas').qrcode({
text: "https://blog.csdn.net/qq_41879385",
width: "110", //二维码的宽度
height: "110", //二维码的高度
background: "#ffffff", //二维码的后景色
foreground: "#000000", //二维码的前景色
src: "<%=basePath%>image/xingkong.jpg" //二维码中间的图片
});

</script>
</body>

</html>
运行效果：数据可能有点少，因为我之前数据库重装结果一不小心就把整个数据库的文件全部删除了，当时我真的心痛啊，编写了2年是SQL语句一下子全部没了，我叫那个心痛啊，不过还好本人数据库还算牛逼一点嘻嘻，很快有些了一个数据，呃，在我给的数据库脚本中是有添加的SQL语句的，用那些sql语句就可以添加了。