第一次结对作业

import main.java.com.BaseBean;
import main.java.com.DB;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;

public class Sub {

public BaseBean getStationByNum(int num) {

DB db = new DB();
BaseBean base = new BaseBean();

try {
String sql = "SELECT * FROM basictable WHERE num = " + num;
db.rs = db.stmt.executeQuery(sql);

if (db.rs.next()) {
base.base_id = db.rs.getString("id");
base.base_line = db.rs.getString("line");
base.base_num = db.rs.getInt("num");
base.base_name = db.rs.getString("nam");

}

} catch (SQLException e) {
e.printStackTrace();
} finally {

}
db.close();
return base;
}

public int getStationNum(String name) {

DB db = new DB();
BaseBean base = new BaseBean();

String na = "'" + name + "'";
try {
String selectQuery = "SELECT * FROM basictable WHERE nam=" + na;
db.rs = db.stmt.executeQuery(selectQuery);

if (db.rs.next()) {
base.base_id = db.rs.getString("id");
base.base_line = db.rs.getString("line");
base.base_num = db.rs.getInt("num");
base.base_name = db.rs.getString("nam");

}

} catch (SQLException e) {
e.printStackTrace();
} finally {

}
db.close();
return base.base_num;
}

public String StationLine(String lin) {

DB db = new DB();
String stat = "";
String li = "'" + lin + "'";
try {
String selectQuery = "SELECT * FROM basictable WHERE line=" + li;
db.rs = db.stmt.executeQuery(selectQuery);

while (db.rs.next()) {

String base_name = db.rs.getString("nam");

stat = stat + base_name;
stat += "--";

}

} catch (SQLException e) {
e.printStackTrace();
} finally {

}
db.close();
return stat;
}

public String LineStation(String name) {

DB db = new DB();
String na = "'" + name + "'";
// String line = "地铁";
String line = "";
try {
String selectQuery = "SELECT * FROM basictable WHERE nam=" + na;
db.rs = db.stmt.executeQuery(selectQuery);

while (db.rs.next()) {
String base_name = db.rs.getString("line");
line += "地铁";
line += base_name;
line += "号线,";
}

} catch (SQLException e) {
e.printStackTrace();
} finally {

}
db.close();
return line;
}

}