![](https://img2023.cnblogs.com/blog/2914723/202303/2914723-20230322205422110-312116706.jpg)
将上次的代码进行了通用化改编:
public String DaLaBengBaBanDeBeiDiBuDuoBiLuWeng (int a) throws Exception{
//将线路数改为列名
String x;
String sql = "select * from total ";
//查找该站点所在记录
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/subway";
String username = "root";
String Password = "Njx200259";
Connection connection = DriverManager.getConnection(url, username, Password);
java.sql.Statement stmt = connection.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData metadata=rs.getMetaData();
x=metadata.getColumnName(a);
return x;
}