Java 入门之数据库连接和ArrayList的用法~

Person.java


/**//*
* 创建日期 2005-3-17
*
*
*
*/
package com.faintbear;

/**//**
*
*
*
*
*/
public class Person {

private String empname="";
private String empno="";

public void setEmpName(String empname)
{
this.empname=empname;
}

public String getEmpName()
{
return this.empname;
}


public void setEmpNo(String empno)
{
this.empno=empno;
}

public String getEmpNo()
{
return this.empno;
}


}


DbConnect.java

package com.faintbear;
import java.util.*;
import java.sql.*;

/**//**
*
*
* 数据库连接和测试
*
*/
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
{
Class.forName(driver);
conn =DriverManager.getConnection(dburl,user,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);


}

public Connection getConnection()
{
return conn;
}


public List getEmpNameList() throws Exception
{
String sql="select * from cus_emp_basic where rownum<10";
Connection conn=null;
Statement stmt=null;
ResultSet rst=null;
ArrayList resultlist = new ArrayList();
try
{

rst=(new DbConnect()).stmt.executeQuery(sql);

while (rst.next())
{
Person person = new Person();
person.setEmpNo(rst.getString("emp_no"));
person.setEmpName(rst.getString("emp_name"));
resultlist.add(person);
}
}finally
{
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
{
DbConnect dbc = new DbConnect();
List l1=(dbc.getEmpNameList());
for(int i=0;i<l1.size();i++)
{
Person person1=(Person)l1.get(i);
System.out.println("person"+i+"="+person1.getEmpName()+" "+"empno="+person1.getEmpNo());

}


}

}
本文出自 51CTO.COM技术博客