package org.evilbinary.db;
import java.sql.*;
import java.util.Vector;

public class DBUtil {
	private String userName;
	private String password;
	private String connectUrl;
	private String driverName;
	private Statement statement;
	private PreparedStatement preparedStatement;
	private Connection connection;
	private ResultSet resultSet;
	private CallableStatement callStatement;
	public DBUtil(){
		driverName="com.mysql.jdbc.Driver";
		connectUrl="jdbc:mysql://localhost:3306/oj";
		userName="root";
		password="123";
		connect();
	}
	public DBUtil(String connectUrl,String userName,String password){
		driverName="com.mysql.jdbc.Driver";
		this.connectUrl=connectUrl;
		this.userName=userName;
		this.password=password;
		connect();
	}
	public void connect(){
		if(connection!=null)
			return;
		try {
			Class.forName(driverName);
			connection=DriverManager.getConnection(connectUrl,userName,password);
		} catch (ClassNotFoundException e) {
			System.out.println("jdbc driver can not found!"+e.getMessage());
		} catch (SQLException e) {
			System.out.println("connect failed!"+e.getMessage());
		}catch(Exception e){
			System.out.println("Error!"+e.getMessage());
		}
	}
	public void close(){
		try {
			if(statement!=null&&!statement.isClosed())
				statement.close();
			if(callStatement!=null&&!callStatement.isClosed())
				callStatement.close();
			if(preparedStatement!=null&&!preparedStatement.isClosed())
				preparedStatement.close();
			if(connection!=null&&!connection.isClosed())
				connection.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void executeQuery(String sql){
		try {
			statement=connection.createStatement();
			resultSet=statement.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("executeQuery failed!"+e.getMessage());
		}catch(Exception e){
			System.out.println("executeQuery error!"+e.getMessage());
		}
	}
	public void executeQuery(String sql,String parameters[]){
		try {
			preparedStatement=connection.prepareStatement(sql);
			for(int i=0;i getResultsVectorStrings(){
		
		ResultSetMetaData resultSetMetaData;
		Vector vv=new Vector();
		try {
			resultSetMetaData = resultSet.getMetaData();
			int numCols=resultSetMetaData.getColumnCount();
			while(resultSet.next())
            { 
                String[] v=new String[numCols];
                for(int i=0;i
public class Main {
	/**
	 * @param args
	 */
	public static void output(Vector vv){
		for(int i=0;i vv=db.getResultsVectorStrings();
////		output(vv);
////		db.executeQuery("select a from s");
////		vv=db.getResultsVectorStrings();
////		output(vv);
////		Vector v=db.getResultsVectorColum(2);
////		for(int i=0;i