select.java

用java编写的对数据库

package project;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class Select
{
	String sql="select * from jdbcExample";
	Connection connection=null;
	Statement sta=null;
	ResultSet rs=null;
	List list=new ArrayList();
	try 
	{
		//加载oracle驱动程序
		Class.forName("oracle.jdbc.driver.OracleDriver");
	} 
	catch (ClassNotFoundException e1) {
		e1.printStackTrace();
	}
	//数据库连接的字符串
	String url="jdbc:oracle:thin:@localhost:1521:ORADB";
	String userName="wq";//用户名
	String pw="wq";//密码
	try 
	{
		//创建连接
		connection=DriverManager.getConnection(url, userName, pw);
		//创建语句对象			
		sta=connection.createStatement();			
		//执行sql语句的操作并且返回执行的行数
		rs=sta.executeQuery(sql);
		list=(List)ReflectionCommon.reflectionRsToBean(rs,"JdbcExample.Person");
			
		
	} 
	catch (SQLException e) 
	{
		e.printStackTrace();
	}
	finally
	{
		try
		{
			//关闭结果集对象
			rs.close();
			//关闭声明语句对象
			sta.close();
			//关闭连接对象
			connection.close();
		}
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
	}
	return list;
}