21级软件工程课前测试

在开学考的三个小时内我完成了数据库中表的创建，bean包，数据库的链接，撰写新闻，浏览新闻，查询新闻以及登录进入不同的功能页面，试卷的完成度很低，在假期的时候也没有进行很好的复习，之后会对Javaweb的相关内容进行一个系统性的复习，也会将未完成的功能实现。在对这次的考试试卷进行完善的时候为使功能更加强大会对所写代码进行很大的改动。

index.jsp

<%@ page import="bean.*" %>
<%@ page import="java.util.List" %>
<%@ page import="dao.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>新闻发布平台</title>
    <style type="text/css">
        *{font-style: "微软雅黑"}

        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color: #cfecfc;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body>

<form  method="get"  action="houtai.jsp"  class="form-login">
    <h2 style="text-align: center;">新闻发布平台</h2>
    <br>
    <div style="text-align: center;">
        <tr>
            <td>职位：

                <select name="profession">
                    <option value="1">系统管理员</option>
                    <option value="2">普通用户</option>
                    <option value="3">新闻栏目管理员</option>
                    <option value="4">新闻撰稿人</option>
                </select>
            </td>
        </tr>
        <div style="text-align: center;">
        <tr><td>
            用户名:<input type="text" name="username"><br></tr>

        <tr><td>
            密码:<input pattern="[a-zA-Z0-9]{6,12}" type="password" name="password"></td> </tr>
    </div>

    <tr>
        <td colspan="2"><div align="center">
            <input type="submit" value="登录"></div></td> </tr>
    </div>
</form>
</div>
</body>
</html>

houtai.jsp

<%@ page import="java.sql.*"    contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="dao.UserDao" %>
<html>
<head>
    <title>从index获取数据</title>

</head>
<body>
<jsp:useBean id="util" class="dao.UserDao"/>
<%
    //获取前端index的登录数据
    request.setCharacterEncoding("UTF-8");//编码一定设置
    String profession=request.getParameter("profession");
    //  String username=request.getParameter("username");
    String name =request.getParameter("username");
    String mima=request.getParameter("password");//取出login.jsp的值


        switch(profession) {
            case "1":
                if(name.equals("admin")&&mima.equals("admin")){
                    response.sendRedirect("admin.jsp");break;
                }
                else {
                out.print("<script language='javaScript'> alert('密码错误');</script>");
                response.setHeader("refresh", "0;url=index.jsp");
            }

            case "2":     if(util.judgeuser(name, mima)){
                response.sendRedirect("user.jsp");break;
            }
            else {
                out.print("<script language='javaScript'> alert('密码错误');</script>");
                response.setHeader("refresh", "0;url=index.jsp");
            }
            case "3":    if(util.judgelanmu(name, mima)){
                response.sendRedirect("lanmu.jsp");break;
            }
            else {
                out.print("<script language='javaScript'> alert('密码错误');</script>");
                response.setHeader("refresh", "0;url=index.jsp");
            }
            case "4":    if(util.judgezhuangao(name, mima)){
                response.sendRedirect("zhuangao.jsp");break;
            }
            else {
                out.print("<script language='javaScript'> alert('密码错误');</script>");
                response.setHeader("refresh", "0;url=index.jsp");
            }
            
        }
%>


</body>
</html>

addgongwen.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@page import="servlet.*" %>
<html>
<head>
<meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<%
    Object message = request.getAttribute("message");
    if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
    alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">撰写新闻</h1>

    <form name="form1" action="DocServlet?method=addgongwen" method="post" onsubmit="return check()">
        <table align="center" border="1" width="1000">
            <tr>
            <tr>
                <td>标题 </td>
                <td>
                    <label>
                        <input type="text" name="title"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>关键字 </td>
                <td>
                    <label>
                        <input type="text" name="guanjian"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>栏目 </td>
                <td>
                    <label>
                        <input type="text" name="lanmu"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>拟稿人 </td>
                <td>
                    <label>
                        <input type="text" name="zhuangao"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>时间 </td>
                <td>
                    <label>
                        <input type="text" name="time"/>
                    </label>
                </td>
            </tr>
            <tr>
            <tr>
                <td>正文 </td>
                <td>
                    <label>
                        <input type="text" name="content"/>
                    </label>
                </td>
            </tr>
            <tr>
            <tr align="center">
                <td colspan="3">
                    <input type="submit" value="提交" />
                    <input type="reset" value="重置" />
                    <a href="index.jsp">返回主页</a>
                </td>
            </tr>
        </table>
    </form>
</div>
</body>
</html>
</body>
</html>

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>基本信息列表</title>
<form method="get">
</head>
<body>
<div align="center">
<h1 style="color: black;">基本信息列表</h1>
<a href="menu.jsp">返回主页</a>
<table class="tb">
<tr>
<td>标题</td>
<td>关键字</td>
<td>撰写人</td>
<td>日期</td>
<td>正文</td>
<td>评论</td>
</tr>
<!-- forEach遍历出adminBeans -->
<c:forEach items="${peoples}" var="item" varStatus="status">
<tr>
<td>
<div class="a">
<a href="Servlet?method=getbyname03&name=${item.name}">${item.name}</a>
</div>
</td>
<td>${item.idc}</td>
<td>${item.sex}</td>
<td>${item.min_zu}</td>
<td>${item.jiao_yu}</td>

</tr>
</c:forEach>
</table>
</div>
</body>
</html>

updatemima.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@page import="servlet.*" %>
<html>
<head>
<meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<%
    Object message = request.getAttribute("message");
    if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
    alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">修改个人秘密</h1>

    <form name="form1" action="DocServlet?method=updatemima" method="post" onsubmit="return check()">
        <table align="center" border="1" width="1000">
            <tr>
            <tr>
                <td>用户名 </td>
                <td>
                    <label>
                        <input type="text" name="username"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>旧密码 </td>
                <td>
                    <label>
                        <input type="text" name="guanjian"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>新密码 </td>
                <td>
                    <label>
                        <input type="text" name="lanmu"/>
                    </label>
                </td>
            </tr>
            <tr>
            <tr align="center">
                <td colspan="3">
                    <input type="submit" value="提交" />
                    <input type="reset" value="重置" />
                    <a href="index.jsp">返回主页</a>
                </td>
            </tr>
        </table>
    </form>
</div>
</body>
</html>
</body>
</html>

checkxinwen.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@page import="servlet.*" %>
<html>
<head>
<meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<%
    Object message = request.getAttribute("message");
    if(message!=null && !"".equals(message)){

%>
<script type="text/javascript">
    alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
    <h1 style="color: black;">查找新闻</h1>

    <form name="form1" action="DocServlet?method=checkxinwen" method="post" onsubmit="return check()">
        <table align="center" border="1" width="1000">
            <tr>
            <tr>
                <td>标题 </td>
                <td>
                    <label>
                        <input type="text" name="title"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>关键字 </td>
                <td>
                    <label>
                        <input type="text" name="guanjian"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>栏目 </td>
                <td>
                    <label>
                        <input type="text" name="lanmu"/>
                    </label>
                </td>
            </tr>
            <tr>
                <td>拟稿人 </td>
                <td>
                    <label>
                        <input type="text" name="zhuangao"/>
                    </label>
                </td>
            </tr>
            <tr>
            <tr align="center">
                <td colspan="3">
                    <input type="submit" value="查找" />
                    <input type="reset" value="重置" />
                    <a href="index.jsp">返回主页</a>
                </td>
            </tr>
        </table>
    </form>
</div>
</body>
</html>
</body>
</html>

package bean;

public class Xinwen {
    private int id;
    private String zhuangao;
    private String lanmu;
    private String title;
    private String guanjian;
    private String pinglun;
    private String content;
    private String time;
    private int userdelete;//0用户删除无用信息,1未删除
    private int admin;//0管理员删除新闻,1发布新闻,2修改新闻,4管理员未查看
    private String yijian;
    public void setId(int id)
    {
        this.id=id;
    }
    public int getID()
    {
        return id;
    }
    public void setTitle(String title)
    {
        this.title=title;
    }
    public String getTitle()
    {
        return title;
    }
    public void setGuanjian(String guanjian)
    {
        this.guanjian=guanjian;
    }
    public String getGuanjian()
    {
        return guanjian;
    }public void setZhuangao(String zhuangao)
    {
        this.zhuangao=zhuangao;
    }
    public String getZhuangao()
    {
        return zhuangao;
    }
    public void setLanmu(String lanmu)
    {
        this.lanmu=lanmu;
    }
    public String getLanmu()
    {
        return lanmu;
    }
    public void setPinglun(String pinglun)
    {
        this.pinglun=pinglun;
    }
    public String getPinglun()
    {
        return pinglun;
    }
    public void setContent(String content)
    {
        this.content=content;
    }
    public String getContent()
    {
        return content;
    }
    public void setTime(String time)
    {
        this.time=time;
    }
    public String getTime()
    {
        return time;
    }
    public void setUserdelete(int userdelete)
    {
        this.userdelete=userdelete;
    }
    public int getUserdelete()
    {
        return userdelete;
    }
    public void setAdmin(int admin)
    {
        this.admin=admin;
    }
    public int getAdmin()
    {
        return admin;
    }
    public void setYijian(String yijian)
    {
        this.yijian=yijian;
    }
    public String getYijian()
    {
        return yijian;
    }
    public Xinwen(String title,String guanjian,String lanmu,String zhuangao,String content,String time,int admin)
    {
        this.title=title;
        this.guanjian=guanjian;
        this.lanmu=lanmu;
        this.zhuangao=zhuangao;
        this.content=content;
        this.time=time;
        this.admin=admin;
    }
}

package bean;

public class Zhuangao {
    private String username;
    private String password;
    private String zhiwei;
    private String lanmu;
    public void setUsername(String username)
    {
        this.username=username;
    }
    public String getUsername()
    {
        return username;
    }
    public void setPassword(String password)
    {
        this.password=password;
    }
    public String getPassword()
    {
        return password;
    }
    public void setZhiwei(String zhiwei)
    {
        this.zhiwei=zhiwei;
    }
    public String getZhiwei()
    {
        return zhiwei;
    }
    public void setLanmu(String lanmu)
    {
        this.lanmu=lanmu;
    }
    public String getLanmu()
    {
        return lanmu;
    }
    public Zhuangao(String username,String password,String zhiwei,String lanmu)
    {
        this.username=username;
        this.password=password;
        this.zhiwei=zhiwei;
        this.lanmu=lanmu;
    }
}

package bean;

public class Quan {
    private String username;
    private String quan;
    public void setUsername(String username)
    {
        this.username=username;
    }
    public String getUsername()
    {
        return username;
    }
    public void setQuan(String quan)
    {
        this.quan=quan;
    }
    public String getQuan()
    {
        return quan;
    }
}

package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {    
        Statement stmt = null;//Statement 对象用于将 SQL 语句发送到数据库中。
        ResultSet rs = null;
     //1. 导入驱动jar包
     //2.注册驱动
     Class.forName("com.mysql.jdbc.Driver");/////////////////////////////////////////////////serverTimezone=GMT%2B8&useSSL=false&severTimezone=UTC&seUnicode=true&characterEncoding=UTF-8
     Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/xinwen?serverTimezone=GMT%2B8&useSSL=false&severTimezone=UTC&seUnicode=true&characterEncoding=utf-8","root","root");
       stmt=connection.createStatement();
 return connection;
 }
 
 public static void close(Connection connection ) {
      try {
        if (connection != null) {
             connection.close();
          }
     } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
    }
  }
public static void close(PreparedStatement preparedStatement ) {
      try {
         if (preparedStatement != null) {
              preparedStatement.close();
          }            
     } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
      }
  }
  public static void close(ResultSet resultSet ) {
     try {
         if (resultSet != null) {
              resultSet.close();
          }
          
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
      }
  }
}

posted @ 2023-02-13 19:40 辞楠阅读(24) 评论(0) 收藏举报

刷新页面返回顶部

cinan

21级软件工程课前测试

公告