使用idea開發(fā)javaWeb應(yīng)用程序的思路(實(shí)現(xiàn)用戶的增刪改查)
在2.7 節(jié)基礎(chǔ)上，這一節(jié)實(shí)現(xiàn)了用戶的增刪改查操作。完整工程代碼：鏈接: https://pan.baidu.com/s/1zSGMvSQa-ihwEN5pP4vW6w 提取碼: dpw8
工程目錄結(jié)構(gòu)如下：
在webapp下新建目錄user，用于存放用戶相關(guān)的頁面。添加和修改使用的是同一個(gè)頁面，通過url中的參數(shù)控制是否是修改操作。后臺(tái)通過是否傳遞了id進(jìn)行判斷新增還是修改。新建：add.html，代碼如下：
<!DOCTYPE html><html lang='en'><head> <meta charset='UTF-8'> <title>登錄頁面</title> <link rel='stylesheet' type='text/css' href='http://www.lshqa.cn/css/my.css' rel='external nofollow' rel='external nofollow' > <script type='text/javascript' src='http://www.lshqa.cn/js/my.js'></script></head><body><div > <div > <h3 style='margin-bottom:0;'>歡迎進(jìn)入我的網(wǎng)站</h3> </hr> <p> 天將降大任于斯人也，必先苦其心志，勞其筋骨，餓其體膚，空乏其身，行拂亂其所為，所以動(dòng)心忍性，曾益其所不能。——孟子 </p> </div> <div > <h3 style='margin-bottom:0;'>添加用戶</h3> <form action='addUser' method='post'> <input type='hidden' name='id' /> <p>登錄賬號: <input type='text' name='uname' /></p> <p>真實(shí)姓名: <input type='text' name='realName' /></p> <p>選擇性別: <select name='sex' style='width:170px'> <option value ='男'>男</option> <option value ='女'>女</option> </select></p> <p>登錄密碼: <input type='password' name='pwd' /></p> <p>確認(rèn)密碼: <input type='password' name='pwdRepeat' /></p> <input type='button' value='提交' onclick='submitAddUser()'/> </form> </div></div><script type='text/javascript'>//檢查輸入是否為非空function submitAddUser(){ var uname = document.getElementById('uname').value;//獲取輸入的用戶名的值 var pwd = document.getElementById('pwd').value;//獲取輸入的密碼值 var pwdRepeat = document.getElementById('pwdRepeat').value;//獲取輸入確認(rèn)密碼值 var realName = document.getElementById('realName').value;//獲取輸入的姓名值 var sex = document.getElementById('sex').value;//獲取輸入的性別值 if(uname == '' || pwd == '' || pwdRepeat == '' || realName == '' || sex == '' ){ alert('請將信息填寫完整后再提交。'); return; } if( pwd != pwdRepeat){ alert('兩次密碼輸入不一致，請重新輸入。'); } document.getElementById('userAddForm').submit(); //輸入不為空則跳轉(zhuǎn)到主頁面}//從url中獲取參數(shù)function getQueryVariable(variable){ var query = window.location.search.substring(1); console.log(query); var vars = query.split('&'); for (var i=0;i<vars.length;i++) { var pair = vars[i].split('='); if(pair[0] == variable){return decodeURI(pair[1]);} } return(false);}//判斷參數(shù)是否為true，不為true則彈窗提示密碼錯(cuò)誤。var bool = getQueryVariable('success');var operation = getQueryVariable('operation');if(bool == 'false' && operation=='addUser'){ alert('操作失敗。');}else if(bool == 'true' && operation=='addUser'){ alert('操作成功。');}showOld();//從url中獲取參數(shù)，回顯function showOld(){ var uname = getQueryVariable('uname'); var realName = getQueryVariable('realName'); var id = getQueryVariable('id'); var sex = getQueryVariable('sex'); var pwd = getQueryVariable('pwd'); if(id != '' && id != null){ document.getElementById('uname').value=uname; document.getElementById('pwd').value=pwd; document.getElementById('pwdRepeat').value = pwd; document.getElementById('realName').value = realName; document.getElementById('id').value = id; if(sex == '男'){ document.getElementById('option_m').selected = true; }else{ document.getElementById('option_w').selected = true; } }}</script></body></html>2、查詢用戶頁面
在user目錄下新建list.jsp，代碼如下：
<%@page import='java.util.ArrayList'%><%@page import='com.my.site.UserEntity'%><%@ page language='java' contentType='text/html; charset=UTF-8'pageEncoding='UTF-8'%><!DOCTYPE html><html><head> <title>我的網(wǎng)站</title> <meta charset='utf-8'> <link rel='stylesheet' type='text/css' href='http://www.lshqa.cn/css/my.css' rel='external nofollow' rel='external nofollow' ></head><body><!-- jsp 頁面可以內(nèi)嵌 java代碼--><% ArrayList<UserEntity> all = ( ArrayList<UserEntity>)session.getAttribute('all');%><div > <div > <h3 style='margin-bottom:0;'>用戶查詢</h3> </hr> <p> 天將降大任于斯人也，必先苦其心志，勞其筋骨，餓其體膚，空乏其身，行拂亂其所為，所以動(dòng)心忍性，曾益其所不能。——孟子 </p> </div> <div > <table border='1' > <tr> <td>編號</td> <td>用戶名</td> <td>密碼</td> <td>真實(shí)姓名</td> <td>性別</td> <td>注冊時(shí)間</td> <td>操作</td> </tr> <% for(UserEntity user:all) {%> <tr> <td ><%=user.getId() %></td> <td><%=user.getUname() %></td> <td><%=user.getPwd() %></td> <td><%= user.getRealName() %></td> <td><%= user.getSex() %></td> <td><%= user.getAdd_time() %></td> <td><a href='http://www.lshqa.cn/bcjs/del?id=<%=user.getId()%> ' rel='external nofollow' >刪除</a> <a href='http://www.lshqa.cn/bcjs/add.html?id=<%=user.getId()%>&uname=<%=user.getUname()%>&pwd=<%=user.getPwd()%>&realName=<%=user.getRealName()%>&sex=<%=user.getSex()%>' rel='external nofollow' >修改</a> </td> </tr> <%} %> </table> <p> 當(dāng)前時(shí)間: <%= (new java.util.Date()).toLocaleString()%> </p> </div></div><script type='text/javascript'>//點(diǎn)擊按鈕跳轉(zhuǎn)到登錄頁面function toAddUser(){ window.location.href='http://www.lshqa.cn/bcjs/user/add.html' rel='external nofollow' ;}function toSearchUser(){ window.location.href='http://www.lshqa.cn/bcjs/user/list' rel='external nofollow' ;}</script></body></html>3、編寫后臺(tái)邏輯-添加/修改
新建：UserAdd類
package com.my.site;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;@WebServlet('/user/addUser')public class UserAdd extends HttpServlet { /** req 攜帶了請求相關(guān)信息，包括各種配置和請求參數(shù)； resp：攜帶返回相關(guān)信息 */ @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //從請求對象中獲取請求參數(shù)：是從前端 usr/add.html頁面的 userAddForm 表單提交過來的 String uname = new String(req.getParameter('uname').getBytes('ISO-8859-1'),'utf-8'); String pwd = new String(req.getParameter('pwd').getBytes('ISO-8859-1'),'utf-8'); String realName = new String(req.getParameter('realName').getBytes('ISO-8859-1'),'utf-8'); String sex = new String(req.getParameter('sex').getBytes('ISO-8859-1'),'utf-8'); String pwdRepeat = new String(req.getParameter('pwdRepeat').getBytes('ISO-8859-1'),'utf-8'); String id_str = req.getParameter('id'); boolean bool = false; //如果有id，就執(zhí)行更新操作，沒有id則執(zhí)行新增操作 if(null != id_str && !''.equals(id_str)){ int id = Integer.parseInt(req.getParameter('id')); bool = MySqlOperator.updateUser(id,uname, pwd, realName, sex); }else { bool = MySqlOperator.addUser(uname, pwd, realName, sex); } resp.setContentType('text/html;charset=UTF-8'); if(bool){ //跳轉(zhuǎn)到主頁面，并攜帶請求體，返回體對象。 resp.sendRedirect('add.html?operation=addUser&success=true'); }else{ //校驗(yàn)失敗則跳轉(zhuǎn)到登錄頁面 resp.sendRedirect('add.html?operation=addUser&success=false'); } } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); }}4、編寫后臺(tái)邏輯-查詢
新建 UserList 類
package com.my.site;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 javax.servlet.http.HttpSession;import java.io.IOException;import java.util.List;@WebServlet('/user/list')public class UserList extends HttpServlet { /** req 攜帶了請求相關(guān)信息，包括各種配置和請求參數(shù)； resp：攜帶返回相關(guān)信息 */ @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { List<UserEntity> all = MySqlOperator.listAllUser(); HttpSession session = req.getSession(); session.setAttribute('all',all); resp.setContentType('text/html;charset=UTF-8'); resp.sendRedirect('list.jsp'); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); }}5、編寫后臺(tái)邏輯-刪除
新建UserDel
package com.my.site;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;@WebServlet('/user/del')public class UserDel extends HttpServlet { /** req 攜帶了請求相關(guān)信息，包括各種配置和請求參數(shù)； resp：攜帶返回相關(guān)信息 */ @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //從請求對象中獲取請求參數(shù)：是從前端 usr/add.html頁面的 userAddForm 表單提交過來的 int id = Integer.parseInt(req.getParameter('id').trim()); MySqlOperator.delUser(id); resp.setContentType('text/html;charset=UTF-8'); resp.sendRedirect('list'); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); }}6、 編寫數(shù)據(jù)庫操作
package com.my.site;import java.sql.*;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;public class MySqlOperator { private static final String MYSQL_URL = 'jdbc:mysql://localhost:3309/ztest?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC'; private static final String MYSQL_NAME = 'root'; private static final String MYSQL_PASSWORD = 'MySql@8022'; private static Connection conn = null; private static Statement stt = null; static { try { Class.forName('com.mysql.cj.jdbc.Driver'); conn = DriverManager.getConnection(MYSQL_URL,MYSQL_NAME,MYSQL_PASSWORD); stt = conn.createStatement(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } /** * 根據(jù)用戶名和密碼檢查是否合法用戶， * @param uname * @param pwd * @return */ public static boolean loginChecked(String uname,String pwd){ try { Statement stt = conn.createStatement(); String sql = 'select * from user where account=’'+uname+'’ and password = ’'+pwd+'’';//這樣寫是有sql注入漏洞的，后面會(huì)用到 System.out.println(sql); ResultSet rs = stt.executeQuery(sql); while (rs.next()){ return true; } } catch ( SQLException e) { e.printStackTrace(); } return false; } /** * 添加用戶 */ public static boolean addUser(String uname,String pwd,String realName,String sex){ Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM-dd HH:mm:sss'); String data_str = sdf.format(date); String sql = 'insert into user(account,name,password,sex,add_time) values' + ' (’'+uname+'’,’'+realName+'’,’'+pwd+'’,’'+sex+'’,’'+data_str+'’)'; System.out.println(sql); try { if(conn.isValid(2)){ initConn(); } stt.execute(sql); return true; } catch (SQLException throwable) { throwable.printStackTrace(); return false; } } /**查詢所有用戶*/ public static List<UserEntity> listAllUser(){ String sql = 'select * from user'; ResultSet rs = null; ArrayList<UserEntity> all = new ArrayList<>(); SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM-dd HH:mm:sss'); try { rs = stt.executeQuery(sql); while (rs.next()){ UserEntity user = new UserEntity(); user.setUname(rs.getString('account')); user.setPwd(rs.getString('password')); user.setRealName(rs.getString('name')); user.setSex(rs.getString('sex')); user.setAdd_time(sdf.format(rs.getDate('add_time'))); user.setId(rs.getInt('id')); all.add(user); } System.out.println(sql); System.out.println('查詢條數(shù)：'+all.size()); return all; } catch (SQLException throwable) { throwable.printStackTrace(); } return all; } /**刪除用戶*/ public static boolean delUser(int id) { String sql = 'delete from user where id='+id; try { stt.execute(sql); return true; } catch (SQLException throwable) { throwable.printStackTrace(); return false; } }/**用于 mysql 連接斷開后重連*/ public static void initConn(){ try { Class.forName('com.mysql.cj.jdbc.Driver'); conn = DriverManager.getConnection(MYSQL_URL,MYSQL_NAME,MYSQL_PASSWORD); stt = conn.createStatement(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } }/**更新用戶信息*/ public static boolean updateUser(int id, String uname, String pwd, String realName, String sex) { Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM-dd HH:mm:sss'); String data_str = sdf.format(date); String sql = 'update user set account=’'+uname+'’,password=’'+pwd+'’,name=’'+realName+'’,sex=’'+sex+'’,add_time=’'+data_str+'’ where id='+id; System.out.println(sql); try { if(conn.isValid(2)){ initConn(); } stt.execute(sql); return true; } catch (SQLException throwable) { throwable.printStackTrace(); return false; } }}7、 運(yùn)行效果
到此這篇關(guān)于使用idea開發(fā)javaWeb應(yīng)用程序的思路(實(shí)現(xiàn)用戶的增刪改查)的文章就介紹到這了,更多相關(guān)idea 開發(fā)javaweb應(yīng)用程序內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)！
相關(guān)文章：
1. CSS自定義滾動(dòng)條樣式案例詳解2. 通過工廠模式返回Spring Bean方法解析3. JSP實(shí)現(xiàn)客戶信息管理系統(tǒng)4. PHP 面向?qū)ο蟪绦蛟O(shè)計(jì)之類屬性與類常量實(shí)現(xiàn)方法分析5. Java Spring WEB應(yīng)用實(shí)例化如何實(shí)現(xiàn)6. python 批量下載bilibili視頻的gui程序7. Intellij IDEA連接Navicat數(shù)據(jù)庫的方法8. 關(guān)于Mysql-connector-java驅(qū)動(dòng)版本問題總結(jié)9. 使用css實(shí)現(xiàn)全兼容tooltip提示框10. python numpy庫np.percentile用法說明
網(wǎng)公網(wǎng)安備