最简单的JavaBean学习

来源：互联网发布：dc数据恢复指南针编辑：程序博客网时间：2024/04/30 22:03

首先创建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

记得添加mysql的jar包，然后运行即可！

PS：需要在mysql中先把数据库和表建立起来~~

学习学习，学生党要多学习~~

0 0