IDEA+Java+JSP+Mysql+Tomcat实现Web宠物信息管理系统

于 2025-02-04 19:21:54 发布
阅读量894 收藏 21
点赞数 15
文章标签： java intellij-idea mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/2501_90404749/article/details/145443563
版权

4.修改宠物

三、部分代码

AdminDaoImpl

PetDaoImpl

pet-add.jsp

pet-add-do.jsp

pet-update.jsp

pet-update-do.jsp

四、其他

1.更多系统

Java+JSP系统系列实现

Java+Servlet系统系列实现

Java+SSM系统系列实现

Java+SSH系统系列实现

Java+Springboot系统系列实现

2.源码下载

3.运行项目

4.备注

5.支持博主

一、系统介绍

======

1.开发环境

开发工具：IDEA2018

JDK版本：Jdk1.8

Mysql版本：8.0.13

2.技术选型

Java+Jsp+Mysql

3.系统功能

1.登录系统；

2.管理员对宠物信息的增删改查。

4.数据库文件

/*

Navicat Premium Data Transfer

Source Server : MYSQL

Source Server Type : MySQL

Source Server Version : 80013

Source Host : localhost:3306

Source Schema : jsp_pet_management

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 01/03/2022 11:05:12

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

– Table structure for admin

DROP TABLE IF EXISTS admin;

CREATE TABLE admin (

username varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

– Records of admin

INSERT INTO admin VALUES (‘admin’, ‘admin’);

– Table structure for pet

DROP TABLE IF EXISTS pet;

CREATE TABLE pet (

id int(11) NOT NULL,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

age varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

address varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

– Records of pet

INSERT INTO pet VALUES (1001, ‘猫大’, ‘3’, ‘湖北武汉’);

INSERT INTO pet VALUES (1002, ‘猫二’, ‘4’, ‘湖南长沙’);

INSERT INTO pet VALUES (1003, ‘狗大’, ‘3’, ‘湖南长沙’);

INSERT INTO pet VALUES (1004, ‘狗二’, ‘4’, ‘吉林长春’);

SET FOREIGN_KEY_CHECKS = 1;

5.系统截图

二、系统展示

======

1.登录系统

2.系统主页

3.新增宠物

4.修改宠物

三、部分代码

=======

AdminDaoImpl

package com.sjsq.dao.impl;

import com.sjsq.dao.AdminDao;

import com.sjsq.utils.DBUtil;

import com.sjsq.entity.Admin;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

/**

  • @author: shuijianshiqing

  • @date: 2022-03-01

  • @description: 登录系统实现

*/

public class AdminDaoImpl implements AdminDao {

/**

  • 登录系统

  • @param admin

  • @return

*/

@Override

public Admin login(Admin admin) {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

// 1.获取数据库连接

con = DBUtil.getConnection();

// 2.写sql

String sql = “select * from admin where username = ? and password = ?”;

// 3.预编译

ps = con.prepareStatement(sql);

// 4.设置值

ps.setObject(1, admin.getUsername());

ps.setObject(2, admin.getPassword());

rs = ps.executeQuery();

Admin adminLogin = null;

if (rs.next()) {

adminLogin = new Admin();

// 从数据库中获取值到实体类的setter方法中

adminLogin.setUsername(rs.getString(“username”));

adminLogin.setPassword(rs.getString(“password”));

// 返回的是你查询出来的完整的对象

return adminLogin;

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} finally {

// 关闭资源，避免出现异常

DBUtil.close(con, ps, rs);

}

return null;

}

}

PetDaoImpl

package com.sjsq.dao.impl;

import com.sjsq.dao.PetDao;

import com.sjsq.entity.Pet;

import com.sjsq.utils.DBUtil;

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: 2022-03-01

  • @description:

*/

public class PetDaoImpl implements PetDao {

@Override

public List selectAll(String sql, Object[] arr) {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

// 1.连接数据库

con = DBUtil.getConnection();

// 2.预编译

ps = con.prepareStatement(sql);

if (arr != null) {

for (int i = 0; i < arr.length; i++) {

// 传入sql的参数,向上转型,某个栏位的查询

ps.setObject(i + 1, arr[i]);

}

}

// 3.执行sql

rs = ps.executeQuery();

// 4.保存查询出来的数据到list

List list = new ArrayList<>();

while (rs.next()) {

Pet pet = new Pet();

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

pet.setName(rs.getString(“name”));

pet.setAge(rs.getString(“age”));

pet.setAddress(rs.getString(“address”));

list.add(pet);

}

return list;

} catch (Exception e) {

e.printStackTrace();

} finally {

// 关闭链接，避免数据库连接过多

DBUtil.close(con, ps, rs);

}

return null;

}

@Override

public Pet selectPet(Integer id) {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

// 1.连接数据库

con = DBUtil.getConnection();

// 2.预编译

String sql = “select * from pet where id = ?”;

ps = con.prepareStatement(sql);

ps.setInt(1,id);

// 3.执行sql

rs = ps.executeQuery();

while (rs.next()){

Pet pet = new Pet();

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

pet.setName(rs.getString(“name”));

pet.setAge(rs.getString(“age”));

pet.setAddress(rs.getString(“address”));

return pet;

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}finally {

// 关闭资源，避免出现异常

DBUtil.close(con,ps,rs);

}

return null;

}

@Override

public boolean addPet(Pet pet) {

String sql = “insert into pet values (?,?,?,?)”;

List list = new ArrayList();

list.add(pet.getId());

list.add(pet.getName());

list.add(pet.getAge());

list.add(pet.getAddress());

boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());

if(flag){

return true;

}else {

return false;

}

}

@Override

public boolean updatePet(Pet pet) {

String sql = “update pet set name=?,age=?,address=? where id=?”;

List list = new ArrayList();

list.add(pet.getName());

list.add(pet.getAge());

list.add(pet.getAddress());

// 注意id在最后面

list.add(pet.getId());

boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());

if(flag){

return true;

}else {

return false;

}

}

@Override

public boolean deletePet(Integer id) {

String sql = “delete from pet where id=?”;

List list = new ArrayList();

list.add(id);

boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());

if(flag){

return true;

}else {

return false;

}

}

}

pet-add.jsp

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

新增宠物

<%-- 头部 --%>

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

新增宠物

返回上一级


添加

重置

<%-- 底部 --%>

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

pet-add-do.jsp

<%@ page import=“com.sjsq.entity.Pet” %>

<%@ page import=“com.sjsq.service.PetService” %>

<%@ page import=“com.sjsq.service.impl.PetServiceImpl” %>

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

新增宠物

<%

// 设置获取注册时的编码为UTF-8

request.setCharacterEncoding(“UTF-8”);

//获取teacher-add.jsp页面提交的账号和密码,注意传过来的是字符串需要进行转化为对应的类型

Integer id = Integer.parseInt(request.getParameter(“id”));

String name = request.getParameter(“name”);

String age = request.getParameter(“age”);

String address = request.getParameter(“address”);

// 将信息保存到实体类中

Pet pet = new Pet();

pet.setId(id);

pet.setName(name);

pet.setAge(age);

pet.setAddress(address);

System.out.println(“添加的宠物信息”);

System.out.println(pet);

// 将数据写入到数据库

PetService petService = new PetServiceImpl();

boolean flag = petService.addPet(pet);

if(flag){

response.sendRedirect(“main.jsp”);

}else{

response.sendRedirect(“error.jsp”);

}

%>

pet-update.jsp

<%@ page import=“com.sjsq.entity.Pet” %>

<%@ page import=“com.sjsq.service.PetService” %>

<%@ page import=“com.sjsq.service.impl.PetServiceImpl” %>

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

修改宠物

<%-- 头部 --%>

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

修改宠物

<%

//获取main.jsp页面的id

Integer id = Integer.parseInt(request.getParameter(“id”));

PetService petService = new PetServiceImpl();

Pet pet = petService.selectPet(id);

%>

返回上一级

<%-- 这里教职工号不能修改 --%>


修改

重置

<%-- 底部 --%>

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

pet-update-do.jsp

<%@ page import=“com.sjsq.entity.Pet” %>

<%@ page import=“com.sjsq.service.PetService” %>

<%@ page import=“com.sjsq.service.impl.PetServiceImpl” %>

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

修改宠物

<%

// 设置获取注册时的编码为UTF-8

request.setCharacterEncoding(“UTF-8”);

//获取teacher-update.jsp页面提交的账号和密码,注意传过来的是字符串需要进行转化为对应的类型

Integer id = Integer.parseInt(request.getParameter(“id”));

String name = request.getParameter(“name”);

String age = request.getParameter(“age”);

String address = request.getParameter(“address”);

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值