柚子快報激活碼778899分享：java 面試 學(xué)習(xí) 用戶登錄
柚子快報激活碼778899分享：java 面試 學(xué)習(xí) 用戶登錄
更多：Java進階核心知識集
包含：JVM，JAVA集合，網(wǎng)絡(luò)，JAVA多線程并發(fā)，JAVA基礎(chǔ)，Spring原理，微服務(wù)，Zookeeper，Kafka，RabbitMQ，Hbase，MongoDB，Cassandra，設(shè)計模式，負載均衡，數(shù)據(jù)庫，一致性哈希，JAVA算法，數(shù)據(jù)結(jié)構(gòu)，加密算法，分布式緩存等等
高效學(xué)習(xí)視頻
本文已被CODING開源項目：【一線大廠Java面試題解析+核心總結(jié)學(xué)習(xí)筆記+最新講解視頻+實戰(zhàn)項目源碼】收錄
需要這份系統(tǒng)化的資料的朋友，可以點擊這里獲取
#before{
text-align: center;
}
#head{
background: #eeeeee;height: 80px;
}
#headLink{
font-size: 20px;
}
#headWelLink{
font-size: 20px;
}
<%–頭部信息–%>
<%
User user =(User)session.getAttribute(“user”);
if(user == null){
response.sendRedirect(“l(fā)ogin.jsp”);
}else {
%>
歡迎您：<%=user.getName()%>
安全退出
<%
}
%>
<%
// 設(shè)置獲取注冊時的編碼為UTF-8
request.setCharacterEncoding(“UTF-8”);
Book book=new Book();
//獲取admin_addbook.jsp頁面提交的賬號和密碼
String bookname=request.getParameter(“bookname”);
Double price= Double.parseDouble(request.getParameter(“price”));
String author=request.getParameter(“author”);
String publish=request.getParameter(“publish”);
//獲取admin_addbook.jsp頁面提交的賬號和密碼設(shè)置到實體類User中
book.setBookname(bookname);
book.setPrice(price);
book.setAuthor(author);
book.setPublish(publish);
System.out.println(“添加的圖書信息”);
System.out.println(book);
//引入數(shù)據(jù)交互層
BookDao dao=new BookDaoImpl();
boolean flag=dao.addBook(book);
if(flag){
response.sendRedirect(“admin.jsp”);
}else{
response.sendRedirect(“error.jsp”);
}
%>
admin_do_info.jsp
<%–
Created by IntelliJ IDEA.
User: shuijianshiqing
Date: 2020/5/24
Time: 10:51
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%@ page import=“com.sjsq.po.Book” %>
<%@ page import=“com.sjsq.service.BookService” %>
<%@ page import=“com.sjsq.service.impl.BookServiceImpl” %>
<%
// 獲取絕對路徑路徑 ,開發(fā)項目一定要使用絕對路徑，不然肯定出錯
String path = request.getContextPath();
String basePath = request.getScheme() + “?/” + request.getServerName() + “:”
request.getServerPort() + path + “/”;
%>
書籍信息
<%
Book book = new Book();
String sid = request.getParameter(“bookid”);
Integer id = Integer.parseInt(sid);
BookService service = new BookServiceImpl();
book.setBookid(id);
Book bookCur = service.getBook(book);
// 控制臺打印出類的信息（日志的前身）
System.out.print(“admin_do_info.jsp的信息–>”);
System.out.println(bookCur);
session.setAttribute(“book”, bookCur);
response.sendRedirect(“admin_detail.jsp”);
%>
admin_do_updatebook.jsp
<%–
Created by IntelliJ IDEA.
User: shuijianshiqing
Date: 2020/5/21
Time: 23:45
To change this template use File | Settings | File Templates.
–%>
<%@page import=“com.sjsq.dao.impl.UserDaoImpl”%>
<%@page import=“com.sjsq.dao.UserDao”%>
<%@page import=“com.sjsq.po.User”%>
<%@ page import=“com.sjsq.po.Book” %>
<%@ page import=“com.sjsq.dao.BookDao” %>
<%@ page import=“com.sjsq.dao.impl.BookDaoImpl” %>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8”%>
處理修改圖書
<%–頭部信息–%>
<%
User user =(User)session.getAttribute(“user”);
if(user == null){
response.sendRedirect(“l(fā)ogin.jsp”);
}else {
%>
歡迎您：<%=user.getName()%>
安全退出
<%
}
%>
<%
// 設(shè)置獲取注冊時的編碼為UTF-8
request.setCharacterEncoding(“UTF-8”);
//獲取admin_addbook.jsp頁面提交的賬號和密碼
Integer bookid=Integer.parseInt(request.getParameter(“bookid”));
String bookname = request.getParameter(“bookname”);
Double price = Double.parseDouble(request.getParameter(“price”));
String author=request.getParameter(“author”);
String publish=request.getParameter(“publish”);
//引入數(shù)據(jù)交互層
BookDao dao=new BookDaoImpl();
Book book=new Book();
book = dao.getBook(bookid);
book.setBookname(bookname);
book.setPrice(price);
book.setAuthor(author);
book.setPublish(publish);
System.out.println(“修改的圖書信息”);
System.out.println(book);
boolean flag=dao.updateBook(book);
if(flag){
response.sendRedirect(“admin.jsp”);
}else{
response.sendRedirect(“error.jsp”);
}
%>
admin_update.jsp
<%@ page import=“com.sjsq.po.Book” %>
<%@ page import=“com.sjsq.dao.impl.BookDaoImpl” %>
<%@ page import=“com.sjsq.dao.BookDao” %>
<%@ page import=“com.sjsq.po.User” %><%–
Created by IntelliJ IDEA.
User: shuijianshiqing
Date: 2020/5/21
Time: 23:14
To change this template use File | Settings | File Templates.
–%>
<%@ page language=“java” contentType=“text/html; charset=UTF-8” pageEncoding=“UTF-8” %>
修改圖書
<%–頭部信息–%>
<%
User user =(User)session.getAttribute(“user”);
if(user == null){
response.sendRedirect(“l(fā)ogin.jsp”);
}
%>
修改圖書
<%
//獲取admin.jsp頁面的bookid
Integer bookid=Integer.parseInt(request.getParameter(“bookid”));
BookDao dao=new BookDaoImpl();
Book book=new Book();
book = dao.getBook(bookid);
%>
圖書名稱：
圖書價格：
圖書作者：
出版公司：
修改
重置
error.jsp
<%–
Created by IntelliJ IDEA.
User: shuijianshiqing
Date: 2020/6/10
Time: 22:28
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>
錯誤頁面
操作出錯，請回到上一個頁面！
login.jsp
<%–
Created by IntelliJ IDEA.
User: shuijianshiqing
Date: 2020/5/19
Time: 22:44
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%
// 獲取絕對路徑路徑 ,開發(fā)項目一定要使用絕對路徑，不然肯定出錯
String path = request.getContextPath();
String basePath = request.getScheme() + “?/” + request.getServerName() + “:”
request.getServerPort() + path + “/”;
%>
用戶登錄
用戶登錄
---正在美化中---
賬號： 密碼：
找回密碼
注冊
2.后端
User
package com.sjsq.po;
import java.io.Serializable;
/**
@author shuijianshiqing @date 2020/5/19 22:19 用戶的實體類
*/
public class User implements Serializable {
// 增加序列號,作用是反序列化的時候不會報錯，切能進行IO的持久化
public static final long serialVersionUID = 1L;
private Integer id;
private String name;
private String password;
private String email;
private String phone;
private Integer isadmin;
public static long getSerialVersionUID() {
return serialVersionUID;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public Integer getIsadmin() {
return isadmin;
}
public void setIsadmin(Integer isadmin) {
this.isadmin = isadmin;
}
@Override
public String toString() {
return “User{” +
“id=” + id +
“, name='” + name + ‘’’ +
“, password='” + password + ‘’’ +
“, email='” + email + ‘’’ +
“, phone='” + phone + ‘’’ +
“, isadmin=” + isadmin +
‘}’;
}
}
UserDaoImpl
package com.sjsq.dao.impl;
import com.sjsq.dao.UserDao;
import com.sjsq.po.User;
import com.sjsq.utils.BaseDao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
/**
@author shuijianshiqing @date 2020/5/20 22:15 實現(xiàn)UserDao接口
*/
public class UserDaoImpl implements UserDao {
/**
用戶登錄 @param user @return
*/
@Override
public User login(User user) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 1.獲取數(shù)據(jù)庫連接
con = BaseDao.getConnection();
// 2.寫sql
String sql = “select * from user where name = ? and password = ?”;
// 3.預(yù)編譯
ps = con.prepareStatement(sql);
// 4.設(shè)置值
ps.setObject(1,user.getName());
ps.setObject(2,user.getPassword());
rs = ps.executeQuery();
User users = null;
if(rs.next()){
users = new User();
// 從數(shù)據(jù)庫中獲取值到實體類的setter方法中
users.setId(rs.getInt(“id”));
users.setName(rs.getString(“name”));
users.setPassword(rs.getString(“password”));
users.setEmail(rs.getString(“email”));
users.setPhone(rs.getString(“phone”));
users.setIsadmin(rs.getInt(“isadmin”));
// 返回的是你查詢出來的完整的對象
return users;
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
// 關(guān)閉資源，避免出現(xiàn)異常
BaseDao.close(con,ps,rs);
}
return null;
}
/**
用戶注冊 @param user @return
*/
@Override
public boolean register(User user) {
String sql = “insert into user values (0,?,?,?,?,0)”;
List list = new ArrayList();
list.add(user.getName());
list.add(user.getPassword());
list.add(user.getEmail());
list.add(user.getPhone());
boolean flag = BaseDao.addUpdateDelete(sql,list.toArray());
if(flag){
return true;
}else {
return false;
}
}
/**
查詢用戶信息 @param sql @param arr @return
*/
@Override
public List selectUser(String sql, Object[] arr) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 1.連接數(shù)據(jù)庫
con = BaseDao.getConnection();
// 2.預(yù)編譯
ps = con.prepareStatement(sql);
if(arr != null){
for (int i = 0; i < arr.length; i++) {
ps.setObject(i+1,arr[i]);
}
}
// 3.執(zhí)行sql
rs = ps.executeQuery();
// 4.保存查詢出來的數(shù)據(jù)到list
List list = new ArrayList();
while(rs.next()){
User user = new User();
// 從數(shù)據(jù)庫中獲取值到實體類的setter方法中
user.setId(rs.getInt(“id”));
user.setName(rs.getString(“name”));
user.setPassword(rs.getString(“password”));
user.setEmail(rs.getString(“email”));
user.setPhone(rs.getString(“phone”));
user.setIsadmin(rs.getInt(“isadmin”));
// 測試數(shù)據(jù)
System.out.println(“Dao層測試日志，顯示用戶信息：”);
System.out.println(user);
// 將對象保存到list中
list.add(user);
}
return list;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
// 關(guān)閉資源，避免出現(xiàn)異常
BaseDao.close(con,ps,rs);
}
return null;
}
}
BookDao
package com.sjsq.dao;
import com.sjsq.po.Book;
import java.util.List;
/**
@author shuijianshiqing @date 2020/5/20 23:13 圖書信息接口
*/
public interface BookDao {
/**
查詢圖書信息 @param sql @param arr @return
*/
public List select(String sql,Object[] arr);
/**
根據(jù)圖書編號進行查詢 @param id @return
*/
public Book getBook(Integer id);
/**
圖書新增 @param book @return
*/
public boolean addBook(Book book);
/**
圖書修改 @param book @return
*/
public boolean updateBook(Book book);
/**
刪除圖書 @param bookid @return
*/
public boolean deleteBook(Integer bookid);
}
BookDaoImpl
package com.sjsq.dao.impl;
import com.sjsq.dao.BookDao;
import com.sjsq.po.Book;
import com.sjsq.utils.BaseDao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
/**
@author shuijianshiqing @date 2020/5/20 23:15
*/
public class BookDaoImpl implements BookDao {
@Override
public List select(String sql, Object[] arr) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 1.連接數(shù)據(jù)庫
con = BaseDao.getConnection();
// 2.預(yù)編譯
ps = con.prepareStatement(sql);
if(arr != null){
for (int i = 0; i < arr.length; i++) {
// 傳入sql的參數(shù)
ps.setObject(i+1,arr[i]);
}
}
// 3.執(zhí)行sql
rs = ps.executeQuery();
// 4.保存查詢出來的數(shù)據(jù)到list
List list = new ArrayList();
while (rs.next()){
Book book = new Book();
book.setBookid(rs.getInt(“bookid”));
book.setBookname(rs.getString(“bookname”));
book.setPrice(rs.getDouble(“price”));
book.setAuthor(rs.getString(“author”));
book.setPicture(rs.getString(“picture”));
book.setPublish(rs.getString(“publish”));
list.add(book);
}
return list;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
// 關(guān)閉資源，避免出現(xiàn)異常
BaseDao.close(con,ps,rs);
}
return null;
}
@Override
public Book getBook(Integer id) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 1.連接數(shù)據(jù)庫
con = BaseDao.getConnection();
// 2.預(yù)編譯
String sql = “select * from book where bookid = ?”;
ps = con.prepareStatement(sql);
ps.setInt(1,id);
// 3.執(zhí)行sql
rs = ps.executeQuery();
while (rs.next()){
Book book = new Book();
book.setBookid(rs.getInt(“bookid”));
book.setBookname(rs.getString(“bookname”));
book.setPrice(rs.getDouble(“price”));
book.setAuthor(rs.getString(“author”));
book.setPicture(rs.getString(“picture”));
book.setPublish(rs.getString(“publish”));
return book;
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
// 關(guān)閉資源，避免出現(xiàn)異常
BaseDao.close(con,ps,rs);
}
return null;
}
/**
新增圖書 @param book @return
*/
@Override
public boolean addBook(Book book) {
String sql = “insert into book values (0,?,?,?,null,?)”;
List list = new ArrayList();
list.add(book.getBookname());
list.add(book.getPrice());
list.add(book.getAuthor());
list.add(book.getPublish());
boolean flag = BaseDao.addUpdateDelete(sql,list.toArray());
if(flag){
return true;
}else {
return false;
}
}
/**
更新圖書 @param book @return
*/
@Override
public boolean updateBook(Book book) {
String sql = “update book set bookname=?,price=?,author=?,publish=? where bookid=?”;
List list = new ArrayList();
list.add(book.getBookname());
list.add(book.getPrice());
list.add(book.getAuthor());
list.add(book.getPublish());
list.add(book.getBookid());
boolean flag = BaseDao.addUpdateDelete(sql,list.toArray());
if(flag){
return true;
}else {
return false;
}
}
/**
刪除圖書 @param bookid @return
*/
@Override
public boolean deleteBook(Integer bookid) {
String sql = “delete from book where bookid=?”;
List list = new ArrayList();
list.add(bookid);
boolean flag = BaseDao.addUpdateDelete(sql,list.toArray());
if(flag){
return true;
}else {
return false;
}
}
}
BookServiceImpl
package com.sjsq.service.impl;
import com.sjsq.dao.BookDao;
import com.sjsq.dao.impl.BookDaoImpl;
import com.sjsq.po.Book;
import com.sjsq.service.BookService;
import java.util.ArrayList;
import java.util.List;
/**
@author shuijianshiqing @date 2020/5/20 23:42 Book的Service實現(xiàn)層
*/
public class BookServiceImpl implements BookService {
private BookDao dao = new BookDaoImpl();
/**
查詢所有圖書信息 @param book @return
*/
@Override
public List select(Book book) {
StringBuffer sql = new StringBuffer("select * from book where 1 = 1 ");
List list = new ArrayList();
if(book != null){
// 根據(jù)bookid來查找對應(yīng)的書籍
if(book.getBookid() != null && book.getBookid() != 0){
sql.append(" and bookid = ?");
list.add(book.getBookid());
}
// 根據(jù)bookname來查找對應(yīng)的書籍
if(book.getBookname() != null){
System.out.println(“圖書名稱：”+book.getBookname());
sql.append(" and bookname = ?");
list.add(book.getBookname());
}
}
return dao.select(sql.toString(),list.toArray());
}
/**
總結(jié)
就寫到這了，也算是給這段時間的面試做一個總結(jié)，查漏補缺，祝自己好運吧，也希望正在求職或者打算跳槽的 程序員看到這個文章能有一點點幫助或收獲，我就心滿意足了。多思考，多問為什么。希望小伙伴們早點收到滿意的offer! 越努力越幸運！
金九銀十已經(jīng)過了，就目前國內(nèi)的面試模式來講，在面試前積極的準備面試，復(fù)習(xí)整個 Java 知識體系將變得非常重要，可以很負責(zé)任的說一句，復(fù)習(xí)準備的是否充分，將直接影響你入職的成功率。但很多小伙伴卻苦于沒有合適的資料來回顧整個 Java 知識體系，或者有的小伙伴可能都不知道該從哪里開始復(fù)習(xí)。我偶然得到一份整理的資料，不論是從整個 Java 知識體系，還是從面試的角度來看，都是一份含技術(shù)量很高的資料。
本文已被CODING開源項目：【一線大廠Java面試題解析+核心總結(jié)學(xué)習(xí)筆記+最新講解視頻+實戰(zhàn)項目源碼】收錄
需要這份系統(tǒng)化的資料的朋友，可以點擊這里獲取
Object>();
list.add(bookid);
boolean flag = BaseDao.addUpdateDelete(sql,list.toArray());
if(flag){
return true;
}else {
return false;
}
}
}
BookServiceImpl
package com.sjsq.service.impl;
import com.sjsq.dao.BookDao;
import com.sjsq.dao.impl.BookDaoImpl;
import com.sjsq.po.Book;
import com.sjsq.service.BookService;
import java.util.ArrayList;
import java.util.List;
/**
@author shuijianshiqing @date 2020/5/20 23:42 Book的Service實現(xiàn)層
*/
public class BookServiceImpl implements BookService {
private BookDao dao = new BookDaoImpl();
/**
查詢所有圖書信息 @param book @return
*/
@Override
public List select(Book book) {
StringBuffer sql = new StringBuffer("select * from book where 1 = 1 ");
List list = new ArrayList();
if(book != null){
// 根據(jù)bookid來查找對應(yīng)的書籍
if(book.getBookid() != null && book.getBookid() != 0){
sql.append(" and bookid = ?");
list.add(book.getBookid());
}
// 根據(jù)bookname來查找對應(yīng)的書籍
if(book.getBookname() != null){
System.out.println(“圖書名稱：”+book.getBookname());
sql.append(" and bookname = ?");
list.add(book.getBookname());
}
}
return dao.select(sql.toString(),list.toArray());
}
/**
總結(jié)
就寫到這了，也算是給這段時間的面試做一個總結(jié)，查漏補缺，祝自己好運吧，也希望正在求職或者打算跳槽的 程序員看到這個文章能有一點點幫助或收獲，我就心滿意足了。多思考，多問為什么。希望小伙伴們早點收到滿意的offer! 越努力越幸運！
金九銀十已經(jīng)過了，就目前國內(nèi)的面試模式來講，在面試前積極的準備面試，復(fù)習(xí)整個 Java 知識體系將變得非常重要，可以很負責(zé)任的說一句，復(fù)習(xí)準備的是否充分，將直接影響你入職的成功率。但很多小伙伴卻苦于沒有合適的資料來回顧整個 Java 知識體系，或者有的小伙伴可能都不知道該從哪里開始復(fù)習(xí)。我偶然得到一份整理的資料，不論是從整個 Java 知識體系，還是從面試的角度來看，都是一份含技術(shù)量很高的資料。
[外鏈圖片轉(zhuǎn)存中…(img-0a6aTBkj-1715284869159)]
本文已被CODING開源項目：【一線大廠Java面試題解析+核心總結(jié)學(xué)習(xí)筆記+最新講解視頻+實戰(zhàn)項目源碼】收錄
需要這份系統(tǒng)化的資料的朋友，可以點擊這里獲取
柚子快報激活碼778899分享：java 面試 學(xué)習(xí) 用戶登錄
精彩內(nèi)容
本文內(nèi)容根據(jù)網(wǎng)絡(luò)資料整理，出于傳遞更多信息之目的，不代表金鑰匙跨境贊同其觀點和立場。
轉(zhuǎn)載請注明，如有侵權(quán)，聯(lián)系刪除。
Svyaznoy通訊優(yōu)選
