• JSP 06

    <%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页面</title>
<style type="text/css">
    td{
        border: 1px solid;
    }
    #div1{
        color: red;
    }
</style>
</head>
<body>
<div>
    <form action="FindUserByIdTest">
        姓名：
        <input type="text" id="username" name="username">
        年龄：
        <input type="text" id="userage" name="userage">
        性别：
        <input type="text" id="usergender" name="usergender">
        <input type="submit" value="查询">&nbsp;&nbsp;&nbsp;&nbsp;
        <a href="add.jsp" >添加用户信息</a>
        <a href="FindAllUserTest" >查询所有用户</a>    
    </form>    
</div>
<div>
    <form action="UpdateUserTest">
        编号：
        <input type="text" id="userid" name="userid">
        姓名：
        <input type="text" id="username" name="username">
        年龄：
        <input type="text" id="userage" name="userage">
        性别：
        <input type="text" id="usergender" name="usergender">
        Email：
        <input type="email" id="useremail" name="useremail">
        籍贯：
        <input type="text" id="useraddress" name="useraddress">
        <input type="submit" value="更改">&nbsp;&nbsp;&nbsp;&nbsp;    
    </form>
</div>
<div>
<table>
     <tr>     
           <td>${sessionScope.oneuser.id}</td>
           <td>${sessionScope.oneuser.name}</td>
           <td>${sessionScope.oneuser.age}</td>
           <td>${sessionScope.oneuser.gender}</td>
           <td>${sessionScope.oneuser.email}</td>
           <td>${sessionScope.oneuser.address}</td> 
     </tr>
</table>
    <table>
        <tr>
            <td>序号</td>
            <td>编号</td>
            <td>姓名</td>
            <td>年龄</td>
            <td>性别</td>
            <td>Email</td>
            <td>籍贯</td>
        </tr>
        <c:forEach items="${sessionScope.user}" var="u" varStatus="s">
            <tr>
                <td>${s.count}</td>
                <td>${u.id}</td>
                <td>${u.name}</td>
                <td>${u.age}</td>
                <td>${u.gender}</td>
                <td>${u.email}</td>
                <td>${u.address}</td> 
            </tr>

        </c:forEach>
    </table>
</div>
<div>
    <form action="DeleteUserTest">
        输入要删除用户的编号：
        <input type="number" name="userid">
        <input type="submit" value="删除">
    </form>
</div>

    <div id="div1"><%=request.getSession().getAttribute("tsxx")==null?"":request.getSession().getAttribute("tsxx")%></div>
    <%request.getSession().removeAttribute("tsxx");
    request.getSession().removeAttribute("user");
    request.getSession().removeAttribute("oneuser");%>
</body>
</html>
    <%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
    <form action="${pageContext.request.contextPath}/JdbcInsertTest" method="post">
        姓名：<br>
        <input type="text" id="username" name="username"><br>
        年龄：<br>
        <input type="text" id="userage" name="userage"><br>
        性别：<br>
        <input type="text" id="usergender" name="usergender"><br>
        Email：<br>
        <input type="text" id="useremail" name="useremail"><br>
        籍贯：<br>
        <input type="text" id="useraddress" name="useraddress"><br>
        <input type="submit" value="提交">
    </form>
    
</body>
</html>
    package Dao;
import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import Utils.JDBCUtils;
import domain.User;
public class UserDao {
    
    private JdbcTemplate template=new JdbcTemplate(JDBCUtils.getDataSource());
    //定义增删改查方法
    //增
    public void addUser(User user) {
        System.setProperty("file.encoding", "UTF-8");
        String sql="insert into User value (null,?,?,?,?,?)";
        template.update(sql,user.getName(),user.getAge(),user.getGender(),user.getEmail(),user.getAddress());        
    }
    //删
    public void deleteUser(int id) {
        System.setProperty("file.encoding", "UTF-8");
        String sql="delete from User where id=?";
        template.update(sql, id);
        }
    //改
    public void updateUser(User user) {
        System.setProperty("file.encoding", "UTF-8");
        String sql="update User set name = ?,age = ? ,gender = ? ,email = ?, address = ? where id = ?";
        template.update(sql,user.getName(),user.getAge(),user.getGender(),user.getEmail(),user.getAddress(),user.getId());
        
    }
    //查
    public User queryUser(User user) {
        System.setProperty("file.encoding", "UTF-8");
        try {
            String sql="select * from User where name=? and age=? and gender=?";
            User returnuser = template.queryForObject(sql,new BeanPropertyRowMapper<User>(User.class) ,user.getName(),user.getAge(),user.getGender());
            return returnuser;
        }catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return null;
        }
        
    }
    //查所有
    public List<User> queryAllUser() {
        System.setProperty("file.encoding", "UTF-8");
        try {
            String sql="select * from User";
            List<User> returnusers = template.query(sql, new BeanPropertyRowMapper<User>(User.class));
            return returnusers;
        }catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
            return null;
        }
    }
}
    package domain;

public class User {
    private int id;
    private String name;
    private int age;
    private String gender;
    private String email;
    private String address;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getGender() {
        return gender;
    }
    public void setGender(String gender) {
        this.gender = gender;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }

    
}
    package Utils;
import java.io.IOException;
import java.io.InputStream;
import java.security.spec.DSAGenParameterSpec;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class JDBCUtils {
    private static DataSource ds;
    static {
        Properties pro=new Properties();
        InputStream rc = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
        try {
            pro.load(rc);
            ds=DruidDataSourceFactory.createDataSource(pro);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public static DataSource getDataSource() {
        return ds;
    }
    public Connection getConnection() throws SQLException {
        return ds.getConnection();
    }
}
    driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydb
username=root
password=root
initialSize=5
maxActive=10
maxWait=3000
    package servlet;

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 Dao.UserDao;

/**
 * Servlet implementation class DeleteUserTest
 */
@WebServlet("/DeleteUserTest")
public class DeleteUserTest extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DeleteUserTest() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        int id = Integer.parseInt(request.getParameter("userid"));
        UserDao dao = new UserDao();
        dao.deleteUser(id);
        request.getSession().setAttribute("tsxx", "删除成功");
        request.getRequestDispatcher("/zhuye.jsp").forward(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
    package servlet;

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

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 Dao.UserDao;
import domain.User;

/**
 * Servlet implementation class FindAllUserTest
 */
@WebServlet("/FindAllUserTest")
public class FindAllUserTest extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public FindAllUserTest() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        UserDao dao = new UserDao();
        List<User> users = dao.queryAllUser();
        request.getSession().setAttribute("user", users);
        request.getRequestDispatcher("/zhuye.jsp").forward(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
    package servlet;

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 Dao.UserDao;
import domain.User;
import sun.misc.Perf.GetPerfAction;

/**
 * Servlet implementation class FindUserByIdTest
 */
@WebServlet("/FindUserByIdTest")
public class FindUserByIdTest extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public FindUserByIdTest() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("username");
        int age = Integer.parseInt(request.getParameter("userage"));
        String gender = request.getParameter("usergender");
        User user = new User();
        user.setName(name);
        user.setAge(age);
        user.setGender(gender);
        UserDao dao = new UserDao();
        User rtuser = dao.queryUser(user);
        request.getSession().setAttribute("oneuser", rtuser);
        request.getRequestDispatcher("/zhuye.jsp").forward(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
    package servlet;

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 Dao.UserDao;
import domain.User;

/**
 * Servlet implementation class JdbcInsertTest
 */
@WebServlet("/JdbcInsertTest")
public class JdbcInsertTest extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public JdbcInsertTest() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("username");
        int age = Integer.parseInt(request.getParameter("userage"));
        String gender = request.getParameter("usergender");
        String email = request.getParameter("useremail");
        String address = request.getParameter("useraddress");
        User user = new User();
        user.setName(name);
        user.setAge(age);
        user.setGender(gender);
        user.setEmail(email);
        user.setAddress(address);
        UserDao dao = new UserDao();
        dao.addUser(user);
        request.getSession().setAttribute("tsxx", "添加成功");
        request.getRequestDispatcher("/zhuye.jsp").forward(request, response);
        
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
    package servlet;

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 Dao.UserDao;
import domain.User;

/**
 * Servlet implementation class UpdateUserTest
 */
@WebServlet("/UpdateUserTest")
public class UpdateUserTest extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public UpdateUserTest() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");
        int id = Integer.parseInt(request.getParameter("userid"));
        String name = request.getParameter("username");
        int age = Integer.parseInt(request.getParameter("userage"));
        String gender = request.getParameter("usergender");
        String email = request.getParameter("useremail");
        String address = request.getParameter("useraddress");
        User user = new User();
        user.setId(id);
        user.setName(name);
        user.setAge(age);
        user.setGender(gender);
        user.setEmail(email);
        user.setAddress(address);
        UserDao dao = new UserDao();
        dao.updateUser(user);
        request.getSession().setAttribute("tsxx", "修改成功");
        request.getRequestDispatcher("/zhuye.jsp").forward(request, response);
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

    导入jar包：

     
  • 相关阅读:
    Sectong日志分析
    风暴中心
    安全趋势：
    Mysql table ful
    linux service命令常见使用方法
    client denied by server configuration
    Ubuntu配置apache
    O2O助汪峰成功逆袭，汪峰最终上头条了
    Android切图注意事项
    2014/08/23——OJ及相关站点打开速度非常慢，训练计划login直接error！
  • 原文地址：https://www.cnblogs.com/yanzhen108/p/12737964.html
Copyright © 2020-2023  润新知