导出数据库数据并实现增删改查功能

来源：互联网发布：阿里巴巴的域名是什么编辑：程序博客网时间：2024/05/29 17:21

简单的小测试，导出一张数据表的数据，并在表中添加增删改查按钮。

前端页面代码

<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head>    <title>Title</title></head><body><table>    <tr>        <th>id</th>        <th>sql_name</th>        <th>sql_detail</th>        <th>description</th>        <th>删除</th>        <th>修改</th>    </tr>    <c:forEach items="${data}" var="one" varStatus="num" >        <tr>            <td>${one.id}</td>            <td>${one.sqlName}</td>            <td>${one.sqlDetail}</td>            <td>${one.description}</td>            <%--<td><button type="button" class="del" onclick="del(${one.id})" href="/form/formsql/delete/data=">删除</button> </td>--%>            <td>                <form class="del" action="/lab/form/formsql/delete" method="post">                    <input type="hidden" name="id" value="${one.id}">                    <input type="submit" value="删除">                </form>            </td>            <td>                <form class="updated" action="/lab/form/formsql/updated" method="post">                    <input type="hidden" name="id" value="${one.id}">                    <input type="text" name="up">                    <input type="submit" value="更新">                </form>            </td>        </tr>    </c:forEach></table><form id="insert" action="/lab/form/formsql/insert" method="post">    name:<input type="text" name="sqlname">    sql_name:<input type="text" name="detail">    description:<input type="text" name="desc">    <input type="submit" value="新增"></form></body></html>

后台controller代码
//包括数据库基本操作的全部代码

import com.yunjuanyunshu.modules.form.entity.FormSql;import com.yunjuanyunshu.modules.form.service.FormSqlService;import com.yunjuanyunshu.modules.form.util.SqlCrud;import net.sf.json.JSONArray;import net.sf.json.JSONObject;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.ui.Model;import java.sql.SQLException;import java.util.ArrayList;import java.util.Date;import java.util.Iterator;import java.util.List;/** * Created by 11655 on 2017-07-25. */@Controllerpublic class mainController {    @Autowired    private FormSqlService formSqlService;    @RequestMapping(value = "/form/crud",method = RequestMethod.POST)    @ResponseBody    public JSONObject crud(@RequestParam("method")String type,@RequestParam("jsonobject")String jsonObject) throws SQLException {       JSONObject jsonObject1=JSONObject.fromObject(jsonObject);        return  formSqlService.crud(type,jsonObject1);    }    @RequestMapping(value = "/form/crud",method = RequestMethod.GET)    public String crudYemian() throws SQLException {        return  "modules/form/formSqlForm";    }    @RequestMapping(value = "/form/formsql",method = RequestMethod.GET)    public String formsqlYemian(Model model) throws SQLException {        JSONArray jsonArray = JSONArray.fromObject(formSqlService.selectAll());        model.addAttribute("data",jsonArray);        return  "modules/form/formsql";    }    //删除指定数据    @RequestMapping(value = "/form/formsql/delete",method = RequestMethod.POST)    public String formsqlDelete(@RequestParam("id")int id,Model model){        formSqlService.deleteByPrimaryKey(Integer.valueOf(id));        JSONArray jsonArray = JSONArray.fromObject(formSqlService.selectAll());        model.addAttribute("data",jsonArray);        return "modules/form/formsql";    }    //    {"sql_name":"测试","sql_detail":"用来测试的！！","description":"fadsf"}    @RequestMapping(value = "/form/formsql/insert",method = RequestMethod.POST)    public String  formsqlInsert(@RequestParam("sqlname")String sqlname,@RequestParam("detail")String detail,@RequestParam("desc")String desc,Model model){        FormSql formSql = new FormSql();        formSql.setSqlDetail(detail);        formSql.setSqlName(sqlname);        formSql.setDescription(desc);        int i = formSqlService.insertSelective(formSql);        JSONArray jsonArray = JSONArray.fromObject(formSqlService.selectAll());        model.addAttribute("data",jsonArray);        return "modules/form/formsql";    }    //更新指定数据    @RequestMapping(value = "/form/formsql/updated",method = RequestMethod.POST)    public String formsqlUpdated(@RequestParam("id")int id,@RequestParam("up")String up,Model model){        JSONObject jsonObject1 = JSONObject.fromObject(up);        Iterator it = jsonObject1.keys();        FormSql formSql = formSqlService.selectByPrimaryKey(id);        while (it.hasNext()){            String key = it.next().toString();            if (key.equals("sql_name"))                formSql.setSqlName(jsonObject1.getString(key));            if (key.equals("sql_detail"))                formSql.setSqlDetail(jsonObject1.getString(key));            if (key.equals("description"))                formSql.setDescription(jsonObject1.getString(key));        }        formSql.setLastUpdated(new Date());        formSqlService.updateByPrimaryKeySelective(formSql);        JSONArray jsonArray = JSONArray.fromObject(formSqlService.selectAll());        model.addAttribute("data",jsonArray);        return "modules/form/formsql";    }}

阅读全文

0 0