Person.java
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**/
/*
* 创建日期 2005-3-17
*
*
*
*/
package com.faintbear;
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**/
/**
*
*
*
*
*/
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
public
class
Person
{
private String empname="";
private String empno="";
public void setEmpName(String empname)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.empname=empname;
}
public String getEmpName()
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return this.empname;
}
public void setEmpNo(String empno)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.empno=empno;
}
public String getEmpNo()
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return this.empno;
}
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
}
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
DbConnect.java
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
package com.faintbear;
import java.util.
*
;
import java.sql.
*
;
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**/
/**
*
*
* 数据库连接和测试
*
*/
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
public
class
DbConnect
{
public Connection conn;
private Statement stmt;
private PreparedStatement pstmt;
private String dburl="jdbc:oracle:thin:@192.168.41.16:1521:cc";
private String user="cc";
private String password="123456";
private String driver="oracle.jdbc.driver.OracleDriver";
public DbConnect() throws Exception
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Class.forName(driver);
conn =DriverManager.getConnection(dburl,user,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
public Connection getConnection()
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return conn;
}
public List getEmpNameList() throws Exception
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
String sql="select * from cus_emp_basic where rownum<10";
Connection conn=null;
Statement stmt=null;
ResultSet rst=null;
ArrayList resultlist = new ArrayList();
try
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
rst=(new DbConnect()).stmt.executeQuery(sql);
while (rst.next())
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Person person = new Person();
person.setEmpNo(rst.getString("emp_no"));
person.setEmpName(rst.getString("emp_name"));
resultlist.add(person);
}
}finally
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if(rst!=null)rst.close();
if(stmt!=null)stmt.close();
if(conn!=null)conn.close();
}
return resultlist;
}
public static void main(String []args) throws Exception
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DbConnect dbc = new DbConnect();
List l1=(dbc.getEmpNameList());
for(int i=0;i<l1.size();i++)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Person person1=(Person)l1.get(i);
System.out.println("person"+i+"="+person1.getEmpName()+" "+"empno="+person1.getEmpNo());
}
}
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
}
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![None.gif](http://www.blogjava.net/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![ExpandedBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](http://www.blogjava.net/Images/dot.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![InBlock.gif](http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
转载于:https://blog.51cto.com/104660/21029