queryanything.java

来自「一个挺好的招生管理系统」· Java 代码 · 共 51 行

package DataBaseConnection;
import DataBaseConnection.OracleConnection;
import java.sql.*;
import java.util.Vector;

public class Select {
	String sql = null;
	Connection conn = null;
	Statement stmt = null;
	public Select()
	{
		String user = "sox";
		String password = "123";
		OracleConnection oc = new OracleConnection( user, password );
		try{
			conn = oc.getConnection();
			stmt = conn.createStatement();
		}
		catch( SQLException e ){ System.out.println( e.getMessage()+"374" ); }
	}
	
	public void setSQL( String sql )
	{
		this.sql = sql;
	}
	
	public Vector getVector( int columeIndex )
	{
		Vector vt = new Vector();
		try{
			ResultSet rs = stmt.executeQuery(sql);
			while( rs.next() )
			{
				vt.addElement( rs.getString( columeIndex ) );
			}
			rs.close();
		}
		catch( SQLException e ){ System.out.println( e.getMessage()+"123" ); }		
		return vt;
	}
	
	public void close()
	{
		try{
			stmt.close();
			conn.close();
			}catch( SQLException e ){ System.out.println( e.getMessage()+"857" ); }
	} 
	
}