JSP中操作数据库

JSP中操作数据库

思路：连接数据库，将获取到的数据存储起来，然后在数据列表页中进行获取渲染

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.util.*,beans.Emp,java.sql.*" %>
<%

	request.setCharacterEncoding("utf-8");
	

	//定义集合用于接收数据
	List<Emp> list = new ArrayList<Emp>();
	//1、注册驱动
	Class.forName("com.mysql.jdbc.Driver");
	//2、获取连接对象
	Connection conn = DriverManager.getConnection("jdbc:mysql:///hongzehu","root","root");
	//3、定义SQL，预编译
	String sql = "select * from emp";
	PreparedStatement ps = conn.prepareStatement(sql);
	//4、执行SQL拿到结果集
	ResultSet rs = ps.executeQuery();
	//5、遍历结果集，将结果集存储到集合中
	while(rs.next()){
		int eno = rs.getInt(1);
		String ename = rs.getString(2);
		String sex