多线程之basedao

package cn.jjz;

import cn.jjz.pojo.Info;

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

/**
 * Created by lenovo on 2017/7/9.
 */
public class BaseDao1 {
    public Connection getConnection(String url, String username, String password){
        String driver="com.mysql.jdbc.Driver";
        Connection conn=null;
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            conn=(Connection) DriverManager.getConnection(url,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    private void getAll(String url,String username,String password){

        Connection conn=getConnection(url, username, password);
        String sql="select * from people";
        PreparedStatement pstmt;
        try {
            pstmt=(PreparedStatement)conn.prepareStatement(sql);
            ResultSet rs=pstmt.executeQuery();
            int col=rs.getMetaData().getColumnCount();
            System.out.println("===================================");
            while (rs.next()) {
                for (int i = 1; i <=col; i++) {
                    System.out.println(rs.getString(i)+"\t");
                    if((i==2)&&(rs.getString(i).length()<8)){
                        System.out.println("\t");
                    }
                }
                System.out.println("===================================");
            }
            System.out.println();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ;
    }
    public static void main(String[] args) throws InterruptedException {
        Scanner in=new Scanner(System.in);
        while (true) {
            System.out.println("url:");
            String url=in.next();
            System.out.println("username:");
            String username=in.next();
            Info i=new Info(url,username,"");

            invoke(i);
            //进入睡眠
            // Thread.sleep(1000);


        }
    }

    //  jdbc:mysql://localhost:3306/haha

    public static void invoke(final Info info) {

        Thread thread=new Thread(new Runnable() {

            @Override
            public void run() {
                new BaseDao1().getAll(info.getUrl(),info.getUsername(),info.getPassword());
                System.out.println("success");
            }
        });
        thread.start();
        try {
            thread.join();
        } catch (InterruptedException e) {
            e.printStackTrace();
        }
    }

}

package cn.jjz.pojo;

public class Info {

	String url;
	String username;
	String password;
	
	
	
	
	public Info(String url, String username, String password) {
		super();
		this.url = url;
		this.username = username;
		this.password = password;
	}
	
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	
	
}