记录学习jsp之增删改查
直接在jsp中连接数据库实现增删改查,不通过servlet操作
首先要建一张表,以留言页面为例,列名为name,email,note
再来设计一个jsp页面,新建一个message.jsp
<%@ 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 align="center"> <h2>留言</h2> <form action="messagesucceed.jsp" method="post"> <table align="center"> <tr align="right"> <td>请输入姓名:</td> <td align="left"><input type="text" name=name autofocus="autofocus"></td> </tr> <tr align="right"> <td>请输入邮箱:</td> <td align="left"><input type="text" name=email></td> </tr> <tr align="right"> <td>请输入留言:</td> <td> <textarea rows="5" cols="40" name=note></textarea></td> </tr> </table> <input type="submit" name=register value="提交" > <input type="reset" name=refill value="重填" > </form> </body> </html>
接着,建立另外一个jsp用于连接数据库,并实现增删改查的操作
<%@page import="java.sql.*"%> <%@page import="javax.sql.*"%> <%@page import="javax.naming.*"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%request.setCharacterEncoding("utf-8"); %> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>留言成功页面</title> </head> <body> <% Context ctx = null; DataSource ds = null; Statement stmt =null; ResultSet rs = null; Connection con = null; String name=request.getParameter("name").trim();//去除首尾空格 String email=request.getParameter("email").trim(); String note=request.getParameter("note").trim(); String driver="com.mysql.jdbc.Driver"; try{ ctx = new InitialContext(); Class.forName(driver); con = DriverManager.getConnection("数据库url","数据库用户名","数据库密码"); //连接数据库 stmt = con.createStatement(); if(name!=null ){ stmt.executeUpdate("insert into message values(‘"+name+"‘,‘"+ email + "‘,‘"+ note + "‘);"); //插入操作 %> 留言成功!!!<br> 三秒钟后自动转到主页面!!!<br> 如果没有跳转,请点击<a href="index.html">这里</a>!!! <span style="font-size:24px;"><meta http-equiv="refresh" content="3;URL=index.html"> </span> <% } }catch(Exception e){ out.print(e); }finally{ if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(con!=null) con.close(); } %> </body> </html>
原文:https://www.cnblogs.com/cxy171/p/12685777.html