JAVAWeb添加，查询，删除，修改

jfnakj

已于 2022-09-18 23:23:51 修改

阅读量1.2k

点赞数 4

文章标签： servlet java jvm 数据库 sql

于 2022-09-18 23:21:13 首次发布

本文链接：https://blog.csdn.net/jfnakj/article/details/126924690

版权

这篇博客介绍了JAVAWeb中对Customer实体类的操作，包括CustomerDaoImpl DAO实现类的详细步骤，CustomerServlet用于客户注册，DeletionServlet实现客户删除，QueryServlet负责客户查询，XiugaiServlet进行客户信息修改。通过这些类和xg.jsp页面，实现了注册、删除、查询和修改的功能。实际操作中，成功进行了注册、删除和修改操作，并在数据库中查看了结果。

摘要由CSDN通过智能技术生成

Customer实体类

CustomerDaoImpl DAO实现类

CustomerServlet 客户注册类

DeletionServlet 客户删除类

QueryServlet 客户查询类

XiugaiServlet 客户修改类

xg.jsp

CustomerDaoImpl DAO实现类

import java.awt.image.RasterFormatException;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import com.nanyang.database.C3pOPoolUtils;
import com.nanyang.entity.Customer;

public class CustomerDaoImpl implements CustomerDao{
	//获取数据库连接
	QueryRunner runner =new	QueryRunner(C3pOPoolUtils.getDataSource());
	
	@Override
	public boolean save(Customer c) {
		try {
			 //sql语句
			String sql = "insert into root values(null,?,?,?)";
			//为占位符设置参数
		int i =	runner.update(sql,c.getName(),c.getAccount(),c.getPassword());
		//判断是否添加成功
			return i >0 ? true : false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			throw new RasterFormatException(e.getMessage());
		}
		
	}

	public List<Customer> QueryCustomer() {
		try {
			//sql语句
			String sql ="select * from root";
			return 	runner.query(sql, new BeanListHandler<Customer>(Customer.class));
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			throw new RasterFormatException(e.getMessage());
		}
		
	}

	public boolean DeleteCustomer(String id) {	
		
		try {
			//sql语句
			String sql = "delete from root where id=?";
			int update = runner.update(sql , id);
			//判断是否删除成功
			String msg =update > 0 ? "删除成功" : "删除失败";
			System.out.println(msg);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			throw new RasterFormatException(e.getMessage());
		}
		return false;
		
	}

	public Integer XiuGaiCustomer(int id,Customer customer) {
		String sql= "update root set name=?,account=?,password=? where id=? ";
		// TODO Auto-generated method stub
		Integer up;
		try {
			up = runner.update(sql, customer.getName(),customer.getAccount(),customer.getPassword(),id);
			return up;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return 5;
		}
		
	}

CustomerServlet 客户注册类

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.ht