JAVAWEB学习-继续增删改查-完成发布功能-04
今天接着上回的进度，今天把撰稿人发布新闻的功能弄好了，也就是增这部分,
顺便优化了一下界面，让界面更好看了一点点。
先看一下效果，代码放后边：
首先登录，进入撰稿人界面，点击撰写
然后我们把信息填进去，点发布
显示发布成功，返回
我们再换个普通用户登录，进入用户页面，可以看到我们能够浏览到之前发布的新闻
代码：
writer1.java
package Test.test1; 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 java.io.IOException; import java.io.PrintWriter; import java.sql.*; @WebServlet("/writer1") public class writer1 extends HttpServlet { private static final long serialVersionUID = 1L; Connection conn = null; Statement stmt = null; @Override public void init() throws ServletException { String dburl = "jdbc:mysql://localhost:3306/test001?useSSL=false&serverTimezone=UTC"; String username = "root"; String password = "1506583922"; try{ Class.forName("com.mysql.cj.jdbc.Driver"); conn = DriverManager.getConnection(dburl,username,password); stmt = conn.createStatement(); }catch(SQLException se){ // 处理 JDBC 错误 se.printStackTrace(); }catch(Exception e){ // 处理 Class.forName 错误 e.printStackTrace(); } } public void addnews(String title,String text,String writer,String date){ PreparedStatement preparedStatement=null; try { String sql = "INSERT INTO news_info (news_title,news_text,news_writer,news_date) values (?,?,?,?)"; preparedStatement=conn.prepareStatement(sql); preparedStatement.setString(1,title); preparedStatement.setString(2,text); preparedStatement.setString(3,writer); preparedStatement.setString(4,date); preparedStatement.executeUpdate(); //System.out.println("添加成功"); } catch (SQLException e) { e.printStackTrace(); }finally{ } } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String title =new String(request.getParameter("publish_title").getBytes("ISO8859-1"),"UTF-8"); String text = new String(request.getParameter("publish_text").getBytes("ISO8859-1"),"UTF-8"); String writer = new String(request.getParameter("publish_writer").getBytes("ISO8859-1"),"UTF-8"); String date =new String(request.getParameter("publish_date").getBytes("ISO8859-1"),"UTF-8"); addnews(title,text,writer,date); response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String message = "发布成功"; String docType = "<!DOCTYPE html> \n"; out.println(docType + "<html>\n" + "<head><title>" + message + "</title></head>\n" + "<body bgcolor=\"#f0f0f0\">\n" + "<h1 align=\"center\">" + message + "</h1>\n" + "</ul>\n"+ "<input type=\"button\" value=\"点击返回\" onclick=\"location.href='writer_publish.jsp'\" />" ); out.println("<br />"); out.println("</body></html>"); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } @Override public void destroy() { try { conn.close(); }catch (Exception e){ e.printStackTrace(); } } }
writer_publish.jsp 我把jsp的代码优化了一下，更加简洁效果更好
<%-- Created by IntelliJ IDEA. User: 23944 Date: 2023/2/26 Time: 14:20 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>撰稿页面</title> </head> <body> <form action="writer1" method="POST"> <h1>撰写并发布你的稿件</h1> <h3>新闻标题</h3><br> <input type="text" name="publish_title" size="70"><br> <h3>新闻内容</h3> <input type="text" name="publish_text" style="height: 300px;width: 500px"><br> <h3>作者</h3> <input type="text" name="publish_writer"><br> <h3>日期</h3> <input type="text" name="publish_date"><br> <input type="submit" value="发布"> </form> </body> </html>
login1.jsp
<%-- Created by IntelliJ IDEA. User: 23944 Date: 2023/2/21 Time: 16:33 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>登陆页面</title> </head> <body> <form action="login" method="POST"> <fieldset> <legend>网络新闻发布系统---请登录:</legend> 账号：<input type="text" name="put_name"><br> 密码：<input type="password" name="put_password"><br> 登录身份：<input type="radio" name="put_identity" value="普通用户">普通用户 <input type="radio" name="put_identity" value="撰稿人">撰稿人 <input type="radio" name="put_identity" value="管理员">管理员 <br> <input type="submit" value="登录"> </fieldset> </form> <fieldset> <legend>还没有账户----------请注册:</legend> <input type="submit" value="注册"onclick="location.href='register0.jsp'"> </fieldset> </body> </html>
register0.jsp
<%-- Created by IntelliJ IDEA. User: 23944 Date: 2023/2/21 Time: 16:33 To change this template use File | Settings | File Templates. --%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>注册</title> </head> <body> <form action="register" method="POST"> <fieldset> <legend>网络新闻发布系统---请注册:</legend> 账号：<input type="text" name="reg_name" maxlength="8"><br> 密码：<input type="password" name="reg_password" maxlength="50"><br> 身份：<input type="radio" size="2" name="reg_identity" value="普通用户" checked>普通用户 <input type="radio" size="2" name="reg_identity" value="撰稿人" checked>撰稿人<br> <input type="submit" value="提交" /><br> </fieldset> </form> <fieldset> <input type="button" value="返回" onclick="location.href='login1.jsp'" /> </fieldset> </body> </html>
