【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项目
输出量

文章图片

文章图片

文章图片

文章图片

文章图片

文章图片

文章图片

推荐阅读

• 

  千牛工作台自动回复怎么设置 千牛工作台设置自动回复内容的操作步骤
• 

  武汉暖通公司前三名 武汉家庭供暖
• 

  预防艾滋病|前10月陕西发现并报告艾滋病病例2017人 青壮年近七成！
• 

  只是想您
• 

  刚果金之行第三天(2.24)
• 

  动感单车与健身车的区别是什么
• 

  八爪鱼的墨汁有营养吗
• 

  扭力梁是什么结构 扭力梁是什么
• 

  想学习做视频,大家推荐用什么软件好？
• 

  K.im|MegaUpload的Kim Dotcom展示了区块链文件共享平台K.im
• 

  患甲亢眼睛突出不舒服怎么办？
• 

  佳能单反相机图片大全 佳能单反图解
• 

  法院能直接判离吗 如何处理法院会判决离吗，什么情况法院会判离
• 

  机位 模拟人生4删除已经保存的视角办法一览
• 

  绿茶叶饮料可以炒奶茶吗，可以用绿茶叶煮奶茶吗
• 

  一致性检验层次分析,层次总排序一致性检验公式 CR=CR
• 

  佳能5d2和5d3画质对比 佳能5d2与5d3画质差多少
• 

  金币棋牌游戏的简单介绍
• 

  爱普生r330废墨垫饱和
• 

  感恩母亲的手抄报 感恩母亲的画报

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