交个java_交换乘算法 - java编程 - BlogJava

crossLine = new HashMap (

4, 0.8f);

// 把第一次要做到车次放如crossLine

crossLine.put("firstLine", mapStart.get("busLine"));

// 把要换乘的车次放入到crossLine

crossLine.put("secondLine", mapEnd.get("busLine"));

// 把中转站点放入到crossLine

crossLine.put("transferSta", mapEnd.get("up"));

// crossLine.put("transferSta",(String)startInf.get("up"));

// 将包含相交线路信息的HashMap存入List

// 也即是把具体某个换乘方法放入crossLineList

crossLineList.add(crossLine);

} else {

continue;

}

}

}

} else {

crossLineList = null;

}

return crossLineList;

}

private boolean IsInTheSameCity(String station1, String station2) {

if (station1.contains(station2) || station2.contains(station1)) {

// System.out.println(station1+"#########"+station2);

Connection con = null;

String url = "jdbc:mysql://127.0.0.1:3306/souwhat?autoReconnect=true&useUnicode=true&characterEncoding=GBK&mysqlEncoding=GBK";

String user = "root";

String psWord = "";

try {

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

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("The Exception at load the Driver");

}

try {

con = DriverManager.getConnection(url, user, psWord);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("The Exception at creat the connection");

}

return con;

}

private void closeConnection(Connection conn) throws Exception {

if (conn != null) {

conn.close();

}

}

private List executeQuery(String sql) throws Exception {

// System.out.println("executeQuery(sql): " + sql);

List list = new ArrayList();

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

conn = getConnection();

stmt = conn.createStatement();

System.out.println(sql);

rs = stmt.executeQuery(sql);

ResultSetMetaData rsmd = rs.getMetaData();

while (rs.next()) {

Map map = new HashMap();

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

// 每一行所有列存入HashMap中

map.put(rsmd.getColumnName(i), rs.getObject(i));

}

// 所有行存入List中

list.add(map);

}

} catch (Exception e) {

System.out.println("数据库查询出错!");

e.printStackTrace();

} finally {

if (rs != null)

rs.close();

closeConnection(conn);

}

return list;

}

}