Servlet+JSP开发简单实例

1.数据库Oracle

2.代码
导JAR包：1.jsp-api.jar ; 2.jstl.jar ; 3.ojdbc6.jar ; 4.servlet-api.jar ; 5.standard.jar
​ 2.1实体类domain

package com.userinfos.domain;import java.util.Date;public class userinfos {    private int userid;    private String username;    private Date birthday;    public int getUserid() {        return userid;    }    public void setUserid(int userid) {        this.userid = userid;    }    public String getUsername() {        return username;    }    public void setUsername(String username) {        this.username = username;    }    public Date getBirthday() {        return birthday;    }    public void setBirthday(Date birthday) {        this.birthday = birthday;    }}

2.2工具类tools

package com.userinfos.tools;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DbUtil {    private static final String DRIVER="oracle.jdbc.driver.OracleDriver";    private static final String URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";    private static final String USERNAME="yangjun";    private static final String PASSWORD="yj";    private static Connection conn;    static{        try {            Class.forName(DRIVER);            conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    private DbUtil(){};    public static Connection getConnection(){        return conn;    }}

package com.userinfos.tools;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DbManager {    private Connection conn;    private PreparedStatement pstat;    private ResultSet rs;    public DbManager(){        conn=DbUtil.getConnection();    }    public int update(String sql,Object[]params){        int count =0;        try {            pstat=conn.prepareStatement(sql);            for (int i = 0; i < params.length; i++) {                pstat.setObject(i+1, params[i]);            }            count = pstat.executeUpdate();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return count;    }    public ResultSet query(String sql,Object[]params){        try {            pstat=conn.prepareStatement(sql);            for (int i = 0; i < params.length; i++) {                pstat.setObject(i+1, params[i]);            }            rs = pstat.executeQuery();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return rs;    }}

2.3 dao类

package com.userinfos.dao;import java.sql.ResultSet;import java.sql.SQLException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.List;import com.userinfos.domain.Userinfos;import com.userinfos.tools.DbManager;public class UserinfosDAO {    private DbManager dbm;    public UserinfosDAO(){        dbm = new DbManager();    }    public void save(Userinfos user){        String sql = "insert into userinfos values(seq_userid,?,to_date(?,'yyyy-mm-dd'))";        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");        dbm.update(sql, new Object[]{user.getUsername(), sdf.format(user.getBirthday())});    }    public void delete(int userid){        String sql = "delete from userinfos where userid=?";        dbm.update(sql, new Object[]{userid});    }    public void update(Userinfos user){        String sql = "update userinfos set username=?,birthday=to_date(?, 'yyyy-mm-dd') where userid=?";        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");        dbm.update(sql, new Object[]{user.getUsername(), sdf.format(user.getBirthday()), user.getUserid()});    }    public Userinfos findUserById(int userid){        String sql = "select * from userinfos where userid=?";        ResultSet rs = dbm.query(sql, new Object[]{userid});        Userinfos user = new Userinfos();        try {            if (rs.next()) {                user.setUserid(rs.getInt("userid"));                user.setUsername(rs.getString("username"));                user.setBirthday(rs.getDate("birthday"));            }        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return user;    }    public List<Userinfos> findAll(){        String sql = "select * from userinfos";        ResultSet rs = dbm.query(sql, new Object[]{});        List<Userinfos> users = new ArrayList<Userinfos>();        try {            while (rs.next()) {                Userinfos user = new Userinfos();                user.setUserid(rs.getInt("userid"));                user.setUsername(rs.getString("username"));                user.setBirthday(rs.getDate("birthday"));                users.add(user);            }        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return users;    }}

2.4服务类services

package com.userinfos.services;import java.util.List;import com.userinfos.dao.UserinfosDAO;import com.userinfos.domain.Userinfos;public class NormalService {    private UserinfosDAO udao;    public NormalService(){        udao = new UserinfosDAO();    }    public void save(Userinfos user){        udao.save(user);    }    public void delete(int userid){        udao.delete(userid);    }    public void update(Userinfos user){        udao.update(user);    }    public Userinfos findUserById(int userid){        return udao.findUserById(userid);    }    public List<Userinfos> findAll(){        return udao.findAll();    }    public static void main(String[] args) {        NormalService ns = new NormalService();        System.out.println(ns.findUserById(7));    }}

2.5实现类action，init传入数据至前端

​ 2.5.1删除

package com.test.action;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.test.services.NormalService;/** * Servlet implementation class DeleteAction */@WebServlet("/delete")public class DeleteAction extends HttpServlet {    private static final long serialVersionUID = 1L;    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        doPost(request, response);    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        int userid = Integer.parseInt(request.getParameter("userid"));        new NormalService().delete(userid);        response.sendRedirect("init");    }}

2.5.2新增

package com.test.action;import java.io.IOException;import java.text.ParseException;import java.text.SimpleDateFormat;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.test.domain.Userinfos;import com.test.services.NormalService;/** * Servlet implementation class SaveAction */@WebServlet("/save")public class SaveAction extends HttpServlet {    private static final long serialVersionUID = 1L;    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        doPost(request, response);    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        Userinfos user = new Userinfos();        user.setUsername(request.getParameter("username"));        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");        try {            user.setBirthday(sdf.parse(request.getParameter("birthday")));        } catch (ParseException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        new NormalService().save(user);        response.sendRedirect("init");    }}

2.5.3修改

package com.test.action;import java.io.IOException;import java.text.ParseException;import java.text.SimpleDateFormat;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.test.domain.Userinfos;import com.test.services.NormalService;/** * Servlet implementation class UpdateAction */@WebServlet("/update")public class UpdateAction extends HttpServlet {    private static final long serialVersionUID = 1L;    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        doPost(request, response);    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        Userinfos user = new Userinfos();        user.setUserid(Integer.parseInt(request.getParameter("userid")));        user.setUsername(request.getParameter("username"));        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");        try {            user.setBirthday(sdf.parse(request.getParameter("birthday")));        } catch (ParseException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        new NormalService().update(user);        response.sendRedirect("init");    }}

2.5.4单查

package com.test.action;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.test.services.NormalService;/** * Servlet implementation class SingleAction */@WebServlet("/single")public class SingleAction extends HttpServlet {    private static final long serialVersionUID = 1L;    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        doPost(request, response);    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        int userid = Integer.parseInt(request.getParameter("userid"));        request.setAttribute("us", new NormalService().findUserById(userid));        request.getRequestDispatcher("update.jsp").forward(request, response);    }}

2.5.5全查

package com.test.action;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.test.services.NormalService;/** * Servlet implementation class InitAction */@WebServlet("/init")public class InitAction extends HttpServlet {    private static final long serialVersionUID = 1L;    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        doPost(request, response);    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        request.setAttribute("pb", new NormalService().findAll());        request.getRequestDispatcher("index.jsp").forward(request, response);    }}

3.JSP

3.1初始界面index

<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><!DOCTYPE html><html>    <head>        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">        <title>JSP Page</title>    </head>    <body>        <table>            <tr>                <td>用户编号</td>                <td>用户姓名</td>                <td>用户生日</td>                <td>修改用户</td>                <td>删除用户</td>            </tr>            <c:forEach items="${pb }" var="us">            <tr>                <td>${us.userid }</td>                <td>${us.username }</td>                <td>${us.birthday }</td>                <td><a href="single?userid=${us.userid }">修改用户</a></td>                <td><a href="delete?userid=${us.userid }">删除用户</a></td>            </tr>            </c:forEach>        </table>    </body></html>

3.2新增页面save.jsp

<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><!DOCTYPE html><html>    <head>        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">        <title>JSP Page</title>    </head>    <body>        <form action="save" method="post">            姓名：<input type="text" name="username" id="username" value="" />            生日：<input type="text" name="birthday" value=""/>            <button>提交</button>        </form>    </body></html>

3.3修改页面update.jsp

<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><!DOCTYPE html><html>    <head>        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">        <title>JSP Page</title>    </head>    <body>        <form action="update" method="post">            <input type="hidden" name="userid" id="userid" value="${us.userid }" />            姓名：<input type="text" name="username" id="username" value="${us.username }" />            生日：<input type="text" name="birthday" value="${us.birthday }"/>            <button>提交</button>        </form>    </body></html>