【JSP CRUD示例】我们可以在JSP中轻松创建CRUD示例。在这里, 我们将DAO文件用于数据库, 将JSTL用于遍历记录。
下载jstl.jar和mysql-connector.jar
下载jstl1.2.jar文件
下载mysql-connector.jar
下载SQL文件以导入MySQL
下载SQL文件
下载专案
在JSP中下载CRUD项目
CRUD示例 Eclipse中的目录结构

文章图片
index.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> JSP CRUD Example< /title> < /head> < body> < h1> JSP CRUD Example< /h1> < a href="http://www.srcmini.com/adduserform.jsp"> Add User< /a> < a href="http://www.srcmini.com/viewusers.jsp"> View Users< /a> < /body> < /html>

adduserform.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> Add User Form< /title> < /head> < body> < jsp:include page="userform.html"> < /jsp:include> < /body> < /html>

userform.html

< a href="http://www.srcmini.com/viewusers.jsp"> View All Records< /a> < br/> < h1> Add New User< /h1> < form action="adduser.jsp" method="post"> < table> < tr> < td> Name:< /td> < td> < input type="text" name="name"/> < /td> < /tr> < tr> < td> Password:< /td> < td> < input type="password" name="password"/> < /td> < /tr> < tr> < td> Email:< /td> < td> < input type="email" name="email"/> < /td> < /tr> < tr> < td> Sex:< /td> < td> < input type="radio" name="sex" value="http://www.srcmini.com/male"/> Male < input type="radio" name="sex" value="http://www.srcmini.com/female"/> Female < /td> < /tr> < tr> < td> Country:< /td> < td> < select name="country" style="width:155px"> < option> India< /option> < option> Pakistan< /option> < option> Afghanistan< /option> < option> Berma< /option> < option> Other< /option> < /select> < /td> < /tr> < tr> < td colspan="2"> < input type="submit" value="http://www.srcmini.com/Add User"/> < /td> < /tr> < /table> < /form>

adduser.jsp

< %@page import="com.srcmini.dao.UserDao"%> < jsp:useBean id="u" class="com.srcmini.bean.User"> < /jsp:useBean> < jsp:setProperty property="*" name="u"/> < % int i=UserDao.save(u); if(i> 0){ response.sendRedirect("adduser-success.jsp"); }else{ response.sendRedirect("adduser-error.jsp"); } %>

User.java

package com.srcmini.bean; public class User { private int id; private String name, password, email, sex, country; //generate getters and setters }

UserDao.java

package com.srcmini.dao; import java.sql.*; import java.util.ArrayList; import java.util.List; import com.srcmini.bean.User; public class UserDao {public static Connection getConnection(){ Connection con=null; try{ Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "", ""); }catch(Exception e){System.out.println(e); } return con; } public static int save(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement( "insert into register(name, password, email, sex, country) values(?, ?, ?, ?, ?)"); ps.setString(1, u.getName()); ps.setString(2, u.getPassword()); ps.setString(3, u.getEmail()); ps.setString(4, u.getSex()); ps.setString(5, u.getCountry()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e); } return status; } public static int update(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement( "update register set name=?, password=?, email=?, sex=?, country=? where id=?"); ps.setString(1, u.getName()); ps.setString(2, u.getPassword()); ps.setString(3, u.getEmail()); ps.setString(4, u.getSex()); ps.setString(5, u.getCountry()); ps.setInt(6, u.getId()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e); } return status; } public static int delete(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement("delete from register where id=?"); ps.setInt(1, u.getId()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e); } return status; } public static List< User> getAllRecords(){ List< User> list=new ArrayList< User> (); try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement("select * from register"); ResultSet rs=ps.executeQuery(); while(rs.next()){ User u=new User(); u.setId(rs.getInt("id")); u.setName(rs.getString("name")); u.setPassword(rs.getString("password")); u.setEmail(rs.getString("email")); u.setSex(rs.getString("sex")); u.setCountry(rs.getString("country")); list.add(u); } }catch(Exception e){System.out.println(e); } return list; } public static User getRecordById(int id){ User u=null; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement("select * from register where id=?"); ps.setInt(1, id); ResultSet rs=ps.executeQuery(); while(rs.next()){ u=new User(); u.setId(rs.getInt("id")); u.setName(rs.getString("name")); u.setPassword(rs.getString("password")); u.setEmail(rs.getString("email")); u.setSex(rs.getString("sex")); u.setCountry(rs.getString("country")); } }catch(Exception e){System.out.println(e); } return u; } }

adduser-success.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> Add User Success< /title> < /head> < body> < p> Record successfully saved!< /p> < jsp:include page="userform.html"> < /jsp:include> < /body> < /html>

adduser-error.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> Add User Error< /title> < /head> < body> < p> Sorry, an error occurred!< /p> < jsp:include page="userform.html"> < /jsp:include> < /body> < /html>

viewusers.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> View Users< /title> < /head> < body> < %@page import="com.srcmini.dao.UserDao, com.srcmini.bean.*, java.util.*"%> < %@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> < h1> Users List< /h1> < % List< User> list=UserDao.getAllRecords(); request.setAttribute("list", list); %> < table border="1" width="90%"> < tr> < th> Id< /th> < th> Name< /th> < th> Password< /th> < th> Email< /th> < th> Sex< /th> < th> Country< /th> < th> Edit< /th> < th> Delete< /th> < /tr> < c:forEach items="${list}" var="u"> < tr> < td> ${u.getId()}< /td> < td> ${u.getName()}< /td> < td> ${u.getPassword()}< /td> < td> ${u.getEmail()}< /td> < td> ${u.getSex()}< /td> < td> ${u.getCountry()}< /td> < td> < a href="http://www.srcmini.com/editform.jsp?id=${u.getId()}"> Edit< /a> < /td> < td> < a href="http://www.srcmini.com/deleteuser.jsp?id=${u.getId()}"> Delete< /a> < /td> < /tr> < /c:forEach> < /table> < br/> < a href="http://www.srcmini.com/adduserform.jsp"> Add New User< /a> < /body> < /html>

editform.jsp

< !DOCTYPE html> < html> < head> < meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> < title> Edit Form< /title> < /head> < body> < %@page import="com.srcmini.dao.UserDao, com.srcmini.bean.User"%> < % String id=request.getParameter("id"); User u=UserDao.getRecordById(Integer.parseInt(id)); %> < h1> Edit Form< /h1> < form action="edituser.jsp" method="post"> < input type="hidden" name="id" value="http://www.srcmini.com/< %=u.getId() %>"/> < table> < tr> < td> Name:< /td> < td> < input type="text" name="name" value="http://www.srcmini.com/< %= u.getName()%>"/> < /td> < /tr> < tr> < td> Password:< /td> < td> < input type="password" name="password" value="http://www.srcmini.com/< %= u.getPassword()%>"/> < /td> < /tr> < tr> < td> Email:< /td> < td> < input type="email" name="email" value="http://www.srcmini.com/< %= u.getEmail()%>"/> < /td> < /tr> < tr> < td> Sex:< /td> < td> < input type="radio" name="sex" value="http://www.srcmini.com/male"/> Male < input type="radio" name="sex" value="http://www.srcmini.com/female"/> Female < /td> < /tr> < tr> < td> Country:< /td> < td> < select name="country"> < option> India< /option> < option> Pakistan< /option> < option> Afghanistan< /option> < option> Berma< /option> < option> Other< /option> < /select> < /td> < /tr> < tr> < td colspan="2"> < input type="submit" value="http://www.srcmini.com/Edit User"/> < /td> < /tr> < /table> < /form> < /body> < /html>

edituser.jsp

< %@page import="com.srcmini.dao.UserDao"%> < jsp:useBean id="u" class="com.srcmini.bean.User"> < /jsp:useBean> < jsp:setProperty property="*" name="u"/> < % int i=UserDao.update(u); response.sendRedirect("viewusers.jsp"); %>

deleteuser.jsp

< %@page import="com.srcmini.dao.UserDao"%> < jsp:useBean id="u" class="com.srcmini.bean.User"> < /jsp:useBean> < jsp:setProperty property="*" name="u"/> < % UserDao.delete(u); response.sendRedirect("viewusers.jsp"); %>

下载专案
在JSP中下载CRUD项目
输出量

文章图片

文章图片

文章图片

文章图片

文章图片

文章图片

文章图片

推荐阅读

• 

  跑步是脚掌落地还是脚跟落地
• 

  佳能70d可以用大疆稳定器吗 佳能70d可以用wlan
• 

  危言危行什么意思 词语危言危行什么意思
• 

  明明可以靠脸吃饭 偏偏要靠才华是什么意思
• 

  关于生活
• 

  尼康相机单反价格 尼康最新最贵单反相机
• 

  免费c语言程序网站，免费的计算机C语言和网路技术教程的网站
• 

  怎么做运动能快速减肥 怎么做运动能快速减肥呢
• 

  战地5A测试玩体验心得分享 战地5A测画面如何
• 

  2021年试验检测考试报考时间 试验检测工程师考试
• 

  proe 曲面分析
• 

  DNF为什么白送的树枝套高达4E金币,权倾天下才3.8E,难道权倾天下比树枝套还丑吗？
• 

  豌豆荚手机版
• 

  玛吉斯轮胎花纹怎么看型号 玛吉斯轮胎花纹怎么看
• 

  左边肾疼是肾虚吗
• 

  胰腺癌|警惕4个症状，追踪“癌中之王”
• 

  极简笔记源码分析
• 

  由《猎场》想起的猎头二三事
• 

  溶脂针和瘦脸针有哪些区别 溶脂针瘦脸
• 

  婆媳关系大过招必经2阶段 学会相处之道快速磨合

• JSP中的自定义标签
• JSP定制标记中的属性
• JSP会话隐式对象
• JSP响应隐式对象
• JSP请求隐式对象
• JSP pageContext隐式对象
• JSP 页面隐式对象（）
• JSP教程介绍
• JSP Taglib指令