JSP实现添加分类、查询分类


这篇文章没有加过滤器,所以字符有乱码的问题

所用技术或工具:
MyEclipse
EL+JSTL
dbutils+c3p0
MVC

这里写图片描述


chaxun.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


<title>My JSP 'chaxun.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<link rel="stylesheet"
    href="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/css/bootstrap.min.css">
<script
    src="http://cdn.static.runoob.com/libs/jquery/2.1.1/jquery.min.js"></script>
<script
    src="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>

<body class="container">

    <table class="table">
        <tr>
            <td>名字</td>
            <td>描述</td>
        </tr>
        <c:forEach var="mm" items="${list }">
            <tr>
                <td>${mm.name }</td>
                <td>${mm.descr }</td>
            </tr>

        </c:forEach>

        <br>
        <br>

        <select name="xiala" >
            <c:forEach var="mm" items="${list }">
                <option value=${mm.name}>${mm.name}</option>
            </c:forEach>
        </select>
    </table>
</body>
</html>

tianjia.jsp


<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>My JSP 'tianjia.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
<link rel="stylesheet"
    href="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/css/bootstrap.min.css">
<script
    src="http://cdn.static.runoob.com/libs/jquery/2.1.1/jquery.min.js"></script>
<script
    src="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>

<body class="container">
    <div class="page-header">添加一个种类</div>
    <form method="post" action="${pageContext.request.contextPath }/servlet/categoryServlet?type=tianjia">
        <div class="form-group">
            <label class="control-label">请输入种类名字</label> <input type="text"
                name="namee" class="form-control" />
        </div>

        <div class="form-group">
            <label class="control-label">描述</label> <input type="textArea"
                name="miaoshu" class="form-control" />
        </div>

        <div class="form-group">
            <input type="submit" value="提交 "  class="btn btn-primary" />
        </div>
    </form>
</body>
</html>


web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" 
    xmlns="http://java.sun.com/xml/ns/javaee" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
    http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
  <display-name></display-name>
  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>categoryServlet</servlet-name>
    <servlet-class>com.hai.servlet.categoryServlet</servlet-class>
  </servlet>

  <servlet-mapping>
    <servlet-name>categoryServlet</servlet-name>
    <url-pattern>/servlet/categoryServlet</url-pattern>
  </servlet-mapping>    
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>


categroyDao.java

package com.hai.dao;

import java.awt.print.Book;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.hai.domain.category;
import com.hai.utils.JdbcUtils;
import com.sun.xml.internal.ws.util.xml.CDATA;

public class categroyDao {

      public void charu(category cg){  //添加一种类
            try{
                QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
                String sql = "insert into category(id,name,descr) values(?,?,?)";
                Object params[] = {cg.getId(),cg.getName(),cg.getDescr()};
                runner.update(sql, params);
            }catch (Exception e) {
                throw new RuntimeException(e);
            }
        }


      public List<category> chaxun(){  //添加一种类
          try{
              QueryRunner runner = new QueryRunner(JdbcUtils.getDataSource());
              String sql = "select * from category";
          List<category>   list=  (List<category>) runner.query(sql, new BeanListHandler(category.class));
          return list;
          }catch (Exception e) {
              throw new RuntimeException(e);
          }
      }
}


category.java

package com.hai.domain;

public class category {
private String id;
private String name;
private String descr;
public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getName() {
    return name;
}
public void setName(String name) {
    this.name = name;
}
public String getDescr() {
    return descr;
}
public void setDescr(String descr) {
    this.descr = descr;
}
}


categoryServlet.java

package com.hai.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.hai.dao.categroyDao;
import com.hai.domain.category;
import com.hai.utils.WebUtils;

public class categoryServlet extends HttpServlet {

    public categoryServlet() {
        super();
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
String lei=request.getParameter("type");
if(lei.equals("tianjia")){
    tianjia(request,response);
}
    }

    private void tianjia(HttpServletRequest request,
            HttpServletResponse response) {
    category mm=new category();
    mm.setId(WebUtils.makeID());
    mm.setName(request.getParameter("namee"));
    mm.setDescr(request.getParameter("miaoshu"));
    categroyDao dd=new categroyDao();
    dd.charu(mm);
List<category> listt=   dd.chaxun();
request.setAttribute("list", listt);
try {
    request.getRequestDispatcher("/chaxun.jsp").forward(request, response);
} catch (ServletException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
} catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}



    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        doGet(request, response);
    }

}


JdbcUtils.java

package com.hai.utils;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JdbcUtils {
    private static DataSource ds = null;
    static{
        ds = new ComboPooledDataSource();
    }

    public static DataSource getDataSource(){
        return ds;
    }

    public static Connection getConnection() throws SQLException{
        return ds.getConnection();
    }
}


WebUtils.java

package com.hai.utils;

import java.util.UUID;

public class WebUtils {

    public static String makeID(){
        return UUID.randomUUID().toString();
    }
}


c3p0-config.xml

<?xml version="1.0" encoding="UTF-8"?>


<c3p0-config>
    <default-config>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/xuhaitao</property>
        <property name="user">root</property>
        <property name="password">root</property>

        <property name="acquireIncrement">5</property>
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">20</property>


    </default-config>

    <named-config name="flx">
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/day16</property>
        <property name="user">root</property>
        <property name="password">root</property>
        <property name="acquireIncrement">50</property>
        <property name="initialPoolSize">100</property>
        <property name="minPoolSize">50</property>
        <property name="maxPoolSize">1000</property><!-- intergalactoApp adopts a different approach to configuring statement caching -->
    </named-config>

</c3p0-config>

最后效果截图:
这里写图片描述



这里写图片描述


FR:海涛高软(QQ技术交流群:386476712)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值