BaseDao多线程的实现

package cn.happy.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class BaseDao1 {
	
	Connection con;
	PreparedStatement stat;//创建一个命令对象
	//获取连接对象的方法
	public Connection getConnection(String url,String useNameString,String passwordString) throws SQLException, ClassNotFoundException{
		String driver="com.mysql.jdbc.Driver";
		Connection conn=null;
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		try {
			conn=(Connection)DriverManager.getConnection(url,useNameString,passwordString);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;		
	}
	
	public void exectQuery(String url,String useNameString,String passwordString) throws SQLException, ClassNotFoundException{
		con=getConnection(url,useNameString,passwordString);
		String sql="SELECT * FROM userinfo";		
		stat=con.prepareStatement(sql);
		ResultSet rs = stat.executeQuery();
		int colum = rs.getMetaData().getColumnCount();
		if(rs!=null){
			while(rs.next()){
				for (int i = 1; i < colum; i++) {
					System.out.println(rs.getString(i)+"\t");
					if((i==2)&&(rs.getString(i).length()<3)){
						System.out.println("\t");
					}
				}
				System.out.println("");
			}
			System.out.println("==================================");
		}
		return ;
	}
	public static void main(String[] args) throws InterruptedException{
		Scanner in=new Scanner(System.in);
		while(true){
			System.out.print("url:");
			String url=in.next();
			System.out.print("username:");
			String useNameString=in.next();
			Info i=new Info(url,useNameString,"");
			invoke(i);
			Thread.sleep(1000);
		}
	}
	public static void invoke(final Info info){
		new Thread(new Runnable() {
			@Override
			public void run() {
                 try {
					new BaseDao1().exectQuery(info.getUrl(),info.getUseNameString(),info.getPasswordString());
				} catch (SQLException e) {
					e.printStackTrace();
				} catch (ClassNotFoundException e) {
					e.printStackTrace();
				}
					System.out.println("success");
			}
		}).start();
	}
	/*Thread thread=new Thread(new Runnable() {
	
	@Override
	public void run() {
		try {
			new BaseDao1().exectQuery(info.getUrl(),info.getUseNameString(),info.getPasswordString());
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		System.out.println("success");
	    }
   });
    thread.start();
    try {
	thread.join();
    } catch (InterruptedException e) {
	e.printStackTrace();
    }
  }*/
}