package 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;
import org.omg.CORBA.portable.InvokeHandler;
public class BaseDao {
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 BaseDao().getAll(info.getUrl(),info.getUsername(),info.getPassword());
System.out.println("success");
}
});
thread.start();
try {
thread.join();
} catch (InterruptedException e) {
e.printStackTrace();
}
}
}