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() {@Overridepublic 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() {@Overridepublic 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();    }  }*/}