这篇文章没有加过滤器,所以字符有乱码的问题
所用技术或工具:
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)