Web：JavaBean使用DAO和VO显示到浏览器数据库中表格

最新推荐文章于 2022-05-13 09:51:03 发布

乐乐乐乐叻叻

最新推荐文章于 2022-05-13 09:51:03 发布

阅读量202

点赞数

分类专栏： JavaWeb 文章标签： jdbc sql mysql javabean

本文链接：https://blog.csdn.net/z2018/article/details/111031368

版权

JavaWeb 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

Project
在这里插入图片描述
数据库

Student.java

package test2;

public class Student {
private String stuno;
private String stuname;

public String getStuno() {
	return stuno;
}
public void setStuno(String stuno) {
	this.stuno = stuno;
}
public String getStuname() {
	return stuname;
}
public void setStuname(String stuname) {
	this.stuname = stuname;
}
}

StudentDao.java

package test2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import test2.Student;

public class StudentDao {
	public ArrayList queryAllStudents() throws Exception {
		
		Connection conn = null;
		ArrayList students = new ArrayList();
		
		try{
			//获取连接
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dsschool?characterEncoding=utf-8", "root", "123456"); //连接数据库
			String sql="select stuno,stuname from t_student";
			Statement stat=conn.createStatement(); 
			ResultSet rs = stat.executeQuery(sql);
			
			while(rs.next()){
				//实例化VO
				Student student = new Student();
				student.setStuno(rs.getString("stuno"));
				student.setStuname(rs.getString("stuname"));
				students.add(student);
			}
			rs.close();
			stat.close();
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			try{//关闭连接
				if(conn!=null){
					conn.close();
					conn=null;
				}
		}catch(Exception ex){
		}
	}
		return students;
	}
}

showStudent.jsp

<%@page language="java" import="java.util.*,java.sql.*"  pageEncoding="UTF-8"%>
<%@page import = "test2.Student" %>
<%@page import = "test2.StudentDao" %>
<html>
<head>
<title>Student-Print</title>
</head>

<body>
<%
	StudentDao studentDao = new StudentDao();
	ArrayList students = studentDao.queryAllStudents();
 %>
 
<table border = 2>

<tr>
	<td>学号</td>
	<td>姓名</td>
</tr>

 <%
for(int i =0 ; i<students.size() ; i++){
	Student student = (Student)students.get(i);

%>

<tr>
<td><%= student.getStuno() %></td>
<td><%= student.getStuname() %></td>
</tr>

<%}%>
</table>
</body>
</html>

显示效果

乐乐乐乐叻叻

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
1
评论
Web：JavaBean使用DAO和VO显示到浏览器数据库中表格

Project数据库Student.javapackage test2;public class Student {private String stuno;private String stuname;public String getStuno() { return stuno;}public void setStuno(String stuno) { this.stuno = stuno;}public String getStuname() { return st
复制链接

扫一扫