java同时查询_java - 怎么同时查询100个 数据库 里面的同一个表名字的内容。...

怪我咯2017-04-18 09:51:075楼

没测试，你试试

public class Test100Conn {

static {

try {

Class.forName("com.mysql.jdbc.Driver");

}

catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

public static void main(String[] args) throws Throwable {

String f29 = "haha"; //或者其他类似条件？

String db ;

for (int i = 1; i <= 100; i++) {

if (i < 10) {

db = "00" + i;

}

else if (i >= 10 && i < 100) {

db = "0" + i;

}else{

db = "100";

}

Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.20.236:3306/express" + db, "root", "123456");

PreparedStatement stmt = conn.prepareStatement("select * from sf where f29=? or f30=? or f40=? or f41=?");

stmt.setString(1, "");//下面还有几个，这个1看你具体需求

ResultSet rs = stmt.executeQuery();

while(rs.next()){

System.out.println("这是第"+db+"个数据库开始");

if(rs.getString(1).equals(f29)){ //判断条件放在这里判断

System.out.println(rs.getString(1));

break;

}

System.out.println("这是第"+db+"个数据库结束");

}

rs.close();

stmt.close();

conn.close();

}

}

}