多线程 BaseDao

package Thread5;

import java.sql.*;
import java.util.Scanner;

/**
 * Created by microc on 2017/7/2.
 */
public class BaseDao {

    Connection con;
    PreparedStatement ps;
    ResultSet rs;
    public Connection getConnection(String url,String username,String pwd)  {
        String driver="com.mysql.jdbc.Driver";
        try {
            Class.forName(driver);
            if (con==null||con.isClosed()) {
                con = DriverManager.getConnection(url, username, pwd);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;


    }

    public void getAll(String url,String username,String pwd){
        con=getConnection(url,username,pwd);
        String sql="select * from cate";
        try {
            ps=con.prepareStatement(sql);
            rs=ps.executeQuery();
            if(rs!=null){
                while(rs.next()){
                    System.out.println(rs.getInt("cid")+"           "+rs.getString("cname"));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }


    }

    public static void main(String[] args) throws InterruptedException {
        Scanner input=new Scanner(System.in);
        while(true){
        System.out.print("url：");
        String url=input.next();
        System.out.print("username：");
        String username=input.next();
        String pwd="";
        Info info=new Info();
        info.setUrl(url);
        info.setUsername(username);
        info.setPwd(pwd);
        invoke(info);
        //方法一：
       // Thread.sleep(2000);
        // 方法二：

        }
    }

    //jdbc:mysql://localhost:3306/emp
    public static void invoke(final  Info info) throws InterruptedException {
      Thread t= new Thread(new Runnable() {
            @Override
            public void run() {
                new BaseDao().getAll(info.getUrl(),info.getUsername(),info.getPwd());
            }
        });
      t.start();
      t.join();

    }
}