第一次结对作业

package dao;

import com.BaseBean;
import 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 = "地铁";
try {
String selectQuery = "SELECT * FROM basictable WHERE nam="+na;
db.rs =db.stmt.executeQuery(selectQuery);

if (db.rs.next()){
String base_name=db.rs.getString("line");
line += base_name;
line += "号线";
}

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

}
db.close();
return line;
}

}