Github地址：点击打开Github地址
小组成员：熊圣琦、彭荟铭、郑天越
1.数据库连接
private Connection connection = null;
private PreparedStatement preparedStatement = null;
private ResultSet resultSet = null;
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/javaee?serverTimezone=UTC&&characterEncoding=utf8&useSSL=true";
static final String USER = "root";
static final String PASS = "123";
public DataBase(){
try {
Class.forName(JDBC_DRIVER);
// 打开链接
System.out.println("connecting...");
connection = DriverManager.getConnection(DB_URL,USER,PASS);
if(!connection.isClosed())
System.out.println("Succeeded connecting to the Database!");
} catch(Exception e) {
e.printStackTrace();
}
}
数据库属性
2.建立一个news实体类
public class News { int newsID; String newstitle; String newsWriter; String newsTime; String newsCon; Date newsDate; //ID public int getNewsID(){ return newsID; } public void setNewsID(int newsID){ this.newsID = newsID; } //news public String getNewsTitle(){ return newstitle; } public void setNewsTitle(String newstitle){ this.newstitle = newstitle; } //作者 public String getNewsWriter(){ return newsWriter; } public void setNewsWriter(String newsWriter){ this.newsWriter = newsWriter; } //类型 public String getNewsCon(){ return newsCon; } public void setNewsCon(String newsCon){ this.newsCon = newsCon; } //时间 public Date getNewsDate(){ return newsDate; } public void setNewsDate(Date newsDate){ this.newsDate = newsDate; } }
3.登陆界面
登陆源代码：
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //response.setContentType("text/html; charset=UTF-8"); //request.setCharacterEncoding("UTF-8"); PrintWriter out = response.getWriter(); //获得输出流 String name = request.getParameter("name"); String password = URLEncoder.encode(request.getParameter("password"),"utf-8");//password转码 DataBase db = new DataBase(); if (db.login(name, password)) { Object o = request.getSession().getAttribute("onLine"); String success = "<br> 用户名： " + name + "<br> 密码：" + password + " <br> 登录成功 " + " <br> 当前在线人数： " + o; Log_Cookie(name, password, response);//Cookie System.out.println(name); System.out.println(password); System.out.println(o); out.println(success); out.println(); request.getRequestDispatcher("/show.html").forward(request,response);//跳转至新闻管理页面 } else { System.out.println(name); System.out.println(password); String fail = "<script type=‘text/javascript‘>" + "alert(‘用户名或密码错误！‘);" + "location.href=‘login.html‘;</script>"; out.println(fail); } db.Clocec(); out.close(); }
查询数据库账号密码
public boolean login(String name,String psw) throws UnsupportedEncodingException { System.out.println("\n\n=======================HANDLING LOGIN\n\n"); String select = "SELECT * FROM uname_psw WHERE uname = ? AND psw= ? "; System.out.println(select); boolean bool = false; try { preparedStatement = connection.prepareStatement(select); preparedStatement.setString(1,name); preparedStatement.setString(2,psw); resultSet = preparedStatement.executeQuery(); if (resultSet.next()){ bool = true; System.out.println("\n\nUSER EXISTS\n\n"); } } catch (SQLException throwables) { throwables.printStackTrace(); } return bool; }
4.新闻显示界面
左侧下拉框代码
<div class="left-menu"> <ul id="menu"> <li class="menu-list"> <a style="cursor:pointer" class="firsta"><i class="glyph-icon xlcd"></i>首页<s class="sz"></s></a> <ul> <li><a href="swpu.html" target="menuFrame"><i class="glyph-icon icon-chevron-right1"></i>学校信息</a></li> <li><a href="ShowNewsServlet" target="menuFrame"><i class="glyph-icon icon-chevron-right2"></i>新闻管理</a></li> </ul> </li> </ul> </div>
show.js代码如下
样式是直接从网上找的，然后对其中进行了部分修改，改为目前的页面，首页为西南石油大学的介绍。
<table>
<tr class="tb_title">
<td width="5%">ID</td>
<td width="30%">news</td>
<td width="13%">作者</td>
<td width="12%">类型</td>
<td width="18%">时间</td>
<td width="18%">操作</td>
</tr>
<c:forEach var="news" items = "${lstNews}">
<tr>
<td width="5%">${news.getNewsID()}</td>
<td width="30%">${news.getNewsTitle()}</td>
<td width="13%">${news.getNewsWriter()}</td>
<td width="12%">${news.getNewsCon()}</td>
<td width="18%">${news.getNewsDate()}</td>
<td width="18%">
<a href="EditNewsServlet?newsID=${news.newsID}" ><input class="bj_btn" type="button" value="编辑" /></a>
<a href="ViewNewsServlet?newsID=${news.newsID}" ><input class="sj_btn" type="button" value="查看" /></a>
<a href="DeleteNewsServlet?newsID=${news.newsID}" ><input class="del_btn" type="button" value="删除" /></a>
</td>
</tr>
</c:forEach>
</table>
同时需要用到jstl和standard的jar包
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
获取nwes表内容
public List<News> QueryNews() throws SQLException {
String sql="select * from News";
ResultSet rs=DataBase.executeQuery(sql);
List<News> lstNews=new ArrayList<>();
while (rs.next()){
News news=new News();
news.setNewsID(rs.getInt("newsID"));
news.setNewsTitle(rs.getString("newsTitle"));
news.setNewsWriter(rs.getString("newsWriter"));
news.setNewsCon(rs.getString("newsCon"));
news.setNewsDate(rs.getDate("newsDate"));
lstNews.add(news);
}
return lstNews;
}
新闻管理页面的调用
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
NewsService newsService=new NewsService();
try {
List<News> lstNews=newsService.QueryNews();
for(News n:lstNews){
System.out.print(n.getNewsCon());
}
request.setAttribute("lstNews",lstNews);
request.getRequestDispatcher("show.jsp").forward(request,response);
} catch (SQLException e) {
e.printStackTrace();
}
}