把数据库的数据在浏览器显示

柔情只为你懂 2022-01-09 06:23 228阅读 0赞

思路：  
1、创建实体类对象  
2、实体类来接数据库数据  
3、创建对象集合，例如ArrayList,来存储数据  
4、使用迭代器或是直接用循环输出数据  
  
  
例子：

![E_6715EN00SIGG.gif][]

package A;  
/\*  
\*  
\* 宠物实体类  
\*  
\*/  
public class pet \{  
  
private int id;  
private int master\_id;  
private String name;  
private int type\_id;  
private int health;  
private int love;  
private String adopt\_time;  
private String status;  
  
//封装  
public int getId() \{  
return id;  
\}  
public void setId(int id) \{  
this.id = id;  
\}  
public int getMaster\_id() \{  
return master\_id;  
\}  
public void setMaster\_id(int masterId) \{  
master\_id = masterId;  
\}  
public String getName() \{  
return name;  
\}  
public void setName(String name) \{  
this.name = name;  
\}  
public int getType\_id() \{  
return type\_id;  
\}  
public void setType\_id(int typeId) \{  
type\_id = typeId;  
\}  
public int getHealth() \{  
return health;  
\}  
public void setHealth(int health) \{  
this.health = health;  
\}  
public int getLove() \{  
return love;  
\}  
public void setLove(int love) \{  
this.love = love;  
\}  
public String getAdopt\_time() \{  
return adopt\_time;  
\}  
public void setAdopt\_time(String adoptTime) \{  
adopt\_time = adoptTime;  
\}  
public String getStatus() \{  
return status;  
\}  
public void setStatus(String status) \{  
this.status = status;  
\}  
  
  
  
\}

![E_6715EN00SIGG.gif][]  
package A;  
  
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.util.ArrayList;  
import java.util.List;  
  
  
public class B \{  
  
public List show()\{  
  
String classname="oracle.jdbc.driver.OracleDriver";  
String url="jdbc:oracle:thin:@localhost:1521:orcl";  
String user="epet";  
String pwd="123";  
//创建对象集合  
List petlist=new ArrayList();  
  
  
Connection con=null;  
PreparedStatement pre=null;  
ResultSet rs=null;  
  
try \{  
  
//加载驱动  
Class.forName(classname);  
//创建连接  
con=DriverManager.getConnection(url,user,pwd);  
  
//编写Sql语句  
String sql="select id,master\_id,nvl(name,'无名'),type\_id,health,love,To\_char(adopt\_time,'yyyy\\"年\\"mm\\"月\\"dd\\"日\\"')," +  
"decode(status,1,'正常',2,'禁用') from pet";  
  
pre=con.prepareStatement(sql);  
  
pre=con.prepareStatement(sql);  
  
//得到结果集  
rs=pre.executeQuery();  
  
  
  
System.out.println("id\\tm\_id\\t姓名\\tt\_id\\t健康值\\t亲密度\\t领养时间\\t\\t\\t状态");  
System.out.println("----------------------------------------------------------------------------");  
//while遍历输出  
while(rs.next())\{  
//实例化宠物对象  
pet pet=new pet();  
pet.setId(rs.getInt(1));  
pet.setMaster\_id(rs.getInt(2));  
pet.setName(rs.getString(3));  
pet.setType\_id(rs.getInt(4));  
pet.setHealth(rs.getInt(5));  
pet.setLove(rs.getInt(6));  
pet.setAdopt\_time(rs.getString(7));  
pet.setStatus(rs.getString(8));  
  
  
//把输出的每一个对象存到对象集合中  
petlist.add(pet);  
  
\}  
  
  
  
\} catch (ClassNotFoundException e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\} catch (SQLException e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\}finally\{  
//释放内存  
  
try \{  
if(rs !=null)\{  
rs.close();  
\}  
if(pre !=null)\{  
pre.close();  
\}  
if(con !=null)\{  
con.close();  
\}  
  
  
\} catch (SQLException e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
  
\}  
  
  
  
\}  
  
return petlist;  
  
\}  
  
  
  
  
\}  
  
  
  
  
  
  
![E_6715EN00SIGG.gif][]  
package A;  
  
import java.util.Iterator;  
import java.util.List;  
  
public class B\_test \{  
  
  
public static void main(String\[\] args) \{  
  
//实例化B对象  
B b=new B();  
  
List petlist=b.show();  
//用迭代器输出  
Iterator it=petlist.iterator();  
  
//迭代器使用while循环输出  
while(it.hasNext())\{  
pet pet=it.next();  
  
//打印输出  
System.out.println(pet.getId()+"\\t"+pet.getMaster\_id()+"\\t"+pet.getName()+"\\t"+pet.getType\_id()  
\+"\\t"+pet.getHealth()+"\\t"+pet.getLove()+"\\t"+pet.getAdopt\_time()+"\\t"+pet.getStatus());  
\}  
  
  
\}  
  
\}

转载于:https://www.cnblogs.com/ziyasi/p/4482678.html

[E_6715EN00SIGG.gif]: /images/20220109/feaa094975e640fda9f334a42c9209eb.png