serverlet增删改查项目代码

最新推荐文章于 2022-07-28 23:00:00 发布

所念jie星河

最新推荐文章于 2022-07-28 23:00:00 发布

阅读量274

点赞数

本文链接：https://blog.csdn.net/qq_46109103/article/details/118218483

版权

本文档详细介绍了使用Servlet进行数据库操作的项目，包括定义数据库连接关闭、实现BaseDao的增删改查功能，并通过RegeditServlet处理注册页面，错误页面的设计以及web.xml配置。EditServlet和QueryAllServlet用于数据编辑和全量查询，同时展示了更新和删除操作的Servlet实现。

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

serverlet项目代码

定义数据库连接关闭

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.*;

public class DBManager {
   
	
	private static final String DRIVERNAME = "com.mysql.jdbc.Driver";
	private static final String URL = "jdbc:mysql://127.0.0.1:3306/bbs?useUnicode=true&characterEncoding=utf8";
	private static final String USERNAME = "root";
	private static final String USERPWD = "123456";
	
	public Connection getconn() throws ClassNotFoundException, SQLException {
   
		Class.forName(DRIVERNAME);
		Connection conn=DriverManager.getConnection(URL,USERNAME,USERPWD);
		System.out.print("DB Success!!");
		return  conn;
		
	}
	
	public void closeAll(ResultSet rs,PreparedStatement pstmt,Connection conn) throws SQLException {
   
			if(rs!=null) {
   
				rs.close();
			}
			if(pstmt!=null) {
   
				pstmt.close();
			}
			if(conn!=null) {
   
				conn.close();
			}
	}	
}

增删改查（BaseDao）

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * 
 * @author Administrator
 *增删改查通用方法
 */
public class BaseDao {
   

	public boolean insert_update_del(String sql,Object val[]) throws ClassNotFoundException, SQLException {
   
		boolean flag=false;
		Connection con=new DBManager().getconn();
		PreparedStatement pstmt=con.prepareStatement(sql);
		if(val!=null) {
   
			for(int i=0;i<val.length;i++) {
   
				pstmt.setObject(i+1, val[i]);
			}			
		}	
		if(pstmt.executeUpdate()>0) {
   
			flag=true;
		}
		return flag;
	}
	
	public ResultSet query(String sql,Object val[]) throws ClassNotFoundException, SQLException {
   
		boolean flag=false;
		Connection con=new DBManager().getconn();
		PreparedStatement pstmt=con.prepareStatement(sql);
		if(val!=null) {
   
			for(int i=0;i<val.length;i++) {
   
				pstmt.setObject(i+1, val[i]);
			}			
		}	
		ResultSet rs=pstmt.executeQuery();
		return rs;
	}
}

继承增删改查

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class StudentsDao extends BaseDao{
   
	
	public boolean regeditStudent(Student stu) throws ClassNotFoundException, SQLException {
   
		String sql="insert into students values (null,?,?)";
		Object[] val= {
   stu.getSname(),stu.getSpwd()};
		return insert_update_del(sql,val);
	}
	
	public List<Student> quaryAll() throws ClassNotFoundException, SQLException{
   
		List<Student> list=new ArrayList<Student>();
		String sql="select * from students";
		Object[] val= {
   };
		ResultSet rs=query(sql,val);
		while(rs.