arraylist怎么在mysql中排序_如何实现对ArrayList排序 sort()

package com.collection;

import java.util.ArrayList;

import java.util.Collections;

import java.util.Comparator;

import java.util.List;

public class Test {

public static void main(String[] args) {

Student zlj = new Student("丁晓宇", 21);

Student dxy = new Student("赵四", 22);

Student cjc = new Student("张三", 11);

Student lgc = new Student("刘武", 19);

List studentList = new ArrayList();

studentList.add(zlj);

studentList.add(dxy);

studentList.add(cjc);

studentList.add(lgc);

System.out.println("按年龄升序:");

Collections.sort(studentList, new SortByAge());

for (Student student : studentList) {

System.out.println(student.getName() + " / " + student.getAge());

}

System.out.println();

System.out.println("按姓名排序:");

Collections.sort(studentList, new SortByName());

for (Student student : studentList) {

System.out.println(student.getName() + " / " + student.getAge());

}

}

}

class SortByAge implements Comparator {

public int compare(Object o1, Object o2) {

Student s1 = (Student) o1;

Student s2 = (Student) o2;

if (s1.getAge() > s2.getAge())

return 1;

return -1;

}

}

class SortByName implements Comparator {

public int compare(Object o1, Object o2) {

Student s1 = (Student) o1;

Student s2 = (Student) o2;

return s1.getName().compareTo(s2.getName());

}

}

输出结果:

按年龄升序:

张三 / 11

刘武 / 19

丁晓宇 / 21

赵四 / 22

按姓名排序:

丁晓宇 / 21

刘武 / 19

张三 / 11

赵四 / 22

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
以下是Java连接数据库查询使用Arrays.sort数组排序得匿名内部类对相同得查询语句进行封装使用list集合的示例代码: ```java import java.sql.*; import java.util.*; public class DatabaseQuery { private Connection conn; private PreparedStatement pstmt; public DatabaseQuery() { // 连接数据库 try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test"; String username = "root"; String password = "password"; conn = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } public List<Map<String, Object>> executeQuery(String sql, Object[] params) throws SQLException { List<Map<String, Object>> list = new ArrayList<>(); pstmt = conn.prepareStatement(sql); if (params != null) { for (int i = 0; i < params.length; i++) { pstmt.setObject(i + 1, params[i]); } } ResultSet rs = pstmt.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); int columnCount = rsmd.getColumnCount(); while (rs.next()) { Map<String, Object> map = new HashMap<>(); for (int i = 1; i <= columnCount; i++) { map.put(rsmd.getColumnName(i), rs.getObject(i)); } list.add(map); } rs.close(); pstmt.close(); return list; } public List<Map<String, Object>> executeQuery(String sql, Object[] params, String[] orderColumns) throws SQLException { List<Map<String, Object>> list = executeQuery(sql, params); if (orderColumns != null) { Arrays.sort(orderColumns, new Comparator<String>() { @Override public int compare(String o1, String o2) { return o1.compareToIgnoreCase(o2); } }); list.sort(new Comparator<Map<String, Object>>() { @Override public int compare(Map<String, Object> o1, Map<String, Object> o2) { for (String column : orderColumns) { Object value1 = o1.get(column); Object value2 = o2.get(column); if (value1 == null && value2 == null) { continue; } else if (value1 == null) { return -1; } else if (value2 == null) { return 1; } else { int compareResult = ((Comparable) value1).compareTo(value2); if (compareResult != 0) { return compareResult; } } } return 0; } }); } return list; } public void close() throws SQLException { conn.close(); } public static void main(String[] args) throws SQLException { DatabaseQuery dbQuery = new DatabaseQuery(); String sql = "SELECT * FROM table_name WHERE column1=? AND column2=?"; Object[] params = {value1, value2}; String[] orderColumns = {"column1", "column2"}; List<Map<String, Object>> list = dbQuery.executeQuery(sql, params, orderColumns); for (Map<String, Object> map : list) { System.out.println(map); } dbQuery.close(); } } ``` 在该示例代码,`DatabaseQuery` 类封装了对数据库的查询操作。`executeQuery` 方法可以执行一条查询语句并返回一个包含多个 `Map` 对象的 `List`,每个 `Map` 对象表示一行查询结果,键为列名,值为列值。如果需要对结果进行排序,可以在调用 `executeQuery` 方法时传入 `orderColumns` 参数,该参数为一个 `String` 数组,表示需要按照哪些列进行排序。在该示例代码,使用了匿名内部类对 `orderColumns` 数组进行排序,然后再对查询结果进行排序
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值