import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class Link {
static PreparedStatement preparedStatement = null;
static Connection connection = null;
public static List baseQuery(String sql, Object... args) {
List<Object> List = new ArrayList<>();
int length=args.length;
try {
//创建连接
Link.createLink();
Link.connection.setAutoCommit(false);
connection.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
preparedStatement.setObject(i + 1, args[i]);
}
ResultSet resultSet = preparedStatement.executeQuery();
//将数据加入到集合中,便于查询用ARRAYlIST接收
while (resultSet.next()) {
for (int i = 1; i <= args.length; i++) {
Object obj=resultSet.getObject(i);
}
Object obj = new Object(//参数怎么接收???);
List.add(obj);
}
if (!(List.size() == 0)) {
for (Object o : List
) {
System.out.println(o);
}
} else {
System.out.println("EMPTY DATA;");
}
} catch (Exception e1) {
e1.printStackTrace();
System.out.println("网络繁忙请稍后再试");
} finally {
if (null != Link.connection) {
try {
Link.connection.commit();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
//释放连接
closeLink(Link.connection);
}
//将数据加入到集合中,便于查询用ARRAYlIST接收
/**while (resultSet.next()) {
for (int i = 1; i <= args.length; i++) {
Object obj=resultSet.getObject(i);
}
Object obj = new Object(//参数怎么接收???);
List.add(obj);
}*/
//修改部分
if (resultSet.hasNext()) {
for (int i = 1; i <= args.length; i++) {
Object obj=resultSet.getObject(i);
}
} else {
System.out.println("EMPTY DATA;");
}
//或者修改为
while (resultSet.next()) {
for (int i = 1; i <= args.length; i++) {
Object obj=resultSet.getObject(i);
List.add(obj);
}
//Object obj = new Object(//参数怎么接收???);
//List.add(obj);
}
if (!(List.size() == 0)) {
for (Object o : List
) {
System.out.println(o);
}
} else {
System.out.println("EMPTY DATA;");
}
if (resultSet.hasNext()) {
//for (int i = 1; i <= args.length; i++) {
Object obj=resultSet.next();
//}
} else {
System.out.println("EMPTY DATA;");
}
我也不知道你查的是啥,你自己调试下object内容打出来