2024年最全Java+Servlet+JSP实现Web宠物诊所管理系统，java常用框架面试

于 2024-05-07 17:49:07 发布
阅读量389 收藏 10
点赞数 4
分类专栏： 程序员 文章标签： java servlet 前端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2401_83977626/article/details/138540085
版权

本次面试答案，以及收集到的大厂必问面试题分享：

字节跳动超高难度三面java程序员面经，大厂的面试都这么变态吗？

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

  • path + “/”;

%>

失败

注册失败




(╯﹏╰） 注册失败，返回重新注册

返回

<jsp:include page=“footer.jsp”></jsp:include>

addsuc.jsp

<%@ page language=“java” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/”

  • request.getServerName() + “:” + request.getServerPort()

  • path + “/”;

%>

恭喜注册成功

注册成功




(__)恭喜您注册成功！3s后返回登录页面

立即返回

<jsp:include page=“footer.jsp”></jsp:include>

petadd.jsp

<%@ page language=“java” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/”

  • request.getServerName() + “:” + request.getServerPort()

  • path + “/”;

%>

宠物新增

<jsp:include page=“top.jsp”></jsp:include>


宠物名  * 主人  * 城市     地址     电话  *

<jsp:include page=“footer.jsp”></jsp:include>

petupdate.jsp

<%@ page language=“java” import=“cn.dao.UserBean” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/”

  • request.getServerName() + “:” + request.getServerPort()

  • path + “/”;

%>

宠物修改

<jsp:include page=“top.jsp”></jsp:include>

<%

UserBean user = (UserBean) request.getAttribute(“user”);

%>


宠物名  >* 主人  >* 城市 

value=<% if(user.getPetcity()==null){out.print(" ");}else{out.print(user.getPetcity());} %>>  

地址 

value=<% if(user.getPetadress()==null){out.print(" ");}else{out.print(user.getPetadress());} %>>  

电话 

value=<% if(user.getPetphone()==null){out.print(" ");}else{out.print(user.getPetphone());} %>>*

<input type=“hidden” name=“id” value=<%=user.getId() %>>

<jsp:include page=“footer.jsp”></jsp:include>

petsearch.jsp

<%@ page language=“java” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/” + request.getServerName() + “:” + request.getServerPort() + path + “/”;

%>

宠物查询

<jsp:include page=“top.jsp”></jsp:include>

宠物名: 主  人:

添加

<jsp:include page=“footer.jsp”></jsp:include>

docadd.jsp

<%@ page language=“java” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/”

  • request.getServerName() + “:” + request.getServerPort()

  • path + “/”;

%>

医生新增

<jsp:include page=“top.jsp”></jsp:include>


姓名  * 专业  * 电话     地址    

<jsp:include page=“footer.jsp”></jsp:include>

docupdate.jsp

<%@ page language=“java” import=“cn.dao.UserBean” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/”

  • request.getServerName() + “:” + request.getServerPort()

  • path + “/”;

%>

医生修改

<jsp:include page=“top.jsp”></jsp:include>

<%

UserBean user = (UserBean) request.getAttribute(“user”);

%>


姓名  >* 专业  >* 电话 

value=<% if(user.getDocphone()==null){out.print(" ");}else{out.print(user.getDocphone());} %>>  

地址 

value=<% if(user.getDocadress()==null){out.print(" ");}else{out.print(user.getDocadress());} %>>  

<input type=“hidden” name=“id” value=<%=user.getId() %>>

<jsp:include page=“footer.jsp”></jsp:include>

docsearch.jsp

<%@ page language=“java” pageEncoding=“UTF-8” %>

<%

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/” + request.getServerName() + “:” + request.getServerPort() + path + “/”;

%>

医生查询

<jsp:include page=“top.jsp”></jsp:include>

兽医姓名: 专  业:

添加

<jsp:include page=“footer.jsp”></jsp:include>

2.后端

DBConn

package cn.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

public class DocManage {

// 空构造方法

public DocManage() {

}

// 添加兽医

public int addPetdoc(UserBean user) {

String sql = “INSERT INTO petdoctor(docname,docmajor,docphone,docadress) VALUES (?,?,?,?)”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getDocname());

DBConn.ps.setString(2, user.getDocmajor());

DBConn.ps.setString(3, user.getDocphone());

DBConn.ps.setString(4, user.getDocadress());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 删除兽医

public int delPetdocForId(UserBean user) {

String sql = “DELETE FROM petdoctor WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setInt(1, user.getId());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 通过id删除兽医

public int delPetdocForId(int id) {

String sql = “DELETE FROM petdoctor WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setInt(1, id);

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 更新兽医

public int updatePetdocForId(UserBean user) {

String sql = “UPDATE petdoctor SET docname=?, docmajor=?,docphone=?,docadress=? WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getDocname());

DBConn.ps.setString(2, user.getDocmajor());

DBConn.ps.setString(3, user.getDocphone());

DBConn.ps.setString(4, user.getDocadress());

DBConn.ps.setInt(5, user.getId());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 获取所有兽医

public List getAllPetdoc() {

String sql = “SELECT * FROM petdoctor”;

List users = new ArrayList();

try {

DBConn.prepareConnection();

DBConn.ps = DBConn.con.prepareStatement(sql);

ResultSet rs = DBConn.ps.executeQuery();

while (rs.next()) {

UserBean user = new UserBean();

user.setId(rs.getInt(“id”));

user.setDocname(rs.getString(“docname”));

user.setDocmajor(rs.getString(“docmajor”));

user.setDocphone(rs.getString(“docphone”));

user.setDocadress(rs.getString(“docadress”));

users.add(user);

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DBConn.close();

}

return users;

}

// 通过兽医名获取兽医

public List getPetdocForName(UserBean use) {

String sql = “SELECT * FROM petdoctor WHERE docname=?”;

List users = new ArrayList();

try {

DBConn.prepareConnection();

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, use.getDocname());

ResultSet rs = DBConn.ps.executeQuery();

while (rs.next()) {

UserBean user = new UserBean();

user.setId(rs.getInt(“id”));

user.setDocname(rs.getString(“docname”));

user.setDocmajor(rs.getString(“docmajor”));

user.setDocphone(rs.getString(“docphone”));

user.setDocadress(rs.getString(“docadress”));

users.add(user);

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DBConn.close();

}

return users;

}

// 通过兽医专业获取兽医

public List getPetdocForMajor(UserBean use) {

String sql = “SELECT * FROM petdoctor WHERE docmajor=?”;

List users = new ArrayList();

try {

DBConn.prepareConnection();

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, use.getDocmajor());

ResultSet rs = DBConn.ps.executeQuery();

while (rs.next()) {

UserBean user = new UserBean();

user.setId(rs.getInt(“id”));

user.setDocname(rs.getString(“docname”));

user.setDocmajor(rs.getString(“docmajor”));

user.setDocphone(rs.getString(“docphone”));

user.setDocadress(rs.getString(“docadress”));

users.add(user);

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DBConn.close();

}

return users;

}

// 通过兽医id获取兽医

public UserBean getPetdocForId(int id) {

String sql = “SELECT * FROM petdoctor WHERE id=?”;

UserBean user = new UserBean();

try {

DBConn.prepareConnection();

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setInt(1, id);

ResultSet rs = DBConn.ps.executeQuery();

while (rs.next()) {

user.setId(rs.getInt(“id”));

user.setDocname(rs.getString(“docname”));

user.setDocmajor(rs.getString(“docmajor”));

user.setDocphone(rs.getString(“docphone”));

user.setDocadress(rs.getString(“docadress”));

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DBConn.close();

}

return user;

}

// 通过兽医名获取兽医

public Integer getIdForName(UserBean user) {

String sql = “SELECT * FROM petdoctor WHERE docname=?”;

Integer i = 0;

try {

DBConn.prepareConnection();

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getLoginname());

ResultSet rs = DBConn.ps.executeQuery();

while (rs.next()) {

i = rs.getInt(“id”);

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

}

UserManage

package cn.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

public class UserManage {

// 空构造方法

public UserManage() {

}

// 添加用户

public int addUser(UserBean user) {

String sql = “INSERT INTO userinfo(username,password,userphone) VALUES (?,?,?)”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getLoginname());

DBConn.ps.setString(2, user.getLoginpassword());

DBConn.ps.setString(3, user.getLoginphone());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

System.out.println(“插入数据失败！”);

i = 2;

} finally {

DBConn.close();

}

return i;

}

// 删除用户

public int delUserForId(UserBean user) {

String sql = “DELETE FROM userinfo WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setInt(1, user.getId());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 更新用户

public int updateUseForId(UserBean user) {

String sql = “UPDATE userinfo SET username=?, password=?,userphone=? WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getLoginname());

DBConn.ps.setString(2, user.getLoginpassword());

DBConn.ps.setString(3, user.getLoginphone());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

最后

码字不易，觉得有帮助的可以帮忙点个赞，让更多有需要的人看到

又是一年求职季，在这里，我为各位准备了一套Java程序员精选高频面试笔试真题，来帮助大家攻下BAT的offer，题目范围从初级的Java基础到高级的分布式架构等等一系列的面试题和答案，用于给大家作为参考

以下是部分内容截图
架构面试专题及架构学习笔记导图.png

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

package cn.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

public class UserManage {

// 空构造方法

public UserManage() {

}

// 添加用户

public int addUser(UserBean user) {

String sql = “INSERT INTO userinfo(username,password,userphone) VALUES (?,?,?)”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getLoginname());

DBConn.ps.setString(2, user.getLoginpassword());

DBConn.ps.setString(3, user.getLoginphone());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

System.out.println(“插入数据失败！”);

i = 2;

} finally {

DBConn.close();

}

return i;

}

// 删除用户

public int delUserForId(UserBean user) {

String sql = “DELETE FROM userinfo WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setInt(1, user.getId());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

}

// 更新用户

public int updateUseForId(UserBean user) {

String sql = “UPDATE userinfo SET username=?, password=?,userphone=? WHERE id=?”;

int i = 0;

try {

DBConn.prepareConnection();

DBConn.con.setAutoCommit(false);

DBConn.ps = DBConn.con.prepareStatement(sql);

DBConn.ps.setString(1, user.getLoginname());

DBConn.ps.setString(2, user.getLoginpassword());

DBConn.ps.setString(3, user.getLoginphone());

i = DBConn.ps.executeUpdate();

DBConn.con.commit();

} catch (SQLException e) {

DBConn.rollback();

e.printStackTrace();

} finally {

DBConn.close();

}

return i;

最后

码字不易，觉得有帮助的可以帮忙点个赞，让更多有需要的人看到

又是一年求职季，在这里，我为各位准备了一套Java程序员精选高频面试笔试真题，来帮助大家攻下BAT的offer，题目范围从初级的Java基础到高级的分布式架构等等一系列的面试题和答案，用于给大家作为参考

以下是部分内容截图
[外链图片转存中…(img-A8TsX1wR-1715075331845)]

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

2401_83977626
关注
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值