首先创建WEB项目,命名为learnStudentJavaBean,在src项目中建包vo,新建Student.java
package vo;
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;
}
}
然后在src项目中建包dao,新建StudentDao.java
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import vo.Student;
public class StudentDao {
public ArrayList queryAllStudents() throws Exception{
ArrayList students=new ArrayList();
Statement statement = null;
ResultSet rs = null;
String driver = "com.mysql.jdbc.Driver";
try {
//1. 加载驱动程序
Class.forName(driver);
//2.获取Connection
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/T_STUDENT","root","root");
//3.获取Statement
statement = conn.createStatement();
//4.准备Sql
String sql="select stuno,stuname from T_STUDENT";
//5.执行查询,得到ResultSet
rs = statement.executeQuery(sql);
//6.处理ResultSet
while(rs.next()){
//rs.get+数据库中对应的类型+(数据库中对应的列别名)
Student student=new Student();
student.setStuname(rs.getString("STUNAME"));
student.setStuno(rs.getString("STUNO"));
students.add(student);
}
rs.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
//7.关闭数据库相应的资源
}
return students;
}
}
然后在WebRoot下建daoExample.jsp
<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.getStuname() %></td>
<td><%=student.getStuno() %></td>
</tr>
<%
}
%>
</table>
</body>
记得添加mysql的jar包,然后运行即可!
PS:需要在mysql中先把数据库和表建立起来~~
学习学习,学生党要多学习~~