第七周总结

结对开发项目--结对开发（石家庄地铁路线图）

　　

1 package com.sub.servlet;
2
3 import java.io.IOException;
4 import java.sql.Connection;
5 import java.sql.DriverManager;
6 import java.sql.ResultSet;
7 import java.sql.Statement;
8 import java.util.ArrayList;
9 import java.util.List;
10
11 import javax.servlet.ServletException;
12 import javax.servlet.annotation.WebServlet;
13 import javax.servlet.http.HttpServlet;
14 import javax.servlet.http.HttpServletRequest;
15 import javax.servlet.http.HttpServletResponse;
16 import com.sub.entity.subway;
17 import com.sub.dao.Dao;
18 /**
19 * Servlet implementation class Servlet
20 */
21 @WebServlet("/Servlet")
22 public class Servlet extends HttpServlet {
23 private static final long serialVersionUID = 1L;
24 Dao dao=new Dao();
25 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
26 request.setCharacterEncoding("utf-8");
27 String method = request.getParameter("method");
28
29 if ("chaxun".equals(method)) {
30 chaxun(request, response);
31 }
32 }
33 private void chaxun(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
34 String start=request.getParameter("start");
35 String end=request.getParameter("end");
36 int a[]=new int[2];
37 int b[]=new int[2];
38 int k[]=new int[4];
39 a=dao.getLineshuzu(start);
40 b=dao.getLineshuzu(end);
41 if((dao.site(start)||dao.site2(start)||dao.site3(start)||dao.site4(start)||dao.site5(start)||dao.site6(start))&&((dao.site(end)||dao.site2(end)||dao.site3(end)||dao.site4(end)||dao.site5(end)||dao.site6(end))))
42 {
43 if(((dao.getSum(start)>1&&dao.getSum(end)==1)||(dao.getSum(start)==1&&dao.getSum(end)>1)||(dao.getSum(start)>1&&dao.getSum(end)>1))&&((a[0]!=b[0])&&(a[0]!=b[1])&&(a[1]!=b[0])&&(a[1]!=b[1])))
44 {
45 String route="";
46 int []temp=new int[4];
47 int temp1=0;
48 temp[0]=0;temp[1]=1;temp[2]=2;temp[3]=3;
49 k[0]=a[0];k[1]=a[1];k[2]=b[0];k[3]=b[1];
50 System.out.println(k[0]+","+k[1]+","+k[2]+","+k[3]);
51 String a1=dao.getdouble(k[0], k[2]);
52 String b1=dao.getdouble(k[0], k[3]);
53 String c1=dao.getdouble(k[1], k[2]);
54 String d1=dao.getdouble(k[1], k[3]);
55 System.out.println(a1+","+b1+","+c1+","+d1);
56 if(k[0]!=0&&k[2]!=0)
57 {if(temp[temp1]==0)
58 {
59 System.out.println("");
60 System.out.println("----------------线路Ⅰ:----------------");
61 route=route+"-----线路Ⅰ:";
62 }
63 if(temp[temp1]==1)
64 {
65 System.out.println("");
66 System.out.println("----------------线路Ⅱ:----------------");
67 route=route+"-----线路Ⅱ:";
68 }
69 if(temp[temp1]==2)
70 {
71 System.out.println("");
72 System.out.println("----------------线路Ⅲ:----------------");
73 route=route+"-----线路Ⅲ:";
74 }
75 if(temp[temp1]==3)
76 {
77 System.out.println("");
78 System.out.println("----------------线路Ⅳ:----------------");
79 route=route+"-----线路Ⅳ:";
80 }
81 route=route+dao.getdoublesite(k[0], k[2], start, end);
82 temp1++;
83 }//0-2
84 if(k[0]!=0&&k[3]!=0)
85 {if(temp[temp1]==0)
86 {
87 System.out.println("");
88 System.out.println("----------------线路Ⅰ:----------------");
89 route=route+"-----线路Ⅰ:";
90 }
91 if(temp[temp1]==1)
92 {
93 System.out.println("");
94 System.out.println("----------------线路Ⅱ:----------------");
95 route=route+"-----线路Ⅱ:";
96 }
97 if(temp[temp1]==2)
98 {
99 System.out.println("");
100 System.out.println("----------------线路Ⅲ:----------------");
101 route=route+"-----线路Ⅲ:";
102 }
103 if(temp[temp1]==3)
104 {
105 System.out.println("");
106 System.out.println("----------------线路Ⅳ:----------------");
107 route=route+"-----线路Ⅳ:";
108 }
109 route=route+dao.getdoublesite(k[0], k[3], start, end);
110 temp1++;
111 }//0-3
112 if(k[1]!=0&&k[2]!=0)
113 {if(temp[temp1]==0)
114 {
115 System.out.println("");
116 System.out.println("----------------线路Ⅰ:----------------");
117 route=route+"-----线路Ⅰ:";
118 }
119 if(temp[temp1]==1)
120 {
121 System.out.println("");
122 System.out.println("----------------线路Ⅱ:----------------");
123 route=route+"-----线路Ⅱ:";
124 }
125 if(temp[temp1]==2)
126 {
127 System.out.println("");
128 System.out.println("----------------线路Ⅲ:----------------");
129 route=route+"-----线路Ⅲ:";
130 }
131 if(temp[temp1]==3)
132 {
133 System.out.println("");
134 System.out.println("----------------线路Ⅳ:----------------");
135 route=route+"-----线路Ⅳ:";
136 }
137 route=route+dao.getdoublesite(k[1], k[2], start, end);
138 temp1++;
139 }//1-2
140 if(k[1]!=0&&k[3]!=0)
141 {if(temp[temp1]==0)
142 {
143 System.out.println("");
144 System.out.println("----------------线路Ⅰ:----------------");
145 route=route+"-----线路Ⅰ:";
146 }
147 if(temp[temp1]==1)
148 {
149 System.out.println("");
150 System.out.println("----------------线路Ⅱ:----------------");
151 route=route+"-----线路Ⅱ:";
152 }
153 if(temp[temp1]==2)
154 {
155 System.out.println("");
156 System.out.println("----------------线路Ⅲ:----------------");
157 route=route+"-----线路Ⅲ:";
158 }
159 if(temp[temp1]==3)
160 {
161 System.out.println("");
162 System.out.println("----------------线路Ⅳ:----------------");
163 route=route+"-----线路Ⅳ:";
164 }
165 route=route+dao.getdoublesite(k[1], k[3], start, end);
166 temp1++;
167 }//1-3
168 request.setAttribute("data",route );
169 request.getRequestDispatcher("Query1.jsp").forward(request, response);
170 }
171 if((dao.getSum(start)>1||dao.getSum(end)>1)&&((a[0]==b[0])||(a[0]==b[1])||(a[1]==b[0])||(a[1]==b[1])))
172 {
173 String route="";
174 System.out.println(a[0]+","+a[1]+","+b[0]+","+b[1]);
175 if(a[0]==b[0])
176 {
177 route=dao.getjkl(a[0], start, end);
178 }
179 if(a[0]==b[1])
180 {
181 route=dao.getjkl(a[0], start, end);
182 }
183 if(a[1]==b[0])
184 {
185 route=dao.getjkl(a[1], start, end);
186 }
187 if(a[1]==b[1])
188 {
189 route=dao.getjkl(a[1], start, end);
190 }
191 request.setAttribute("data",route );
192 request.getRequestDispatcher("Query1.jsp").forward(request, response);
193 }
194 if(dao.site(start)&&dao.site(end)&&(dao.getLine(start)==1)&&(dao.getLine(end)==1)&&dao.getSum(start)==1&&dao.getSum(end)==1)
195 {
196 int num1=dao.getNum(start);
197 int num2=dao.getNum(end);
198 if(num1<=num2)
199 {
200 String line1=dao.getSiter1(num1, num2);
201 System.out.println("路线为:"+line1);
202 String route="路线为:"+line1;
203 request.setAttribute("data",route );
204 request.getRequestDispatcher("Query1.jsp").forward(request, response);
205 }
206 if(num1>num2)
207 {
208 String line2=dao.getSitek1(num1, num2);
209 System.out.println("路线为:"+line2);
210 String route="路线为:"+line2;
211 request.setAttribute("data",route );
212 request.getRequestDispatcher("Query1.jsp").forward(request, response);
213 }
214 }//两站都在一号线
215 if(dao.site2(start)&&dao.site2(end)&&(dao.getLine(start)==2)&&(dao.getLine(end)==2)&&dao.getSum(start)==1&&dao.getSum(end)==1)
216 {
217 int num1=dao.getNum2(start);
218 int num2=dao.getNum2(end);
219 if(num1<=num2)
220 {
221 String line1=dao.getSiter2(num1, num2);
222 System.out.println("路线为:"+line1);
223 String route="路线为:"+line1;
224 request.setAttribute("data",route);
225 request.getRequestDispatcher("Query1.jsp").forward(request, response);
226 }
227 if(num1>num2)
228 {
229 String line2=dao.getSitek2(num1, num2);
230 System.out.println("路线为:"+line2);
231 String route="路线为:"+line2;
232 request.setAttribute("data",route );
233 request.getRequestDispatcher("Query1.jsp").forward(request, response);
234 }
235 }//两站都在二号线
236 if(dao.site3(start)&&dao.site3(end)&&(dao.getLine(start)==3)&&(dao.getLine(end)==3)&&dao.getSum(start)==1&&dao.getSum(end)==1)
237 {
238 int num1=dao.getNum3(start);
239 int num2=dao.getNum3(end);
240 if(num1<=num2)
241 {
242 String line1=dao.getSiter3(num1, num2);
243 System.out.println("路线为:"+line1);
244 String route="路线为:"+line1;
245 request.setAttribute("data",route );
246 request.getRequestDispatcher("Query1.jsp").forward(request, response);
247 }
248 if(num1>num2)
249 {
250 String line2=dao.getSitek3(num1, num2);
251 System.out.println("路线为:"+line2);
252 String route="路线为:"+line2;
253 request.setAttribute("data",route );
254 request.getRequestDispatcher("Query1.jsp").forward(request, response);
255 }
256 }//两站都在三号线
257 if(dao.site4(start)&&dao.site4(end)&&(dao.getLine(start)==4)&&(dao.getLine(end)==4)&&dao.getSum(start)==1&&dao.getSum(end)==1)
258 {
259 int num1=dao.getNum4(start);
260 int num2=dao.getNum4(end);
261 if(num1<=num2)
262 {
263 String line1=dao.getSiter4(num1, num2);
264 System.out.println("路线为:"+line1);
265 String route="路线为:"+line1;
266 request.setAttribute("data",route );
267 request.getRequestDispatcher("Query1.jsp").forward(request, response);
268 }
269 if(num1>num2)
270 {
271 String line2=dao.getSitek4(num1, num2);
272 System.out.println("路线为:"+line2);
273 String route="路线为:"+line2;
274 request.setAttribute("data",route );
275 request.getRequestDispatcher("Query1.jsp").forward(request, response);
276 }
277 }//两站都在四号线
278 if(dao.site5(start)&&dao.site5(end)&&(dao.getLine(start)==5)&&(dao.getLine(end)==5)&&dao.getSum(start)==1&&dao.getSum(end)==1)
279 {
280 int num1=dao.getNum5(start);
281 int num2=dao.getNum5(end);
282 if(num1<=num2)
283 {
284 String line1=dao.getSiter5(num1, num2);
285 System.out.println("路线为:"+line1);
286 String route="路线为:"+line1;
287 request.setAttribute("data",route );
288 request.getRequestDispatcher("Query1.jsp").forward(request, response);
289 }
290 if(num1>num2)
291 {
292 String line2=dao.getSitek5(num1, num2);
293 System.out.println("路线为:"+line2);
294 String route="路线为:"+line2;
295 request.setAttribute("data",route );
296 request.getRequestDispatcher("Query1.jsp").forward(request, response);
297 }
298 }//两站都在五号线
299 if(dao.site6(start)&&dao.site6(end)&&(dao.getLine(start)==6)&&(dao.getLine(end)==6)&&dao.getSum(start)==1&&dao.getSum(end)==1)
300 {
301 int num1=dao.getNum6(start);
302 int num2=dao.getNum6(end);
303 if(num1<=num2)
304 {
305 String line1=dao.getSiter6(num1, num2);
306 System.out.println("路线为:"+line1);
307 String route="路线为:"+line1;
308 request.setAttribute("data",route );
309 request.getRequestDispatcher("Query1.jsp").forward(request, response);
310 }
311 if(num1>num2)
312 {
313 String line2=dao.getSitek6(num1, num2);
314 System.out.println("路线为:"+line2);
315 String route="路线为:"+line2;
316 request.setAttribute("data",route );
317 request.getRequestDispatcher("Query1.jsp").forward(request, response);
318 }
319 }//两站都在六号线
320 if(a[1]==0&&b[1]==0&&a[0]!=b[0]&&dao.getSum(start)==1&&dao.getSum(end)==1)//所有换乘(不包括任意换乘点)
321 {
322 String route="";
323 int []d=new int[4];
324 String []c=new String[2];
325 System.out.println(a[0]+","+b[0]);
326 c=dao.getgline(a, b);
327 d=dao.getviewnum(a, b, c, start, end);
328 route=dao.getview(a, b, d[0], d[2],d[1],d[3]);
329 if(c[1]!="")
330 {
331 String route1="";
332 System.out.println("");
333 System.out.print("第二条路线:");
334 c=dao.getgline(a, b);
335 d=dao.getviewnum1(a, b, c, start, end);
336 route=route+"**********";
337 route1=dao.getview(a, b, d[0], d[2],d[1],d[3]);
338 route=route+"第二条路线:"+route1;
339 }
340 request.setAttribute("data",route );
341 request.getRequestDispatcher("Query1.jsp").forward(request, response);
342 }
343 }
344 else
345 {
346 request.setAttribute("data","输入站点有误！" );
347 request.getRequestDispatcher("Query1.jsp").forward(request, response);
348 }
349 }
350 }
servlet.java

1 Hauncheng.java
2
3 package com.sub.entity;
4
5 public class huancheng {
6 private int first;
7 private int sec;
8 private String site;
9 public int getFirst() {
10 return first;
11 }
12 public void setFirst(int first) {
13 this.first = first;
14 }
15 public int getSec() {
16 return sec;
17 }
18 public void setSec(int sec) {
19 this.sec = sec;
20 }
21 public String getSite() {
22 return site;
23 }
24 public void setSite(String site) {
25 this.site = site;
26 }
27
28 }

huancheng.java

1 package com.sub.entity;
2 /**
3 *
4 * @author lenovo
5 *
6 */
7 public class subway {
8 private int line;
9 private int num;
10 private String site;
11 public int getLine() {
12 return line;
13 }
14 public void setLine(int line) {
15 this.line = line;
16 }
17 public int getNum() {
18 return num;
19 }
20 public void setNum(int num) {
21 this.num = num;
22 }
23 public String getSite() {
24 return site;
25 }
26 public void setSite(String site) {
27 this.site = site;
28 }
29 }

subway.java

1 package com.sub.DBUtil;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.ResultSet;
6 import java.sql.SQLException;
7 import java.sql.Statement;
8
9 public class DBUtil {
10 public static String db_url = "jdbc:mysql://localhost:3306/subway";
11 public static String db_user = "root";
12 public static String db_pass = "20173673";
13
14 public static Connection getConn () {
15 Connection conn = null;
16
17 try {
18 Class.forName("com.mysql.jdbc.Driver");//加载驱动
19 conn = DriverManager.getConnection(db_url, db_user, db_pass);
20 } catch (Exception e) {
21 e.printStackTrace();
22 }
23
24 return conn;
25 }
26
27 /**
28 * 关闭连接
29 * @param state
30 * @param conn
31 */
32 public static void close (Statement state, Connection conn) {
33 if (state != null) {
34 try {
35 state.close();
36 } catch (SQLException e) {
37 e.printStackTrace();
38 }
39 }
40
41 if (conn != null) {
42 try {
43 conn.close();
44 } catch (SQLException e) {
45 e.printStackTrace();
46 }
47 }
48 }
49
50 public static void close (ResultSet rs, Statement state, Connection conn) {
51 if (rs != null) {
52 try {
53 rs.close();
54 } catch (SQLException e) {
55 e.printStackTrace();
56 }
57 }
58
59 if (state != null) {
60 try {
61 state.close();
62 } catch (SQLException e) {
63 e.printStackTrace();
64 }
65 }
66
67 if (conn != null) {
68 try {
69 conn.close();
70 } catch (SQLException e) {
71 e.printStackTrace();
72 }
73 }
74 }
75 }

DBUtil.java

1 package com.sub.dao;
2 import java.sql.Connection;
3 import java.sql.ResultSet;
4 import java.sql.SQLException;
5 import java.sql.Statement;
6 import java.util.ArrayList;
7 import java.util.List;
8
9 import com.sub.DBUtil.*;
10 import com.sub.entity.*;
11 public class Dao {
12 public boolean site(String site) {//在一号线中查看是否存在该站
13 boolean flag = false;
14 String sql = "select site from station where site = '" + site + "'";
15 Connection conn = DBUtil.getConn();
16 Statement state = null;
17 ResultSet rs = null;
18
19 try {
20 state = conn.createStatement();
21 rs = state.executeQuery(sql);
22 while (rs.next()) {
23 flag = true;
24 }
25 } catch (SQLException e) {
26 e.printStackTrace();
27 } finally {
28 DBUtil.close(rs, state, conn);
29 }
30 return flag;
31 }
32 public boolean site2(String site) {//在二号线中查看是否存在该站
33 boolean flag = false;
34 String sql = "select site from station2 where site = '" + site + "'";
35 Connection conn = DBUtil.getConn();
36 Statement state = null;
37 ResultSet rs = null;
38
39 try {
40 state = conn.createStatement();
41 rs = state.executeQuery(sql);
42 while (rs.next()) {
43 flag = true;
44 }
45 } catch (SQLException e) {
46 e.printStackTrace();
47 } finally {
48 DBUtil.close(rs, state, conn);
49 }
50 return flag;
51 }
52 public boolean site3(String site) {//在三号线中查看是否存在该站
53 boolean flag = false;
54 String sql = "select site from station3 where site = '" + site + "'";
55 Connection conn = DBUtil.getConn();
56 Statement state = null;
57 ResultSet rs = null;
58
59 try {
60 state = conn.createStatement();
61 rs = state.executeQuery(sql);
62 while (rs.next()) {
63 flag = true;
64 }
65 } catch (SQLException e) {
66 e.printStackTrace();
67 } finally {
68 DBUtil.close(rs, state, conn);
69 }
70 return flag;
71 }
72 public boolean site4(String site) {//在四号线中查看是否存在该站
73 boolean flag = false;
74 String sql = "select site from station4 where site = '" + site + "'";
75 Connection conn = DBUtil.getConn();
76 Statement state = null;
77 ResultSet rs = null;
78
79 try {
80 state = conn.createStatement();
81 rs = state.executeQuery(sql);
82 while (rs.next()) {
83 flag = true;
84 }
85 } catch (SQLException e) {
86 e.printStackTrace();
87 } finally {
88 DBUtil.close(rs, state, conn);
89 }
90 return flag;
91 }
92 public boolean site5(String site) {//在五号线中查看是否存在该站
93 boolean flag = false;
94 String sql = "select site from station5 where site = '" + site + "'";
95 Connection conn = DBUtil.getConn();
96 Statement state = null;
97 ResultSet rs = null;
98
99 try {
100 state = conn.createStatement();
101 rs = state.executeQuery(sql);
102 while (rs.next()) {
103 flag = true;
104 }
105 } catch (SQLException e) {
106 e.printStackTrace();
107 } finally {
108 DBUtil.close(rs, state, conn);
109 }
110 return flag;
111 }
112 public boolean site6(String site) {//在六号线中查看是否存在该站
113 boolean flag = false;
114 String sql = "select site from station6 where site = '" + site + "'";
115 Connection conn = DBUtil.getConn();
116 Statement state = null;
117 ResultSet rs = null;
118
119 try {
120 state = conn.createStatement();
121 rs = state.executeQuery(sql);
122 while (rs.next()) {
123 flag = true;
124 }
125 } catch (SQLException e) {
126 e.printStackTrace();
127 } finally {
128 DBUtil.close(rs, state, conn);
129 }
130 return flag;
131 }
132
133 public int getNum(String site) {//在一号线中查找编号
134 int num=0;
135 String sql = "select * from station";
136 Connection conn = DBUtil.getConn();
137 Statement state = null;
138 ResultSet rs = null;
139 try {
140 state = conn.createStatement();
141 rs = state.executeQuery(sql);
142 List<subway> list = new ArrayList<subway>();
143 while (rs.next()) {
144 subway s=new subway();
145 s.setSite(rs.getString("site"));
146 s.setNum(rs.getInt("num"));
147 if(s.getSite().equals(site))
148 {
149 num=s.getNum();
150 }
151 }
152 } catch (Exception e) {
153 e.printStackTrace();
154 } finally {
155 DBUtil.close(rs, state, conn);
156 }
157
158 return num;
159 }
160 public int getNum2(String site) {//在二号线中查找编号
161 int num=0;
162 String sql = "select * from station2";
163 Connection conn = DBUtil.getConn();
164 Statement state = null;
165 ResultSet rs = null;
166 try {
167 state = conn.createStatement();
168 rs = state.executeQuery(sql);
169 List<subway> list = new ArrayList<subway>();
170 while (rs.next()) {
171 subway s=new subway();
172 s.setSite(rs.getString("site"));
173 s.setNum(rs.getInt("num"));
174 if(s.getSite().equals(site))
175 {
176 num=s.getNum();
177 }
178 }
179 } catch (Exception e) {
180 e.printStackTrace();
181 } finally {
182 DBUtil.close(rs, state, conn);
183 }
184
185 return num;
186 }
187 public int getNum3(String site) {//在三号线中查找编号
188 int num=0;
189 String sql = "select * from station3";
190 Connection conn = DBUtil.getConn();
191 Statement state = null;
192 ResultSet rs = null;
193 try {
194 state = conn.createStatement();
195 rs = state.executeQuery(sql);
196 List<subway> list = new ArrayList<subway>();
197 while (rs.next()) {
198 subway s=new subway();
199 s.setSite(rs.getString("site"));
200 s.setNum(rs.getInt("num"));
201 if(s.getSite().equals(site))
202 {
203 num=s.getNum();
204 }
205 }
206 } catch (Exception e) {
207 e.printStackTrace();
208 } finally {
209 DBUtil.close(rs, state, conn);
210 }
211
212 return num;
213 }
214 public int getNum4(String site) {//在四号线中查找编号
215 int num=0;
216 String sql = "select * from station4";
217 Connection conn = DBUtil.getConn();
218 Statement state = null;
219 ResultSet rs = null;
220 try {
221 state = conn.createStatement();
222 rs = state.executeQuery(sql);
223 List<subway> list = new ArrayList<subway>();
224 while (rs.next()) {
225 subway s=new subway();
226 s.setSite(rs.getString("site"));
227 s.setNum(rs.getInt("num"));
228 if(s.getSite().equals(site))
229 {
230 num=s.getNum();
231 }
232 }
233 } catch (Exception e) {
234 e.printStackTrace();
235 } finally {
236 DBUtil.close(rs, state, conn);
237 }
238
239 return num;
240 }
241 public int getNum5(String site) {//在五号线中查找编号
242 int num=0;
243 String sql = "select * from station5";
244 Connection conn = DBUtil.getConn();
245 Statement state = null;
246 ResultSet rs = null;
247 try {
248 state = conn.createStatement();
249 rs = state.executeQuery(sql);
250 List<subway> list = new ArrayList<subway>();
251 while (rs.next()) {
252 subway s=new subway();
253 s.setSite(rs.getString("site"));
254 s.setNum(rs.getInt("num"));
255 if(s.getSite().equals(site))
256 {
257 num=s.getNum();
258 }
259 }
260 } catch (Exception e) {
261 e.printStackTrace();
262 } finally {
263 DBUtil.close(rs, state, conn);
264 }
265
266 return num;
267 }
268 public int getNum6(String site) {//在六号线中查找编号
269 int num=0;
270 String sql = "select * from station6";
271 Connection conn = DBUtil.getConn();
272 Statement state = null;
273 ResultSet rs = null;
274 try {
275 state = conn.createStatement();
276 rs = state.executeQuery(sql);
277 List<subway> list = new ArrayList<subway>();
278 while (rs.next()) {
279 subway s=new subway();
280 s.setSite(rs.getString("site"));
281 s.setNum(rs.getInt("num"));
282 if(s.getSite().equals(site))
283 {
284 num=s.getNum();
285 }
286 }
287 } catch (Exception e) {
288 e.printStackTrace();
289 } finally {
290 DBUtil.close(rs, state, conn);
291 }
292
293 return num;
294 }
295
296 public String getSiter1(int num1,int num2) {//一号线求路线
297 String line1="";
298 String sql = "select * from station";
299 Connection conn = DBUtil.getConn();
300 Statement state = null;
301 ResultSet rs = null;
302 try {
303 state = conn.createStatement();
304 rs = state.executeQuery(sql);
305 List<subway> list = new ArrayList<subway>();
306 while (rs.next()) {
307 subway s=new subway();
308 s.setSite(rs.getString("site"));
309 s.setNum(rs.getInt("num"));
310 if(s.getNum()>=num1&&s.getNum()<=num2)
311 {
312 if(s.getNum()!=num2)
313 line1=line1+s.getSite()+"->";
314 if(s.getNum()==num2)
315 {
316 line1=line1+s.getSite();
317 }
318 }
319 }
320 } catch (Exception e) {
321 e.printStackTrace();
322 } finally {
323 DBUtil.close(rs, state, conn);
324 }
325
326 return line1;
327 }
328 public String getSitek1(int num1,int num2) {//一号线求路线
329 String []a=new String[num1-num2+1];
330 String line2="";
331 String sql = "select * from station";
332 Connection conn = DBUtil.getConn();
333 Statement state = null;
334 ResultSet rs = null;
335 int i=0;
336 try {
337 state = conn.createStatement();
338 rs = state.executeQuery(sql);
339 List<subway> list = new ArrayList<subway>();
340 while (rs.next()) {
341 subway s=new subway();
342 s.setSite(rs.getString("site"));
343 s.setNum(rs.getInt("num"));
344 if(s.getNum()>=num2&&s.getNum()<=num1)
345 {
346 if(s.getNum()==num2)
347 {
348 a[i]=s.getSite();
349 i++;
350 }
351 if(s.getNum()!=num2)
352 {
353 a[i]=s.getSite()+"->";
354 i++;
355 }
356 }
357 }
358 } catch (Exception e) {
359 e.printStackTrace();
360 } finally {
361 DBUtil.close(rs, state, conn);
362 }
363 for(int j=num1-num2;j>=0;j--)
364 {
365 line2=line2+a[j];
366 }
367 return line2;
368 }
369 public String getSiter2(int num1,int num2) {//二号线求路线
370 String line1="";
371 String sql = "select * from station2";
372 Connection conn = DBUtil.getConn();
373 Statement state = null;
374 ResultSet rs = null;
375 try {
376 state = conn.createStatement();
377 rs = state.executeQuery(sql);
378 List<subway> list = new ArrayList<subway>();
379 while (rs.next()) {
380 subway s=new subway();
381 s.setSite(rs.getString("site"));
382 s.setNum(rs.getInt("num"));
383 if(s.getNum()>=num1&&s.getNum()<=num2)
384 {
385 if(s.getNum()!=num2)
386 line1=line1+s.getSite()+"->";
387 if(s.getNum()==num2)
388 {
389 line1=line1+s.getSite();
390 }
391 }
392 }
393 } catch (Exception e) {
394 e.printStackTrace();
395 } finally {
396 DBUtil.close(rs, state, conn);
397 }
398
399 return line1;
400 }
401 public String getSitek2(int num1,int num2) {//二号线求路线
402 String []a=new String[num1-num2+1];
403 String line2="";
404 String sql = "select * from station2";
405 Connection conn = DBUtil.getConn();
406 Statement state = null;
407 ResultSet rs = null;
408 int i=0;
409 try {
410 state = conn.createStatement();
411 rs = state.executeQuery(sql);
412 List<subway> list = new ArrayList<subway>();
413 while (rs.next()) {
414 subway s=new subway();
415 s.setSite(rs.getString("site"));
416 s.setNum(rs.getInt("num"));
417 if(s.getNum()>=num2&&s.getNum()<=num1)
418 {
419 if(s.getNum()==num2)
420 {
421 a[i]=s.getSite();
422 i++;
423 }
424 if(s.getNum()!=num2)
425 {
426 a[i]=s.getSite()+"->";
427 i++;
428 }
429 }
430 }
431 } catch (Exception e) {
432 e.printStackTrace();
433 } finally {
434 DBUtil.close(rs, state, conn);
435 }
436 for(int j=num1-num2;j>=0;j--)
437 {
438 line2=line2+a[j];
439 }
440 return line2;
441 }
442
443 public String getSiter3(int num1,int num2) {//三号线求路线
444 String line1="";
445 String sql = "select * from station3";
446 Connection conn = DBUtil.getConn();
447 Statement state = null;
448 ResultSet rs = null;
449 try {
450 state = conn.createStatement();
451 rs = state.executeQuery(sql);
452 List<subway> list = new ArrayList<subway>();
453 while (rs.next()) {
454 subway s=new subway();
455 s.setSite(rs.getString("site"));
456 s.setNum(rs.getInt("num"));
457 if(s.getNum()>=num1&&s.getNum()<=num2)
458 {
459 if(s.getNum()!=num2)
460 line1=line1+s.getSite()+"->";
461 if(s.getNum()==num2)
462 {
463 line1=line1+s.getSite();
464 }
465 }
466 }
467 } catch (Exception e) {
468 e.printStackTrace();
469 } finally {
470 DBUtil.close(rs, state, conn);
471 }
472
473 return line1;
474 }
475 public String getSitek3(int num1,int num2) {//三号线求路线
476 String []a=new String[num1-num2+1];
477 String line2="";
478 String sql = "select * from station3";
479 Connection conn = DBUtil.getConn();
480 Statement state = null;
481 ResultSet rs = null;
482 int i=0;
483 try {
484 state = conn.createStatement();
485 rs = state.executeQuery(sql);
486 List<subway> list = new ArrayList<subway>();
487 while (rs.next()) {
488 subway s=new subway();
489 s.setSite(rs.getString("site"));
490 s.setNum(rs.getInt("num"));
491 if(s.getNum()>=num2&&s.getNum()<=num1)
492 {
493 if(s.getNum()==num2)
494 {
495 a[i]=s.getSite();
496 i++;
497 }
498 if(s.getNum()!=num2)
499 {
500 a[i]=s.getSite()+"->";
501 i++;
502 }
503 }
504 }
505 } catch (Exception e) {
506 e.printStackTrace();
507 } finally {
508 DBUtil.close(rs, state, conn);
509 }
510 for(int j=num1-num2;j>=0;j--)
511 {
512 line2=line2+a[j];
513 }
514 return line2;
515 }
516
517 public String getSiter4(int num1,int num2) {//四号线求路线
518 String line1="";
519 String sql = "select * from station4";
520 Connection conn = DBUtil.getConn();
521 Statement state = null;
522 ResultSet rs = null;
523 try {
524 state = conn.createStatement();
525 rs = state.executeQuery(sql);
526 List<subway> list = new ArrayList<subway>();
527 while (rs.next()) {
528 subway s=new subway();
529 s.setSite(rs.getString("site"));
530 s.setNum(rs.getInt("num"));
531 if(s.getNum()>=num1&&s.getNum()<=num2)
532 {
533 if(s.getNum()!=num2)
534 line1=line1+s.getSite()+"->";
535 if(s.getNum()==num2)
536 {
537 line1=line1+s.getSite();
538 }
539 }
540 }
541 } catch (Exception e) {
542 e.printStackTrace();
543 } finally {
544 DBUtil.close(rs, state, conn);
545 }
546
547 return line1;
548 }
549 public String getSitek4(int num1,int num2) {//四号线求路线
550 String []a=new String[num1-num2+1];
551 String line2="";
552 String sql = "select * from station4";
553 Connection conn = DBUtil.getConn();
554 Statement state = null;
555 ResultSet rs = null;
556 int i=0;
557 try {
558 state = conn.createStatement();
559 rs = state.executeQuery(sql);
560 List<subway> list = new ArrayList<subway>();
561 while (rs.next()) {
562 subway s=new subway();
563 s.setSite(rs.getString("site"));
564 s.setNum(rs.getInt("num"));
565 if(s.getNum()>=num2&&s.getNum()<=num1)
566 {
567 if(s.getNum()==num2)
568 {
569 a[i]=s.getSite();
570 i++;
571 }
572 if(s.getNum()!=num2)
573 {
574 a[i]=s.getSite()+"->";
575 i++;
576 }
577 }
578 }
579 } catch (Exception e) {
580 e.printStackTrace();
581 } finally {
582 DBUtil.close(rs, state, conn);
583 }
584 for(int j=num1-num2;j>=0;j--)
585 {
586 line2=line2+a[j];
587 }
588 return line2;
589 }
590
591 public String getSiter5(int num1,int num2) {//五号线求路线
592 String line1="";
593 String sql = "select * from station5";
594 Connection conn = DBUtil.getConn();
595 Statement state = null;
596 ResultSet rs = null;
597 try {
598 state = conn.createStatement();
599 rs = state.executeQuery(sql);
600 List<subway> list = new ArrayList<subway>();
601 while (rs.next()) {
602 subway s=new subway();
603 s.setSite(rs.getString("site"));
604 s.setNum(rs.getInt("num"));
605 if(s.getNum()>=num1&&s.getNum()<=num2)
606 {
607 if(s.getNum()!=num2)
608 line1=line1+s.getSite()+"->";
609 if(s.getNum()==num2)
610 {
611 line1=line1+s.getSite();
612 }
613 }
614 }
615 } catch (Exception e) {
616 e.printStackTrace();
617 } finally {
618 DBUtil.close(rs, state, conn);
619 }
620
621 return line1;
622 }
623 public String getSitek5(int num1,int num2) {//五号线求路线
624 String []a=new String[num1-num2+1];
625 String line2="";
626 String sql = "select * from station5";
627 Connection conn = DBUtil.getConn();
628 Statement state = null;
629 ResultSet rs = null;
630 int i=0;
631 try {
632 state = conn.createStatement();
633 rs = state.executeQuery(sql);
634 List<subway> list = new ArrayList<subway>();
635 while (rs.next()) {
636 subway s=new subway();
637 s.setSite(rs.getString("site"));
638 s.setNum(rs.getInt("num"));
639 if(s.getNum()>=num2&&s.getNum()<=num1)
640 {
641 if(s.getNum()==num2)
642 {
643 a[i]=s.getSite();
644 i++;
645 }
646 if(s.getNum()!=num2)
647 {
648 a[i]=s.getSite()+"->";
649 i++;
650 }
651 }
652 }
653 } catch (Exception e) {
654 e.printStackTrace();
655 } finally {
656 DBUtil.close(rs, state, conn);
657 }
658 for(int j=num1-num2;j>=0;j--)
659 {
660 line2=line2+a[j];
661 }
662 return line2;
663 }
664
665 public String getSiter6(int num1,int num2) {//六号线求路线
666 String line1="";
667 String sql = "select * from station6";
668 Connection conn = DBUtil.getConn();
669 Statement state = null;
670 ResultSet rs = null;
671 try {
672 state = conn.createStatement();
673 rs = state.executeQuery(sql);
674 List<subway> list = new ArrayList<subway>();
675 while (rs.next()) {
676 subway s=new subway();
677 s.setSite(rs.getString("site"));
678 s.setNum(rs.getInt("num"));
679 if(s.getNum()>=num1&&s.getNum()<=num2)
680 {
681 if(s.getNum()!=num2)
682 line1=line1+s.getSite()+"->";
683 if(s.getNum()==num2)
684 {
685 line1=line1+s.getSite();
686 }
687 }
688 }
689 } catch (Exception e) {
690 e.printStackTrace();
691 } finally {
692 DBUtil.close(rs, state, conn);
693 }
694
695 return line1;
696 }
697 public String getSitek6(int num1,int num2) {//六号线求路线
698 String []a=new String[num1-num2+1];
699 String line2="";
700 String sql = "select * from station6";
701 Connection conn = DBUtil.getConn();
702 Statement state = null;
703 ResultSet rs = null;
704 int i=0;
705 try {
706 state = conn.createStatement();
707 rs = state.executeQuery(sql);
708 List<subway> list = new ArrayList<subway>();
709 while (rs.next()) {
710 subway s=new subway();
711 s.setSite(rs.getString("site"));
712 s.setNum(rs.getInt("num"));
713 if(s.getNum()>=num2&&s.getNum()<=num1)
714 {
715 if(s.getNum()==num2)
716 {
717 a[i]=s.getSite();
718 i++;
719 }
720 if(s.getNum()!=num2)
721 {
722 a[i]=s.getSite()+"->";
723 i++;
724 }
725 }
726 }
727 } catch (Exception e) {
728 e.printStackTrace();
729 } finally {
730 DBUtil.close(rs, state, conn);
731 }
732 for(int j=num1-num2;j>=0;j--)
733 {
734 line2=line2+a[j];
735 }
736 return line2;
737 }
738
739
740 public int getLine(String site) {
741 int sum=0;
742 int line_k=0;
743 String sql = "select * from station";
744 Connection conn = DBUtil.getConn();
745 Statement state = null;
746 ResultSet rs = null;
747 try {
748 state = conn.createStatement();
749 rs = state.executeQuery(sql);
750 List<subway> list = new ArrayList<subway>();
751 while (rs.next()) {
752 subway s=new subway();
753 s.setSite(rs.getString("site"));
754 s.setNum(rs.getInt("num"));
755 s.setLine(rs.getInt("line"));
756 if(s.getSite().equals(site))
757 {
758 line_k=s.getLine();
759 sum++;
760 }
761 }
762 } catch (Exception e) {
763 e.printStackTrace();
764 } finally {
765 DBUtil.close(rs, state, conn);
766 }//在一号线中遍历
767
768 String sql1 = "select * from station2";
769 Connection conn1 = DBUtil.getConn();
770 Statement state1 = null;
771 ResultSet rs1 = null;
772 try {
773 state1 = conn1.createStatement();
774 rs1 = state1.executeQuery(sql1);
775 List<subway> list = new ArrayList<subway>();
776 while (rs1.next()) {
777 subway s=new subway();
778 s.setSite(rs1.getString("site"));
779 s.setNum(rs1.getInt("num"));
780 s.setLine(rs1.getInt("line"));
781 if(s.getSite().equals(site))
782 {
783 line_k=s.getLine();
784 sum++;
785 }
786 }
787 } catch (Exception e) {
788 e.printStackTrace();
789 } finally {
790 DBUtil.close(rs1, state1, conn1);
791 }//在二号线中遍历
792
793 String sql2 = "select * from station3";
794 Connection conn2 = DBUtil.getConn();
795 Statement state2 = null;
796 ResultSet rs2 = null;
797 try {
798 state2 = conn2.createStatement();
799 rs2 = state2.executeQuery(sql2);
800 List<subway> list = new ArrayList<subway>();
801 while (rs2.next()) {
802 subway s=new subway();
803 s.setSite(rs2.getString("site"));
804 s.setNum(rs2.getInt("num"));
805 s.setLine(rs2.getInt("line"));
806 if(s.getSite().equals(site))
807 {
808 line_k=s.getLine();
809 sum++;
810 }
811 }
812 } catch (Exception e) {
813 e.printStackTrace();
814 } finally {
815 DBUtil.close(rs2, state2, conn2);
816 }//在三号线中遍历
817
818 String sql3 = "select * from station4";
819 Connection conn3 = DBUtil.getConn();
820 Statement state3 = null;
821 ResultSet rs3 = null;
822 try {
823 state3 = conn3.createStatement();
824 rs3 = state3.executeQuery(sql3);
825 List<subway> list = new ArrayList<subway>();
826 while (rs3.next()) {
827 subway s=new subway();
828 s.setSite(rs3.getString("site"));
829 s.setNum(rs3.getInt("num"));
830 s.setLine(rs3.getInt("line"));
831 if(s.getSite().equals(site))
832 {
833 line_k=s.getLine();
834 sum++;
835 }
836 }
837 } catch (Exception e) {
838 e.printStackTrace();
839 } finally {
840 DBUtil.close(rs3, state3, conn3);
841 }//在四号线中遍历
842
843 String sql4 = "select * from station5";
844 Connection conn4 = DBUtil.getConn();
845 Statement state4 = null;
846 ResultSet rs4 = null;
847 try {
848 state4 = conn4.createStatement();
849 rs4 = state4.executeQuery(sql4);
850 List<subway> list = new ArrayList<subway>();
851 while (rs4.next()) {
852 subway s=new subway();
853 s.setSite(rs4.getString("site"));
854 s.setNum(rs4.getInt("num"));
855 s.setLine(rs4.getInt("line"));
856 if(s.getSite().equals(site))
857 {
858 line_k=s.getLine();
859 sum++;
860 }
861 }
862 } catch (Exception e) {
863 e.printStackTrace();
864 } finally {
865 DBUtil.close(rs4, state4, conn4);
866 }//在五号线中遍历
867
868 String sql5 = "select * from station6";
869 Connection conn5 = DBUtil.getConn();
870 Statement state5 = null;
871 ResultSet rs5 = null;
872 try {
873 state5 = conn5.createStatement();
874 rs5 = state5.executeQuery(sql5);
875 List<subway> list = new ArrayList<subway>();
876 while (rs5.next()) {
877 subway s=new subway();
878 s.setSite(rs5.getString("site"));
879 s.setNum(rs5.getInt("num"));
880 s.setLine(rs5.getInt("line"));
881 if(s.getSite().equals(site))
882 {
883 line_k=s.getLine();
884 sum++;
885 }
886 }
887 } catch (Exception e) {
888 e.printStackTrace();
889 } finally {
890 DBUtil.close(rs5, state5, conn5);
891 }//在六号线中遍历
892
893 return line_k;
894 }
895 public int[] getLineshuzu(String site) {//获取路线
896 int []a=new int[2];
897 a[0]=0;a[1]=0;
898 int temp=0;
899 String sql = "select * from station";
900 Connection conn = DBUtil.getConn();
901 Statement state = null;
902 ResultSet rs = null;
903 try {
904 state = conn.createStatement();
905 rs = state.executeQuery(sql);
906 List<subway> list = new ArrayList<subway>();
907 while (rs.next()) {
908 subway s=new subway();
909 s.setSite(rs.getString("site"));
910 s.setNum(rs.getInt("num"));
911 s.setLine(rs.getInt("line"));
912 if(s.getSite().equals(site))
913 {
914 a[temp]=s.getLine();
915 temp++;
916 }
917 }
918 } catch (Exception e) {
919 e.printStackTrace();
920 } finally {
921 DBUtil.close(rs, state, conn);
922 }//在一号线中遍历
923
924 String sql1 = "select * from station2";
925 Connection conn1 = DBUtil.getConn();
926 Statement state1 = null;
927 ResultSet rs1 = null;
928 try {
929 state1 = conn1.createStatement();
930 rs1 = state1.executeQuery(sql1);
931 List<subway> list = new ArrayList<subway>();
932 while (rs1.next()) {
933 subway s=new subway();
934 s.setSite(rs1.getString("site"));
935 s.setNum(rs1.getInt("num"));
936 s.setLine(rs1.getInt("line"));
937 if(s.getSite().equals(site))
938 {
939 a[temp]=s.getLine();
940 temp++;
941 }
942 }
943 } catch (Exception e) {
944 e.printStackTrace();
945 } finally {
946 DBUtil.close(rs1, state1, conn1);
947 }//在二号线中遍历
948
949 String sql2 = "select * from station3";
950 Connection conn2 = DBUtil.getConn();
951 Statement state2 = null;
952 ResultSet rs2 = null;
953 try {
954 state2 = conn2.createStatement();
955 rs2 = state2.executeQuery(sql2);
956 List<subway> list = new ArrayList<subway>();
957 while (rs2.next()) {
958 subway s=new subway();
959 s.setSite(rs2.getString("site"));
960 s.setNum(rs2.getInt("num"));
961 s.setLine(rs2.getInt("line"));
962 if(s.getSite().equals(site))
963 {
964 a[temp]=s.getLine();
965 temp++;
966 }
967 }
968 } catch (Exception e) {
969 e.printStackTrace();
970 } finally {
971 DBUtil.close(rs2, state2, conn2);
972 }//在三号线中遍历
973
974 String sql3 = "select * from station4";
975 Connection conn3 = DBUtil.getConn();
976 Statement state3 = null;
977 ResultSet rs3 = null;
978 try {
979 state3 = conn3.createStatement();
980 rs3 = state3.executeQuery(sql3);
981 List<subway> list = new ArrayList<subway>();
982 while (rs3.next()) {
983 subway s=new subway();
984 s.setSite(rs3.getString("site"));
985 s.setNum(rs3.getInt("num"));
986 s.setLine(rs3.getInt("line"));
987 if(s.getSite().equals(site))
988 {
989 a[temp]=s.getLine();
990 temp++;
991 }
992 }
993 } catch (Exception e) {
994 e.printStackTrace();
995 } finally {
996 DBUtil.close(rs3, state3, conn3);
997 }//在四号线中遍历
998
999 String sql4 = "select * from station5";
1000 Connection conn4 = DBUtil.getConn();
1001 Statement state4 = null;
1002 ResultSet rs4 = null;
1003 try {
1004 state4 = conn4.createStatement();
1005 rs4 = state4.executeQuery(sql4);
1006 List<subway> list = new ArrayList<subway>();
1007 while (rs4.next()) {
1008 subway s=new subway();
1009 s.setSite(rs4.getString("site"));
1010 s.setNum(rs4.getInt("num"));
1011 s.setLine(rs4.getInt("line"));
1012 if(s.getSite().equals(site))
1013 {
1014 a[temp]=s.getLine();
1015 temp++;
1016 }
1017 }
1018 } catch (Exception e) {
1019 e.printStackTrace();
1020 } finally {
1021 DBUtil.close(rs4, state4, conn4);
1022 }//在五号线中遍历
1023
1024 String sql5 = "select * from station6";
1025 Connection conn5 = DBUtil.getConn();
1026 Statement state5 = null;
1027 ResultSet rs5 = null;
1028 try {
1029 state5 = conn5.createStatement();
1030 rs5 = state5.executeQuery(sql5);
1031 List<subway> list = new ArrayList<subway>();
1032 while (rs5.next()) {
1033 subway s=new subway();
1034 s.setSite(rs5.getString("site"));
1035 s.setNum(rs5.getInt("num"));
1036 s.setLine(rs5.getInt("line"));
1037 if(s.getSite().equals(site))
1038 {
1039 a[temp]=s.getLine();
1040 temp++;
1041 }
1042 }
1043 } catch (Exception e) {
1044 e.printStackTrace();
1045 } finally {
1046 DBUtil.close(rs5, state5, conn5);
1047 }//在六号线中遍历
1048
1049 return a;
1050 }
1051 public int getSum(String site) {//获取换乘点所在路线数
1052 int sum=0;
1053 int line_k=0;
1054 String sql = "select * from station";
1055 Connection conn = DBUtil.getConn();
1056 Statement state = null;
1057 ResultSet rs = null;
1058 try {
1059 state = conn.createStatement();
1060 rs = state.executeQuery(sql);
1061 List<subway> list = new ArrayList<subway>();
1062 while (rs.next()) {
1063 subway s=new subway();
1064 s.setSite(rs.getString("site"));
1065 s.setNum(rs.getInt("num"));
1066 s.setLine(rs.getInt("line"));
1067 if(s.getSite().equals(site))
1068 {
1069 line_k=s.getLine();
1070 sum++;
1071 }
1072 }
1073 } catch (Exception e) {
1074 e.printStackTrace();
1075 } finally {
1076 DBUtil.close(rs, state, conn);
1077 }//在一号线中遍历
1078
1079 String sql1 = "select * from station2";
1080 Connection conn1 = DBUtil.getConn();
1081 Statement state1 = null;
1082 ResultSet rs1 = null;
1083 try {
1084 state1 = conn1.createStatement();
1085 rs1 = state1.executeQuery(sql1);
1086 List<subway> list = new ArrayList<subway>();
1087 while (rs1.next()) {
1088 subway s=new subway();
1089 s.setSite(rs1.getString("site"));
1090 s.setNum(rs1.getInt("num"));
1091 s.setLine(rs1.getInt("line"));
1092 if(s.getSite().equals(site))
1093 {
1094 line_k=s.getLine();
1095 sum++;
1096 }
1097 }
1098 } catch (Exception e) {
1099 e.printStackTrace();
1100 } finally {
1101 DBUtil.close(rs1, state1, conn1);
1102 }//在二号线中遍历
1103
1104 String sql2 = "select * from station3";
1105 Connection conn2 = DBUtil.getConn();
1106 Statement state2 = null;
1107 ResultSet rs2 = null;
1108 try {
1109 state2 = conn2.createStatement();
1110 rs2 = state2.executeQuery(sql2);
1111 List<subway> list = new ArrayList<subway>();
1112 while (rs2.next()) {
1113 subway s=new subway();
1114 s.setSite(rs2.getString("site"));
1115 s.setNum(rs2.getInt("num"));
1116 s.setLine(rs2.getInt("line"));
1117 if(s.getSite().equals(site))
1118 {
1119 line_k=s.getLine();
1120 sum++;
1121 }
1122 }
1123 } catch (Exception e) {
1124 e.printStackTrace();
1125 } finally {
1126 DBUtil.close(rs2, state2, conn2);
1127 }//在三号线中遍历
1128
1129 String sql3 = "select * from station4";
1130 Connection conn3 = DBUtil.getConn();
1131 Statement state3 = null;
1132 ResultSet rs3 = null;
1133 try {
1134 state3 = conn3.createStatement();
1135 rs3 = state3.executeQuery(sql3);
1136 List<subway> list = new ArrayList<subway>();
1137 while (rs3.next()) {
1138 subway s=new subway();
1139 s.setSite(rs3.getString("site"));
1140 s.setNum(rs3.getInt("num"));
1141 s.setLine(rs3.getInt("line"));
1142 if(s.getSite().equals(site))
1143 {
1144 line_k=s.getLine();
1145 sum++;
1146 }
1147 }
1148 } catch (Exception e) {
1149 e.printStackTrace();
1150 } finally {
1151 DBUtil.close(rs3, state3, conn3);
1152 }//在四号线中遍历
1153
1154 String sql4 = "select * from station5";
1155 Connection conn4 = DBUtil.getConn();
1156 Statement state4 = null;
1157 ResultSet rs4 = null;
1158 try {
1159 state4 = conn4.createStatement();
1160 rs4 = state4.executeQuery(sql4);
1161 List<subway> list = new ArrayList<subway>();
1162 while (rs4.next()) {
1163 subway s=new subway();
1164 s.setSite(rs4.getString("site"));
1165 s.setNum(rs4.getInt("num"));
1166 s.setLine(rs4.getInt("line"));
1167 if(s.getSite().equals(site))
1168 {
1169 line_k=s.getLine();
1170 sum++;
1171 }
1172 }
1173 } catch (Exception e) {
1174 e.printStackTrace();
1175 } finally {
1176 DBUtil.close(rs4, state4, conn4);
1177 }//在五号线中遍历
1178
1179 String sql5 = "select * from station6";
1180 Connection conn5 = DBUtil.getConn();
1181 Statement state5 = null;
1182 ResultSet rs5 = null;
1183 try {
1184 state5 = conn5.createStatement();
1185 rs5 = state5.executeQuery(sql5);
1186 List<subway> list = new ArrayList<subway>();
1187 while (rs5.next()) {
1188 subway s=new subway();
1189 s.setSite(rs5.getString("site"));
1190 s.setNum(rs5.getInt("num"));
1191 s.setLine(rs5.getInt("line"));
1192 if(s.getSite().equals(site))
1193 {
1194 line_k=s.getLine();
1195 sum++;
1196 }
1197 }
1198 } catch (Exception e) {
1199 e.printStackTrace();
1200 } finally {
1201 DBUtil.close(rs5, state5, conn5);
1202 }//在六号线中遍历
1203
1204 return sum;
1205 }
1206
1207 public String[] getgline(int a[],int b[]) {//在换乘线中查找换乘点
1208 String []site=new String[2];
1209 site[0]="";
1210 site[1]="";
1211 int temp=0;
1212 String sql = "select * from huancheng";
1213 Connection conn = DBUtil.getConn();
1214 Statement state = null;
1215 ResultSet rs = null;
1216 try {
1217 state = conn.createStatement();
1218 rs = state.executeQuery(sql);
1219 List<subway> list = new ArrayList<subway>();
1220 while (rs.next()) {
1221 huancheng s=new huancheng();
1222 s.setSite(rs.getString("gsite"));
1223 s.setFirst(rs.getInt("first"));
1224 s.setSec(rs.getInt("sec"));
1225 if(a[0]==s.getFirst()&&b[0]==s.getSec())
1226 {
1227 site[temp]=s.getSite();
1228 temp++;
1229 }
1230 }
1231 } catch (Exception e) {
1232 e.printStackTrace();
1233 } finally {
1234 DBUtil.close(rs, state, conn);
1235 }
1236
1237 return site;
1238 }
1239 public String getview(int a[],int b[],int num1,int num2,int num3,int num4) {//123456
1240 String route="";
1241 if(a[0]==1&&b[0]==2)
1242 {
1243 if(num1<=num2)
1244 {
1245 String line1=getSiter1(num1, num2);
1246 System.out.print("路线为:"+line1+"->");
1247 route="路线为:"+line1+"->";
1248 }
1249 if(num1>num2)
1250 {
1251 String line2=getSitek1(num1, num2);
1252 System.out.print("路线为:"+line2+"->");
1253 route="路线为:"+line2+"->";
1254 }
1255 if(num3>num4)
1256 {
1257 String line1=getSiter2(num4, num3);
1258 System.out.print("(换乘)"+line1);
1259 route=route+"(换乘)"+line1;
1260 }
1261 if(num3<=num4)
1262 {
1263 String line2=getSitek2(num4, num3);
1264 System.out.print("(换乘)"+line2);
1265 route=route+"(换乘)"+line2;
1266 }
1267 }
1268 if(a[0]==2&&b[0]==1)
1269 {
1270 if(num1<=num2)
1271 {
1272 String line1=getSiter2(num1, num2);
1273 System.out.print("路线为:"+line1+"->");
1274 route="路线为:"+line1+"->";
1275 }
1276 if(num1>num2)
1277 {
1278 String line2=getSitek2(num1, num2);
1279 System.out.print("路线为:"+line2+"->");
1280 route="路线为:"+line2+"->";
1281 }
1282 if(num3>num4)
1283 {
1284 String line1=getSiter1(num4, num3);
1285 System.out.print("(换乘)"+line1);
1286 route=route+"(换乘)"+line1;
1287 }
1288 if(num3<=num4)
1289 {
1290 String line2=getSitek1(num4, num3);
1291 System.out.print("(换乘)"+line2);
1292 route=route+"(换乘)"+line2;
1293 }
1294 }//1-2
1295 if(a[0]==1&&b[0]==3)
1296 {
1297 if(num1<=num2)
1298 {
1299 String line1=getSiter1(num1, num2);
1300 System.out.print("路线为:"+line1+"->");
1301 route="路线为:"+line1+"->";
1302 }
1303 if(num1>num2)
1304 {
1305 String line2=getSitek1(num1, num2);
1306 System.out.print("路线为:"+line2+"->");
1307 route="路线为:"+line2+"->";
1308 }
1309 if(num3>num4)
1310 {
1311 String line1=getSiter3(num4, num3);
1312 System.out.print("(换乘)"+line1);
1313 route=route+"(换乘)"+line1;
1314 }
1315 if(num3<=num4)
1316 {
1317 String line2=getSitek3(num4, num3);
1318 System.out.print("(换乘)"+line2);
1319 route=route+"(换乘)"+line2;
1320 }
1321 }
1322 if(a[0]==3&&b[0]==1)
1323 {
1324 if(num1<=num2)
1325 {
1326 String line1=getSiter3(num1, num2);
1327 System.out.print("路线为:"+line1+"->");
1328 route="路线为:"+line1+"->";
1329 }
1330 if(num1>num2)
1331 {
1332 String line2=getSitek3(num1, num2);
1333 System.out.print("路线为:"+line2+"->");
1334 route="路线为:"+line2+"->";
1335 }
1336 if(num3>num4)
1337 {
1338 String line1=getSiter1(num4, num3);
1339 System.out.print("(换乘)"+line1);
1340 route=route+"(换乘)"+line1;
1341 }
1342 if(num3<=num4)
1343 {
1344 String line2=getSitek1(num4, num3);
1345 System.out.print("(换乘)"+line2);
1346 route=route+"(换乘)"+line2;
1347 }
1348 }//1-3
1349 if(a[0]==1&&b[0]==4)
1350 {
1351 if(num1<=num2)
1352 {
1353 String line1=getSiter1(num1, num2);
1354 System.out.print("路线为:"+line1+"->");
1355 route="路线为:"+line1+"->";
1356 }
1357 if(num1>num2)
1358 {
1359 String line2=getSitek1(num1, num2);
1360 System.out.print("路线为:"+line2+"->");
1361 route="路线为:"+line2+"->";
1362 }
1363 if(num3>num4)
1364 {
1365 String line1=getSiter4(num4, num3);
1366 System.out.print("(换乘)"+line1);
1367 route=route+"(换乘)"+line1;
1368 }
1369 if(num3<=num4)
1370 {
1371 String line2=getSitek4(num4, num3);
1372 System.out.print("(换乘)"+line2);
1373 route=route+"(换乘)"+line2;
1374 }
1375 }
1376 if(a[0]==4&&b[0]==1)
1377 {
1378 if(num1<=num2)
1379 {
1380 String line1=getSiter4(num1, num2);
1381 System.out.print("路线为:"+line1+"->");
1382 route="路线为:"+line1+"->";
1383 }
1384 if(num1>num2)
1385 {
1386 String line2=getSitek4(num1, num2);
1387 System.out.print("路线为:"+line2+"->");
1388 route="路线为:"+line2+"->";
1389 }
1390 if(num3>num4)
1391 {
1392 String line1=getSiter1(num4, num3);
1393 System.out.print("(换乘)"+line1);
1394 route=route+"(换乘)"+line1;
1395 }
1396 if(num3<=num4)
1397 {
1398 String line2=getSitek1(num4, num3);
1399 System.out.print("(换乘)"+line2);
1400 route=route+"(换乘)"+line2;
1401 }
1402 }//1-4
1403 if(a[0]==1&&b[0]==5)
1404 {
1405 if(num1<=num2)
1406 {
1407 String line1=getSiter1(num1, num2);
1408 System.out.print("路线为:"+line1+"->");
1409 route="路线为:"+line1+"->";
1410 }
1411 if(num1>num2)
1412 {
1413 String line2=getSitek1(num1, num2);
1414 System.out.print("路线为:"+line2+"->");
1415 route="路线为:"+line2+"->";
1416 }
1417 if(num3>num4)
1418 {
1419 String line1=getSiter5(num4, num3);
1420 System.out.print("(换乘)"+line1);
1421 route=route+"(换乘)"+line1;
1422 }
1423 if(num3<=num4)
1424 {
1425 String line2=getSitek5(num4, num3);
1426 System.out.print("(换乘)"+line2);
1427 route=route+"(换乘)"+line2;
1428 }
1429 }
1430 if(a[0]==5&&b[0]==1)
1431 {
1432 if(num1<=num2)
1433 {
1434 String line1=getSiter5(num1, num2);
1435 System.out.print("路线为:"+line1+"->");
1436 route="路线为:"+line1+"->";
1437 }
1438 if(num1>num2)
1439 {
1440 String line2=getSitek5(num1, num2);
1441 System.out.print("路线为:"+line2+"->");
1442 route="路线为:"+line2+"->";
1443 }
1444 if(num3>num4)
1445 {
1446 String line1=getSiter1(num4, num3);
1447 System.out.print("(换乘)"+line1);
1448 route=route+"(换乘)"+line1;
1449 }
1450 if(num3<=num4)
1451 {
1452 String line2=getSitek1(num4, num3);
1453 System.out.print("(换乘)"+line2);
1454 route=route+"(换乘)"+line2;
1455 }
1456 }//1-5
1457 if(a[0]==1&&b[0]==6)
1458 {
1459 if(num1<=num2)
1460 {
1461 String line1=getSiter1(num1, num2);
1462 System.out.print("路线为:"+line1+"->");
1463 route="路线为:"+line1+"->";
1464 }
1465 if(num1>num2)
1466 {
1467 String line2=getSitek1(num1, num2);
1468 System.out.print("路线为:"+line2+"->");
1469 route="路线为:"+line2+"->";
1470 }
1471 if(num3>num4)
1472 {
1473 String line1=getSiter6(num4, num3);
1474 System.out.print("(换乘)"+line1);
1475 route=route+"(换乘)"+line1;
1476 }
1477 if(num3<=num4)
1478 {
1479 String line2=getSitek6(num4, num3);
1480 System.out.print("(换乘)"+line2);
1481 route=route+"(换乘)"+line2;
1482 }
1483 }
1484 if(a[0]==6&&b[0]==1)
1485 {
1486 if(num1<=num2)
1487 {
1488 String line1=getSiter6(num1, num2);
1489 System.out.print("路线为:"+line1+"->");
1490 route="路线为:"+line1+"->";
1491 }
1492 if(num1>num2)
1493 {
1494 String line2=getSitek6(num1, num2);
1495 System.out.print("路线为:"+line2+"->");
1496 route="路线为:"+line2+"->";
1497 }
1498 if(num3>num4)
1499 {
1500 String line1=getSiter1(num4, num3);
1501 System.out.print("(换乘)"+line1);
1502 route=route+"(换乘)"+line1;
1503 }
1504 if(num3<=num4)
1505 {
1506 String line2=getSitek1(num4, num3);
1507 System.out.print("(换乘)"+line2);
1508 route=route+"(换乘)"+line2;
1509 }
1510 }//1-6
1511 if(a[0]==2&&b[0]==3)
1512 {
1513 if(num1<=num2)
1514 {
1515 String line1=getSiter2(num1, num2);
1516 System.out.print("路线为:"+line1+"->");
1517 route="路线为:"+line1+"->";
1518 }
1519 if(num1>num2)
1520 {
1521 String line2=getSitek2(num1, num2);
1522 System.out.print("路线为:"+line2+"->");
1523 route="路线为:"+line2+"->";
1524 }
1525 if(num3>num4)
1526 {
1527 String line1=getSiter3(num4, num3);
1528 System.out.print("(换乘)"+line1);
1529 route=route+"(换乘)"+line1;
1530 }
1531 if(num3<=num4)
1532 {
1533 String line2=getSitek3(num4, num3);
1534 System.out.print("(换乘)"+line2);
1535 route=route+"(换乘)"+line2;
1536 }
1537 }
1538 if(a[0]==3&&b[0]==2)
1539 {
1540 if(num1<=num2)
1541 {
1542 String line1=getSiter3(num1, num2);
1543 System.out.print("路线为:"+line1+"->");
1544 route="路线为:"+line1+"->";
1545 }
1546 if(num1>num2)
1547 {
1548 String line2=getSitek3(num1, num2);
1549 System.out.print("路线为:"+line2+"->");
1550 route="路线为:"+line2+"->";
1551 }
1552 if(num3>num4)
1553 {
1554 String line1=getSiter2(num4, num3);
1555 System.out.print("(换乘)"+line1);
1556 route=route+"(换乘)"+line1;
1557 }
1558 if(num3<=num4)
1559 {
1560 String line2=getSitek2(num4, num3);
1561 System.out.print("(换乘)"+line2);
1562 route=route+"(换乘)"+line2;
1563 }
1564 }//2-3
1565 if(a[0]==2&&b[0]==4)
1566 {
1567 if(num1<=num2)
1568 {
1569 String line1=getSiter2(num1, num2);
1570 System.out.print("路线为:"+line1+"->");
1571 route="路线为:"+line1+"->";
1572 }
1573 if(num1>num2)
1574 {
1575 String line2=getSitek2(num1, num2);
1576 System.out.print("路线为:"+line2+"->");
1577 route="路线为:"+line2+"->";
1578 }
1579 if(num3>num4)
1580 {
1581 String line1=getSiter4(num4, num3);
1582 System.out.print("(换乘)"+line1);
1583 route=route+"(换乘)"+line1;
1584 }
1585 if(num3<=num4)
1586 {
1587 String line2=getSitek4(num4, num3);
1588 System.out.print("(换乘)"+line2);
1589 route=route+"(换乘)"+line2;
1590 }
1591 }
1592 if(a[0]==4&&b[0]==2)
1593 {
1594 if(num1<=num2)
1595 {
1596 String line1=getSiter4(num1, num2);
1597 System.out.print("路线为:"+line1+"->");
1598 route="路线为:"+line1+"->";
1599 }
1600 if(num1>num2)
1601 {
1602 String line2=getSitek4(num1, num2);
1603 System.out.print("路线为:"+line2+"->");
1604 route="路线为:"+line2+"->";
1605 }
1606 if(num3>num4)
1607 {
1608 String line1=getSiter2(num4, num3);
1609 System.out.print("(换乘)"+line1);
1610 route=route+"(换乘)"+line1;
1611 }
1612 if(num3<=num4)
1613 {
1614 String line2=getSitek2(num4, num3);
1615 System.out.print("(换乘)"+line2);
1616 route=route+"(换乘)"+line2;
1617 }
1618 }//2-4
1619 if(a[0]==2&&b[0]==5)
1620 {
1621 if(num1<=num2)
1622 {
1623 String line1=getSiter2(num1, num2);
1624 System.out.print("路线为:"+line1+"->");
1625 route="路线为:"+line1+"->";
1626 }
1627 if(num1>num2)
1628 {
1629 String line2=getSitek2(num1, num2);
1630 System.out.print("路线为:"+line2+"->");
1631 route="路线为:"+line2+"->";
1632 }
1633 if(num3>num4)
1634 {
1635 String line1=getSiter5(num4, num3);
1636 System.out.print("(换乘)"+line1);
1637 route=route+"(换乘)"+line1;
1638 }
1639 if(num3<=num4)
1640 {
1641 String line2=getSitek5(num4, num3);
1642 System.out.print("(换乘)"+line2);
1643 route=route+"(换乘)"+line2;
1644 }
1645 }
1646 if(a[0]==5&&b[0]==2)
1647 {
1648 if(num1<=num2)
1649 {
1650 String line1=getSiter5(num1, num2);
1651 System.out.print("路线为:"+line1+"->");
1652 route="路线为:"+line1+"->";
1653 }
1654 if(num1>num2)
1655 {
1656 String line2=getSitek5(num1, num2);
1657 System.out.print("路线为:"+line2+"->");
1658 route="路线为:"+line2+"->";
1659 }
1660 if(num3>num4)
1661 {
1662 String line1=getSiter2(num4, num3);
1663 System.out.print("(换乘)"+line1);
1664 route=route+"(换乘)"+line1;
1665 }
1666 if(num3<=num4)
1667 {
1668 String line2=getSitek2(num4, num3);
1669 System.out.print("(换乘)"+line2);
1670 route=route+"(换乘)"+line2;
1671 }
1672 }//2-5
1673 if(a[0]==2&&b[0]==6)
1674 {
1675 if(num1<=num2)
1676 {
1677 String line1=getSiter2(num1, num2);
1678 System.out.print("路线为:"+line1+"->");
1679 route="路线为:"+line1+"->";
1680 }
1681 if(num1>num2)
1682 {
1683 String line2=getSitek2(num1, num2);
1684 System.out.print("路线为:"+line2+"->");
1685 route="路线为:"+line2+"->";
1686 }
1687 if(num3>num4)
1688 {
1689 String line1=getSiter6(num4, num3);
1690 System.out.print("(换乘)"+line1);
1691 route=route+"(换乘)"+line1;
1692 }
1693 if(num3<=num4)
1694 {
1695 String line2=getSitek6(num4, num3);
1696 System.out.print("(换乘)"+line2);
1697 route=route+"(换乘)"+line2;
1698 }
1699 }
1700 if(a[0]==6&&b[0]==2)
1701 {
1702 if(num1<=num2)
1703 {
1704 String line1=getSiter6(num1, num2);
1705 System.out.print("路线为:"+line1+"->");
1706 route="路线为:"+line1+"->";
1707 }
1708 if(num1>num2)
1709 {
1710 String line2=getSitek6(num1, num2);
1711 System.out.print("路线为:"+line2+"->");
1712 route="路线为:"+line2+"->";
1713 }
1714 if(num3>num4)
1715 {
1716 String line1=getSiter2(num4, num3);
1717 System.out.print("(换乘)"+line1);
1718 route=route+"(换乘)"+line1;
1719 }
1720 if(num3<=num4)
1721 {
1722 String line2=getSitek2(num4, num3);
1723 System.out.print("(换乘)"+line2);
1724 route=route+"(换乘)"+line2;
1725 }
1726 }//2-6
1727 if(a[0]==3&&b[0]==4)
1728 {
1729 if(num1<=num2)
1730 {
1731 String line1=getSiter3(num1, num2);
1732 System.out.print("路线为:"+line1+"->");
1733 route="路线为:"+line1+"->";
1734 }
1735 if(num1>num2)
1736 {
1737 String line2=getSitek3(num1, num2);
1738 System.out.print("路线为:"+line2+"->");
1739 route="路线为:"+line2+"->";
1740 }
1741 if(num3>num4)
1742 {
1743 String line1=getSiter4(num4, num3);
1744 System.out.print("(换乘)"+line1);
1745 route=route+"(换乘)"+line1;
1746 }
1747 if(num3<=num4)
1748 {
1749 String line2=getSitek4(num4, num3);
1750 System.out.print("(换乘)"+line2);
1751 route=route+"(换乘)"+line2;
1752 }
1753 }
1754 if(a[0]==4&&b[0]==3)
1755 {
1756 if(num1<=num2)
1757 {
1758 String line1=getSiter4(num1, num2);
1759 System.out.print("路线为:"+line1+"->");
1760 route="路线为:"+line1+"->";
1761 }
1762 if(num1>num2)
1763 {
1764 String line2=getSitek4(num1, num2);
1765 System.out.print("路线为:"+line2+"->");
1766 route="路线为:"+line2+"->";
1767 }
1768 if(num3>num4)
1769 {
1770 String line1=getSiter3(num4, num3);
1771 System.out.print("(换乘)"+line1);
1772 route=route+"(换乘)"+line1;
1773 }
1774 if(num3<=num4)
1775 {
1776 String line2=getSitek3(num4, num3);
1777 System.out.print("(换乘)"+line2);
1778 route=route+"(换乘)"+line2;
1779 }
1780 }//3-4
1781 if(a[0]==3&&b[0]==5)
1782 {
1783 if(num1<=num2)
1784 {
1785 String line1=getSiter3(num1, num2);
1786 System.out.print("路线为:"+line1+"->");
1787 route="路线为:"+line1+"->";
1788 }
1789 if(num1>num2)
1790 {
1791 String line2=getSitek3(num1, num2);
1792 System.out.print("路线为:"+line2+"->");
1793 route="路线为:"+line2+"->";
1794 }
1795 if(num3>num4)
1796 {
1797 String line1=getSiter5(num4, num3);
1798 System.out.print("(换乘)"+line1);
1799 route=route+"(换乘)"+line1;
1800 }
1801 if(num3<=num4)
1802 {
1803 String line2=getSitek5(num4, num3);
1804 System.out.print("(换乘)"+line2);
1805 route=route+"(换乘)"+line2;
1806 }
1807 }
1808 if(a[0]==5&&b[0]==3)
1809 {
1810 if(num1<=num2)
1811 {
1812 String line1=getSiter5(num1, num2);
1813 System.out.print("路线为:"+line1+"->");
1814 route="路线为:"+line1+"->";
1815 }
1816 if(num1>num2)
1817 {
1818 String line2=getSitek5(num1, num2);
1819 System.out.print("路线为:"+line2+"->");
1820 route="路线为:"+line2+"->";
1821 }
1822 if(num3>num4)
1823 {
1824 String line1=getSiter3(num4, num3);
1825 System.out.print("(换乘)"+line1);
1826 route=route+"(换乘)"+line1;
1827 }
1828 if(num3<=num4)
1829 {
1830 String line2=getSitek3(num4, num3);
1831 System.out.print("(换乘)"+line2);
1832 route=route+"(换乘)"+line2;
1833 }
1834 }//3-5
1835 if(a[0]==3&&b[0]==6)
1836 {
1837 if(num1<=num2)
1838 {
1839 String line1=getSiter3(num1, num2);
1840 System.out.print("路线为:"+line1+"->");
1841 route="路线为:"+line1+"->";
1842 }
1843 if(num1>num2)
1844 {
1845 String line2=getSitek3(num1, num2);
1846 System.out.print("路线为:"+line2+"->");
1847 route="路线为:"+line2+"->";
1848 }
1849 if(num3>num4)
1850 {
1851 String line1=getSiter6(num4, num3);
1852 System.out.print("(换乘)"+line1);
1853 route=route+"(换乘)"+line1;
1854 }
1855 if(num3<=num4)
1856 {
1857 String line2=getSitek6(num4, num3);
1858 System.out.print("(换乘)"+line2);
1859 route=route+"(换乘)"+line2;
1860 }
1861 }
1862 if(a[0]==6&&b[0]==3)
1863 {
1864 if(num1<=num2)
1865 {
1866 String line1=getSiter6(num1, num2);
1867 System.out.print("路线为:"+line1+"->");
1868 route="路线为:"+line1+"->";
1869 }
1870 if(num1>num2)
1871 {
1872 String line2=getSitek6(num1, num2);
1873 System.out.print("路线为:"+line2+"->");
1874 route="路线为:"+line2+"->";
1875 }
1876 if(num3>num4)
1877 {
1878 String line1=getSiter3(num4, num3);
1879 System.out.print("(换乘)"+line1);
1880 route=route+"(换乘)"+line1;
1881 }
1882 if(num3<=num4)
1883 {
1884 String line2=getSitek3(num4, num3);
1885 System.out.print("(换乘)"+line2);
1886 route=route+"(换乘)"+line2;
1887 }
1888 }//3-6
1889 if(a[0]==4&&b[0]==5)
1890 {
1891 if(num1<=num2)
1892 {
1893 String line1=getSiter4(num1, num2);
1894 System.out.print("路线为:"+line1+"->");
1895 route="路线为:"+line1+"->";
1896 }
1897 if(num1>num2)
1898 {
1899 String line2=getSitek4(num1, num2);
1900 System.out.print("路线为:"+line2+"->");
1901 route="路线为:"+line2+"->";
1902 }
1903 if(num3>num4)
1904 {
1905 String line1=getSiter5(num4, num3);
1906 System.out.print("(换乘)"+line1);
1907 route=route+"(换乘)"+line1;
1908 }
1909 if(num3<=num4)
1910 {
1911 String line2=getSitek5(num4, num3);
1912 System.out.print("(换乘)"+line2);
1913 route=route+"(换乘)"+line2;
1914 }
1915 }
1916 if(a[0]==5&&b[0]==4)
1917 {
1918 if(num1<=num2)
1919 {
1920 String line1=getSiter5(num1, num2);
1921 System.out.print("路线为:"+line1+"->");
1922 route="路线为:"+line1+"->";
1923 }
1924 if(num1>num2)
1925 {
1926 String line2=getSitek5(num1, num2);
1927 System.out.print("路线为:"+line2+"->");
1928 route="路线为:"+line2+"->";
1929 }
1930 if(num3>num4)
1931 {
1932 String line1=getSiter4(num4, num3);
1933 System.out.print("(换乘)"+line1);
1934 route=route+"(换乘)"+line1;
1935 }
1936 if(num3<=num4)
1937 {
1938 String line2=getSitek4(num4, num3);
1939 System.out.print("(换乘)"+line2);
1940 route=route+"(换乘)"+line2;
1941 }
1942 }//4-5
1943 if(a[0]==4&&b[0]==6)
1944 {
1945 if(num1<=num2)
1946 {
1947 String line1=getSiter4(num1, num2);
1948 System.out.print("路线为:"+line1+"->");
1949 route="路线为:"+line1+"->";
1950 }
1951 if(num1>num2)
1952 {
1953 String line2=getSitek4(num1, num2);
1954 System.out.print("路线为:"+line2+"->");
1955 route="路线为:"+line2+"->";
1956 }
1957 if(num3>num4)
1958 {
1959 String line1=getSiter6(num4, num3);
1960 System.out.print("(换乘)"+line1);
1961 route=route+"(换乘)"+line1;
1962 }
1963 if(num3<=num4)
1964 {
1965 String line2=getSitek6(num4, num3);
1966 System.out.print("(换乘)"+line2);
1967 route=route+"(换乘)"+line2;
1968 }
1969 }
1970 if(a[0]==6&&b[0]==4)
1971 {
1972 if(num1<=num2)
1973 {
1974 String line1=getSiter6(num1, num2);
1975 System.out.print("路线为:"+line1+"->");
1976 route="路线为:"+line1+"->";
1977 }
1978 if(num1>num2)
1979 {
1980 String line2=getSitek6(num1, num2);
1981 System.out.print("路线为:"+line2+"->");
1982 route="路线为:"+line2+"->";
1983 }
1984 if(num3>num4)
1985 {
1986 String line1=getSiter4(num4, num3);
1987 System.out.print("(换乘)"+line1);
1988 route=route+"(换乘)"+line1;
1989 }
1990 if(num3<=num4)
1991 {
1992 String line2=getSitek4(num4, num3);
1993 System.out.print("(换乘)"+line2);
1994 route=route+"(换乘)"+line2;
1995 }
1996 }//4-6
1997 if(a[0]==5&&b[0]==6)
1998 {
1999 if(num1<=num2)
2000 {
2001 String line1=getSiter5(num1, num2);
2002 System.out.print("路线为:"+line1+"->");
2003 route="路线为:"+line1+"->";
2004 }
2005 if(num1>num2)
2006 {
2007 String line2=getSitek5(num1, num2);
2008 System.out.print("路线为:"+line2+"->");
2009 route="路线为:"+line2+"->";
2010 }
2011 if(num3>num4)
2012 {
2013 String line1=getSiter6(num4, num3);
2014 System.out.print("(换乘)"+line1);
2015 route=route+"(换乘)"+line1;
2016 }
2017 if(num3<=num4)
2018 {
2019 String line2=getSitek6(num4, num3);
2020 System.out.print("(换乘)"+line2);
2021 route=route+"(换乘)"+line2;
2022 }
2023 }
2024 if(a[0]==6&&b[0]==5)
2025 {
2026 if(num1<=num2)
2027 {
2028 String line1=getSiter6(num1, num2);
2029 System.out.print("路线为:"+line1+"->");
2030 route="路线为:"+line1+"->";
2031 }
2032 if(num1>num2)
2033 {
2034 String line2=getSitek6(num1, num2);
2035 System.out.print("路线为:"+line2+"->");
2036 route="路线为:"+line2+"->";
2037 }
2038 if(num3>num4)
2039 {
2040 String line1=getSiter5(num4, num3);
2041 System.out.print("(换乘)"+line1);
2042 route=route+"(换乘)"+line1;
2043 }
2044 if(num3<=num4)
2045 {
2046 String line2=getSitek5(num4, num3);
2047 System.out.print("(换乘)"+line2);
2048 route=route+"(换乘)"+line2;
2049 }
2050 }//5-6
2051 return route;
2052 }
2053
2054 public int[] getviewnum(int a[],int b[],String c[],String start,String end) {//123456
2055 int []d=new int[4];
2056 if(a[0]==1&&b[0]==2)
2057 {
2058 d[0]=getNum(start);
2059 d[1]=getNum2(end);
2060 d[2]=getNum(c[0]);
2061 d[3]=getNum2(c[0]);
2062 }
2063 if(a[0]==2&&b[0]==1)
2064 {
2065 d[0]=getNum2(start);
2066 d[1]=getNum(end);
2067 d[2]=getNum2(c[0]);
2068 d[3]=getNum(c[0]);
2069 }//1-2
2070 if(a[0]==1&&b[0]==3)
2071 {
2072 d[0]=getNum(start);
2073 d[1]=getNum3(end);
2074 d[2]=getNum(c[0]);
2075 d[3]=getNum3(c[0]);
2076 }
2077 if(a[0]==3&&b[0]==1)
2078 {
2079 d[0]=getNum3(start);
2080 d[1]=getNum(end);
2081 d[2]=getNum3(c[0]);
2082 d[3]=getNum(c[0]);
2083 }//1-3
2084 if(a[0]==1&&b[0]==4)
2085 {
2086 d[0]=getNum(start);
2087 d[1]=getNum4(end);
2088 d[2]=getNum(c[0]);
2089 d[3]=getNum4(c[0]);
2090 }
2091 if(a[0]==4&&b[0]==1)
2092 {
2093 d[0]=getNum4(start);
2094 d[1]=getNum(end);
2095 d[2]=getNum4(c[0]);
2096 d[3]=getNum(c[0]);
2097 }//1-4
2098 if(a[0]==1&&b[0]==5)
2099 {
2100 d[0]=getNum(start);
2101 d[1]=getNum5(end);
2102 d[2]=getNum(c[0]);
2103 d[3]=getNum5(c[0]);
2104 }
2105 if(a[0]==5&&b[0]==1)
2106 {
2107 d[0]=getNum5(start);
2108 d[1]=getNum(end);
2109 d[2]=getNum5(c[0]);
2110 d[3]=getNum(c[0]);
2111 }//1-5
2112 if(a[0]==1&&b[0]==6)
2113 {
2114 d[0]=getNum(start);
2115 d[1]=getNum6(end);
2116 d[2]=getNum(c[0]);
2117 d[3]=getNum6(c[0]);
2118 }
2119 if(a[0]==6&&b[0]==1)
2120 {
2121 d[0]=getNum6(start);
2122 d[1]=getNum(end);
2123 d[2]=getNum6(c[0]);
2124 d[3]=getNum(c[0]);
2125 }//1-6
2126 if(a[0]==2&&b[0]==3)
2127 {
2128 d[0]=getNum2(start);
2129 d[1]=getNum3(end);
2130 d[2]=getNum2(c[0]);
2131 d[3]=getNum3(c[0]);
2132 }
2133 if(a[0]==3&&b[0]==2)
2134 {
2135 d[0]=getNum3(start);
2136 d[1]=getNum2(end);
2137 d[2]=getNum3(c[0]);
2138 d[3]=getNum2(c[0]);
2139 }//2-3
2140 if(a[0]==2&&b[0]==4)
2141 {
2142 d[0]=getNum2(start);
2143 d[1]=getNum4(end);
2144 d[2]=getNum2(c[0]);
2145 d[3]=getNum4(c[0]);
2146 }
2147 if(a[0]==4&&b[0]==2)
2148 {
2149 d[0]=getNum4(start);
2150 d[1]=getNum2(end);
2151 d[2]=getNum4(c[0]);
2152 d[3]=getNum2(c[0]);
2153 }//2-4
2154 if(a[0]==2&&b[0]==5)
2155 {
2156 d[0]=getNum2(start);
2157 d[1]=getNum5(end);
2158 d[2]=getNum2(c[0]);
2159 d[3]=getNum5(c[0]);
2160 }
2161 if(a[0]==5&&b[0]==2)
2162 {
2163 d[0]=getNum5(start);
2164 d[1]=getNum2(end);
2165 d[2]=getNum5(c[0]);
2166 d[3]=getNum2(c[0]);
2167 }//2-5
2168 if(a[0]==2&&b[0]==6)
2169 {
2170 d[0]=getNum2(start);
2171 d[1]=getNum6(end);
2172 d[2]=getNum2(c[0]);
2173 d[3]=getNum6(c[0]);
2174 }
2175 if(a[0]==6&&b[0]==2)
2176 {
2177 d[0]=getNum6(start);
2178 d[1]=getNum2(end);
2179 d[2]=getNum6(c[0]);
2180 d[3]=getNum2(c[0]);
2181 }//2-6
2182 if(a[0]==3&&b[0]==4)
2183 {
2184 d[0]=getNum3(start);
2185 d[1]=getNum4(end);
2186 d[2]=getNum3(c[0]);
2187 d[3]=getNum4(c[0]);
2188 }
2189 if(a[0]==4&&b[0]==3)
2190 {
2191 d[0]=getNum4(start);
2192 d[1]=getNum3(end);
2193 d[2]=getNum4(c[0]);
2194 d[3]=getNum3(c[0]);
2195 }//3-4
2196 if(a[0]==3&&b[0]==5)
2197 {
2198 d[0]=getNum3(start);
2199 d[1]=getNum5(end);
2200 d[2]=getNum3(c[0]);
2201 d[3]=getNum5(c[0]);
2202 }
2203 if(a[0]==5&&b[0]==3)
2204 {
2205 d[0]=getNum5(start);
2206 d[1]=getNum3(end);
2207 d[2]=getNum5(c[0]);
2208 d[3]=getNum3(c[0]);
2209 }//3-5
2210 if(a[0]==3&&b[0]==6)
2211 {
2212 d[0]=getNum3(start);
2213 d[1]=getNum6(end);
2214 d[2]=getNum3(c[0]);
2215 d[3]=getNum6(c[0]);
2216 }
2217 if(a[0]==6&&b[0]==3)
2218 {
2219 d[0]=getNum6(start);
2220 d[1]=getNum3(end);
2221 d[2]=getNum6(c[0]);
2222 d[3]=getNum3(c[0]);
2223 }//3-6
2224 if(a[0]==4&&b[0]==5)
2225 {
2226 d[0]=getNum4(start);
2227 d[1]=getNum5(end);
2228 d[2]=getNum4(c[0]);
2229 d[3]=getNum5(c[0]);
2230 }
2231 if(a[0]==5&&b[0]==4)
2232 {
2233 d[0]=getNum5(start);
2234 d[1]=getNum4(end);
2235 d[2]=getNum5(c[0]);
2236 d[3]=getNum4(c[0]);
2237 }//4-5
2238 if(a[0]==4&&b[0]==6)
2239 {
2240 d[0]=getNum4(start);
2241 d[1]=getNum6(end);
2242 d[2]=getNum4(c[0]);
2243 d[3]=getNum6(c[0]);
2244 }
2245 if(a[0]==6&&b[0]==4)
2246 {
2247 d[0]=getNum6(start);
2248 d[1]=getNum4(end);
2249 d[2]=getNum6(c[0]);
2250 d[3]=getNum4(c[0]);
2251 }//4-6
2252 if(a[0]==5&&b[0]==6)
2253 {
2254 d[0]=getNum5(start);
2255 d[1]=getNum6(end);
2256 d[2]=getNum5(c[0]);
2257 d[3]=getNum6(c[0]);
2258 }
2259 if(a[0]==6&&b[0]==5)
2260 {
2261 d[0]=getNum6(start);
2262 d[1]=getNum5(end);
2263 d[2]=getNum6(c[0]);
2264 d[3]=getNum5(c[0]);
2265 }//5-6
2266 return d;
2267 }
2268 public int[] getviewnum1(int a[],int b[],String c[],String start,String end) {//123456
2269 int []d=new int[4];
2270 if(a[0]==1&&b[0]==2)
2271 {
2272 d[0]=getNum(start);
2273 d[1]=getNum2(end);
2274 d[2]=getNum(c[1]);
2275 d[3]=getNum2(c[1]);
2276 }
2277 if(a[0]==2&&b[0]==1)
2278 {
2279 d[0]=getNum2(start);
2280 d[1]=getNum(end);
2281 d[2]=getNum2(c[1]);
2282 d[3]=getNum(c[1]);
2283 }//1-2
2284 if(a[0]==1&&b[0]==5)
2285 {
2286 d[0]=getNum(start);
2287 d[1]=getNum5(end);
2288 d[2]=getNum(c[1]);
2289 d[3]=getNum5(c[1]);
2290 }
2291 if(a[0]==5&&b[0]==1)
2292 {
2293 d[0]=getNum5(start);
2294 d[1]=getNum(end);
2295 d[2]=getNum5(c[1]);
2296 d[3]=getNum(c[1]);
2297 }//1-5
2298 if(a[0]==3&&b[0]==6)
2299 {
2300 d[0]=getNum3(start);
2301 d[1]=getNum6(end);
2302 d[2]=getNum3(c[1]);
2303 d[3]=getNum6(c[1]);
2304 }
2305 if(a[0]==6&&b[0]==3)
2306 {
2307 d[0]=getNum6(start);
2308 d[1]=getNum3(end);
2309 d[2]=getNum6(c[1]);
2310 d[3]=getNum3(c[1]);
2311 }//3-6
2312 if(a[0]==4&&b[0]==5)
2313 {
2314 d[0]=getNum4(start);
2315 d[1]=getNum5(end);
2316 d[2]=getNum4(c[1]);
2317 d[3]=getNum5(c[1]);
2318 }
2319 if(a[0]==5&&b[0]==4)
2320 {
2321 d[0]=getNum5(start);
2322 d[1]=getNum4(end);
2323 d[2]=getNum5(c[1]);
2324 d[3]=getNum4(c[1]);
2325 }//4-5
2326 return d;
2327 }
2328 public String getjkl(int a,String start,String end) {//遍历链路
2329 String route="";
2330 if(a==1)
2331 {
2332 int b=getNum(start);
2333 int c=getNum(end);
2334 if(b<=c)
2335 {
2336 System.out.println(getSiter1(b,c));
2337 route=getSiter1(b,c);
2338 }
2339 if(b>c)
2340 {
2341 System.out.println(getSitek1(b,c));
2342 route=getSitek1(b,c);
2343 }
2344 }
2345 if(a==2)
2346 {
2347 int b=getNum2(start);
2348 int c=getNum2(end);
2349 if(b<=c)
2350 {
2351 System.out.println(getSiter2(b,c));
2352 route=getSiter2(b,c);
2353 }
2354 if(b>c)
2355 {
2356 System.out.println(getSitek2(b,c));
2357 route=getSitek2(b,c);
2358 }
2359 }
2360 if(a==3)
2361 {
2362 int b=getNum3(start);
2363 int c=getNum3(end);
2364 if(b<=c)
2365 {
2366 System.out.println(getSiter3(b,c));
2367 route=getSiter3(b,c);
2368 }
2369 if(b>c)
2370 {
2371 System.out.println(getSitek3(b,c));
2372 route=getSitek3(b,c);
2373 }
2374 }
2375 if(a==4)
2376 {
2377 int b=getNum4(start);
2378 int c=getNum4(end);
2379 if(b<=c)
2380 {
2381 System.out.println(getSiter4(b,c));
2382 route=getSiter4(b,c);
2383 }
2384 if(b>c)
2385 {
2386 System.out.println(getSitek4(b,c));
2387 route=getSitek4(b,c);
2388 }
2389 }
2390 if(a==5)
2391 {
2392 int b=getNum5(start);
2393 int c=getNum5(end);
2394 if(b<=c)
2395 {
2396 System.out.println(getSiter5(b,c));
2397 route=getSiter5(b,c);
2398 }
2399 if(b>c)
2400 {
2401 System.out.println(getSitek5(b,c));
2402 route=getSitek5(b,c);
2403 }
2404 }
2405 if(a==6)
2406 {
2407 int b=getNum6(start);
2408 int c=getNum6(end);
2409 if(b<=c)
2410 {
2411 System.out.println(getSiter6(b,c));
2412 route=getSiter6(b,c);
2413 }
2414 if(b>c)
2415 {
2416 System.out.println(getSitek6(b,c));
2417 route=getSitek6(b,c);
2418 }
2419 }
2420 return route;
2421 }
2422 public String getdouble(int num1,int num2) {//换乘点之间的路线
2423 String gsite="";
2424 String sql = "select * from huancheng";
2425 Connection conn = DBUtil.getConn();
2426 Statement state = null;
2427 ResultSet rs = null;
2428 try {
2429 state = conn.createStatement();
2430 rs = state.executeQuery(sql);
2431 List<subway> list = new ArrayList<subway>();
2432 while (rs.next()) {
2433 huancheng s=new huancheng();
2434 s.setSite(rs.getString("gsite"));
2435 s.setSec(rs.getInt("sec"));
2436 s.setFirst(rs.getInt("first"));
2437 if(num1==s.getFirst()&&num2==s.getSec())
2438 {
2439 gsite=s.getSite();
2440 }
2441 }
2442 } catch (Exception e) {
2443 e.printStackTrace();
2444 } finally {
2445 DBUtil.close(rs, state, conn);
2446 }
2447
2448 return gsite;
2449 }
2450 public String getdoublesite(int num1,int num2,String start,String end) {//一次换乘情况，且起始终点出现换乘站
2451 String route="";
2452 if(num1==1&&num2==2)
2453 {
2454 int []a=new int[2];
2455 int []b=new int[2];
2456 a[1]=0;b[1]=0;
2457 a[0]=1;
2458 b[0]=2;
2459 System.out.println(a[0]+","+b[0]);
2460 int []d=new int[4];
2461 String []c=new String[2];
2462 c=getgline(a, b);
2463 d=getviewnum(a, b, c, start, end);
2464 route=getview(a, b, d[0], d[2],d[1],d[3]);
2465 if(c[1]!="")
2466 {
2467 String route1="";
2468 System.out.println("");
2469 System.out.print("第二条路线:");
2470 c=getgline(a, b);
2471 d=getviewnum1(a, b, c, start, end);
2472 route=route+"**********";
2473 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2474 route=route+"第二条路线:"+route1;
2475 }
2476 }//1-2
2477 if(num1==2&&num2==1)
2478 {
2479 int []a=new int[2];
2480 int []b=new int[2];
2481 a[1]=0;b[1]=0;
2482 a[0]=2;
2483 b[0]=1;
2484 System.out.println(a[0]+","+b[0]);
2485 int []d=new int[4];
2486 String []c=new String[2];
2487 c=getgline(a, b);
2488 d=getviewnum(a, b, c, start, end);
2489 route=getview(a, b, d[0], d[2],d[1],d[3]);
2490 if(c[1]!="")
2491 {
2492 String route1="";
2493 System.out.println("");
2494 System.out.print("第二条路线:");
2495 c=getgline(a, b);
2496 d=getviewnum1(a, b, c, start, end);
2497 route=route+"**********";
2498 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2499 route=route+"第二条路线:"+route1;
2500 }
2501 }//2-1
2502 if(num1==1&&num2==3)
2503 {
2504 int []a=new int[2];
2505 int []b=new int[2];
2506 a[1]=0;b[1]=0;
2507 a[0]=1;
2508 b[0]=3;
2509 System.out.println(a[0]+","+b[0]);
2510 int []d=new int[4];
2511 String []c=new String[2];
2512 c=getgline(a, b);
2513 d=getviewnum(a, b, c, start, end);
2514 route=getview(a, b, d[0], d[2],d[1],d[3]);
2515 if(c[1]!="")
2516 {
2517 String route1="";
2518 System.out.println("");
2519 System.out.print("第二条路线:");
2520 c=getgline(a, b);
2521 d=getviewnum1(a, b, c, start, end);
2522 route=route+"**********";
2523 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2524 route=route+"第二条路线:"+route1;
2525 }
2526 }//1-3
2527 if(num1==3&&num2==1)
2528 {
2529 int []a=new int[2];
2530 int []b=new int[2];
2531 a[1]=0;b[1]=0;
2532 a[0]=3;
2533 b[0]=1;
2534 System.out.println(a[0]+","+b[0]);
2535 int []d=new int[4];
2536 String []c=new String[2];
2537 c=getgline(a, b);
2538 d=getviewnum(a, b, c, start, end);
2539 route=getview(a, b, d[0], d[2],d[1],d[3]);
2540 if(c[1]!="")
2541 {
2542 String route1="";
2543 System.out.println("");
2544 System.out.print("第二条路线:");
2545 c=getgline(a, b);
2546 d=getviewnum1(a, b, c, start, end);
2547 route=route+"**********";
2548 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2549 route=route+"第二条路线:"+route1;
2550 }
2551 }//3-1
2552 if(num1==1&&num2==4)
2553 {
2554 int []a=new int[2];
2555 int []b=new int[2];
2556 a[1]=0;b[1]=0;
2557 a[0]=1;
2558 b[0]=4;
2559 System.out.println(a[0]+","+b[0]);
2560 int []d=new int[4];
2561 String []c=new String[2];
2562 c=getgline(a, b);
2563 d=getviewnum(a, b, c, start, end);
2564 route=getview(a, b, d[0], d[2],d[1],d[3]);
2565 if(c[1]!="")
2566 {
2567 String route1="";
2568 System.out.println("");
2569 System.out.print("第二条路线:");
2570 c=getgline(a, b);
2571 d=getviewnum1(a, b, c, start, end);
2572 route=route+"**********";
2573 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2574 route=route+"第二条路线:"+route1;
2575
2576 }
2577 }//1-4
2578 if(num1==4&&num2==1)
2579 {
2580 int []a=new int[2];
2581 int []b=new int[2];
2582 a[1]=0;b[1]=0;
2583 a[0]=4;
2584 b[0]=1;
2585 System.out.println(a[0]+","+b[0]);
2586 int []d=new int[4];
2587 String []c=new String[2];
2588 c=getgline(a, b);
2589 d=getviewnum(a, b, c, start, end);
2590 route=getview(a, b, d[0], d[2],d[1],d[3]);
2591 if(c[1]!="")
2592 {
2593 String route1="";
2594 System.out.println("");
2595 System.out.print("第二条路线:");
2596 c=getgline(a, b);
2597 d=getviewnum1(a, b, c, start, end);
2598 route=route+"**********";
2599 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2600 route=route+"第二条路线:"+route1;
2601 }
2602 }//4-1
2603 if(num1==1&&num2==5)
2604 {
2605 int []a=new int[2];
2606 int []b=new int[2];
2607 a[1]=0;b[1]=0;
2608 a[0]=1;
2609 b[0]=5;
2610 System.out.println(a[0]+","+b[0]);
2611 int []d=new int[4];
2612 String []c=new String[2];
2613 c=getgline(a, b);
2614 d=getviewnum(a, b, c, start, end);
2615 route=getview(a, b, d[0], d[2],d[1],d[3]);
2616 if(c[1]!="")
2617 {
2618 String route1="";
2619 System.out.println("");
2620 System.out.print("第二条路线:");
2621 c=getgline(a, b);
2622 d=getviewnum1(a, b, c, start, end);
2623 route=route+"**********";
2624 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2625 route=route+"第二条路线:"+route1;
2626 }
2627 }//1-5
2628 if(num1==5&&num2==1)
2629 {
2630 int []a=new int[2];
2631 int []b=new int[2];
2632 a[1]=0;b[1]=0;
2633 a[0]=5;
2634 b[0]=1;
2635 System.out.println(a[0]+","+b[0]);
2636 int []d=new int[4];
2637 String []c=new String[2];
2638 c=getgline(a, b);
2639 d=getviewnum(a, b, c, start, end);
2640 route= getview(a, b, d[0], d[2],d[1],d[3]);
2641 if(c[1]!="")
2642 {
2643 String route1="";
2644 System.out.println("");
2645 System.out.print("第二条路线:");
2646 c=getgline(a, b);
2647 d=getviewnum1(a, b, c, start, end);
2648 route=route+"**********";
2649 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2650 route=route+"第二条路线:"+route1;
2651 }
2652 }//5-1
2653 if(num1==1&&num2==6)
2654 {
2655 int []a=new int[2];
2656 int []b=new int[2];
2657 a[1]=0;b[1]=0;
2658 a[0]=1;
2659 b[0]=6;
2660 System.out.println(a[0]+","+b[0]);
2661 int []d=new int[4];
2662 String []c=new String[2];
2663 c=getgline(a, b);
2664 d=getviewnum(a, b, c, start, end);
2665 route=getview(a, b, d[0], d[2],d[1],d[3]);
2666 if(c[1]!="")
2667 {
2668 String route1="";
2669 System.out.println("");
2670 System.out.print("第二条路线:");
2671 c=getgline(a, b);
2672 d=getviewnum1(a, b, c, start, end);
2673 route=route+"**********";
2674 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2675 route=route+"第二条路线:"+route1;
2676 }
2677 }//1-6
2678 if(num1==6&&num2==1)
2679 {
2680 int []a=new int[2];
2681 int []b=new int[2];
2682 a[1]=0;b[1]=0;
2683 a[0]=6;
2684 b[0]=1;
2685 System.out.println(a[0]+","+b[0]);
2686 int []d=new int[4];
2687 String []c=new String[2];
2688 c=getgline(a, b);
2689 d=getviewnum(a, b, c, start, end);
2690 route=getview(a, b, d[0], d[2],d[1],d[3]);
2691 if(c[1]!="")
2692 {
2693 String route1="";
2694 System.out.println("");
2695 System.out.print("第二条路线:");
2696 c=getgline(a, b);
2697 d=getviewnum1(a, b, c, start, end);
2698 route=route+"**********";
2699 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2700 route=route+"第二条路线:"+route1;
2701 }
2702 }//6-1
2703 if(num1==2&&num2==3)
2704 {
2705 int []a=new int[2];
2706 int []b=new int[2];
2707 a[1]=0;b[1]=0;
2708 a[0]=2;
2709 b[0]=3;
2710 System.out.println(a[0]+","+b[0]);
2711 int []d=new int[4];
2712 String []c=new String[2];
2713 c=getgline(a, b);
2714 d=getviewnum(a, b, c, start, end);
2715 route= getview(a, b, d[0], d[2],d[1],d[3]);
2716 if(c[1]!="")
2717 {
2718 String route1="";
2719 System.out.println("");
2720 System.out.print("第二条路线:");
2721 c=getgline(a, b);
2722 d=getviewnum1(a, b, c, start, end);
2723 route=route+"**********";
2724 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2725 route=route+"第二条路线:"+route1;
2726 }
2727 }//2-3
2728 if(num1==3&&num2==2)
2729 {
2730 int []a=new int[2];
2731 int []b=new int[2];
2732 a[1]=0;b[1]=0;
2733 a[0]=3;
2734 b[0]=2;
2735 System.out.println(a[0]+","+b[0]);
2736 int []d=new int[4];
2737 String []c=new String[2];
2738 c=getgline(a, b);
2739 d=getviewnum(a, b, c, start, end);
2740 route= getview(a, b, d[0], d[2],d[1],d[3]);
2741 if(c[1]!="")
2742 {
2743 String route1="";
2744 System.out.println("");
2745 System.out.print("第二条路线:");
2746 c=getgline(a, b);
2747 d=getviewnum1(a, b, c, start, end);
2748 route=route+"**********";
2749 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2750 route=route+"第二条路线:"+route1;
2751 }
2752 }//3-2
2753 if(num1==2&&num2==4)
2754 {
2755 int []a=new int[2];
2756 int []b=new int[2];
2757 a[1]=0;b[1]=0;
2758 a[0]=2;
2759 b[0]=4;
2760 System.out.println(a[0]+","+b[0]);
2761 int []d=new int[4];
2762 String []c=new String[2];
2763 c=getgline(a, b);
2764 d=getviewnum(a, b, c, start, end);
2765 route=getview(a, b, d[0], d[2],d[1],d[3]);
2766 if(c[1]!="")
2767 {
2768 String route1="";
2769 System.out.println("");
2770 System.out.print("第二条路线:");
2771 c=getgline(a, b);
2772 d=getviewnum1(a, b, c, start, end);
2773 route=route+"**********";
2774 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2775 route=route+"第二条路线:"+route1;
2776 }
2777 }//2-4
2778 if(num1==4&&num2==2)
2779 {
2780 int []a=new int[2];
2781 int []b=new int[2];
2782 a[1]=0;b[1]=0;
2783 a[0]=4;
2784 b[0]=2;
2785 System.out.println(a[0]+","+b[0]);
2786 int []d=new int[4];
2787 String []c=new String[2];
2788 c=getgline(a, b);
2789 d=getviewnum(a, b, c, start, end);
2790 route= getview(a, b, d[0], d[2],d[1],d[3]);
2791 if(c[1]!="")
2792 {
2793 String route1="";
2794 System.out.println("");
2795 System.out.print("第二条路线:");
2796 c=getgline(a, b);
2797 d=getviewnum1(a, b, c, start, end);
2798 route=route+"**********";
2799 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2800 route=route+"第二条路线:"+route1;
2801 }
2802 }//4-2
2803 if(num1==2&&num2==5)
2804 {
2805 int []a=new int[2];
2806 int []b=new int[2];
2807 a[1]=0;b[1]=0;
2808 a[0]=2;
2809 b[0]=5;
2810 System.out.println(a[0]+","+b[0]);
2811 int []d=new int[4];
2812 String []c=new String[2];
2813 c=getgline(a, b);
2814 d=getviewnum(a, b, c, start, end);
2815 route=getview(a, b, d[0], d[2],d[1],d[3]);
2816 if(c[1]!="")
2817 {
2818 String route1="";
2819 System.out.println("");
2820 System.out.print("第二条路线:");
2821 c=getgline(a, b);
2822 d=getviewnum1(a, b, c, start, end);
2823 route=route+"**********";
2824 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2825 route=route+"第二条路线:"+route1;
2826 }
2827 }//2-5
2828 if(num1==5&&num2==2)
2829 {
2830 int []a=new int[2];
2831 int []b=new int[2];
2832 a[1]=0;b[1]=0;
2833 a[0]=5;
2834 b[0]=2;
2835 System.out.println(a[0]+","+b[0]);
2836 int []d=new int[4];
2837 String []c=new String[2];
2838 c=getgline(a, b);
2839 d=getviewnum(a, b, c, start, end);
2840 route=getview(a, b, d[0], d[2],d[1],d[3]);
2841 if(c[1]!="")
2842 {
2843 String route1="";
2844 System.out.println("");
2845 System.out.print("第二条路线:");
2846 c=getgline(a, b);
2847 d=getviewnum1(a, b, c, start, end);
2848 route=route+"**********";
2849 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2850 route=route+"第二条路线:"+route1;
2851 }
2852 }//5-2
2853 if(num1==2&&num2==6)
2854 {
2855 int []a=new int[2];
2856 int []b=new int[2];
2857 a[1]=0;b[1]=0;
2858 a[0]=2;
2859 b[0]=6;
2860 System.out.println(a[0]+","+b[0]);
2861 int []d=new int[4];
2862 String []c=new String[2];
2863 c=getgline(a, b);
2864 d=getviewnum(a, b, c, start, end);
2865 route= getview(a, b, d[0], d[2],d[1],d[3]);
2866 if(c[1]!="")
2867 {
2868 String route1="";
2869 System.out.println("");
2870 System.out.print("第二条路线:");
2871 c=getgline(a, b);
2872 d=getviewnum1(a, b, c, start, end);
2873 route=route+"**********";
2874 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2875 route=route+"第二条路线:"+route1;
2876 }
2877 }//2-6
2878 if(num1==6&&num2==2)
2879 {
2880 int []a=new int[2];
2881 int []b=new int[2];
2882 a[1]=0;b[1]=0;
2883 a[0]=6;
2884 b[0]=2;
2885 System.out.println(a[0]+","+b[0]);
2886 int []d=new int[4];
2887 String []c=new String[2];
2888 c=getgline(a, b);
2889 d=getviewnum(a, b, c, start, end);
2890 route=getview(a, b, d[0], d[2],d[1],d[3]);
2891 if(c[1]!="")
2892 {
2893 String route1="";
2894 System.out.println("");
2895 System.out.print("第二条路线:");
2896 c=getgline(a, b);
2897 d=getviewnum1(a, b, c, start, end);
2898 route=route+"**********";
2899 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2900 route=route+"第二条路线:"+route1;
2901 }
2902 }//6-2
2903 if(num1==3&&num2==4)
2904 {
2905 int []a=new int[2];
2906 int []b=new int[2];
2907 a[1]=0;b[1]=0;
2908 a[0]=3;
2909 b[0]=4;
2910 System.out.println(a[0]+","+b[0]);
2911 int []d=new int[4];
2912 String []c=new String[2];
2913 c=getgline(a, b);
2914 d=getviewnum(a, b, c, start, end);
2915 route=getview(a, b, d[0], d[2],d[1],d[3]);
2916 if(c[1]!="")
2917 {
2918 String route1="";
2919 System.out.println("");
2920 System.out.print("第二条路线:");
2921 c=getgline(a, b);
2922 d=getviewnum1(a, b, c, start, end);
2923 route=route+"**********";
2924 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2925 route=route+"第二条路线:"+route1;
2926 }
2927 }//3-4
2928 if(num1==4&&num2==3)
2929 {
2930 int []a=new int[2];
2931 int []b=new int[2];
2932 a[1]=0;b[1]=0;
2933 a[0]=4;
2934 b[0]=3;
2935 System.out.println(a[0]+","+b[0]);
2936 int []d=new int[4];
2937 String []c=new String[2];
2938 c=getgline(a, b);
2939 d=getviewnum(a, b, c, start, end);
2940 route=getview(a, b, d[0], d[2],d[1],d[3]);
2941 if(c[1]!="")
2942 {
2943 String route1="";
2944 System.out.println("");
2945 System.out.print("第二条路线:");
2946 c=getgline(a, b);
2947 d=getviewnum1(a, b, c, start, end);
2948 route=route+"**********";
2949 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2950 route=route+"第二条路线:"+route1;
2951 }
2952 }//4-3
2953 if(num1==3&&num2==5)
2954 {
2955 int []a=new int[2];
2956 int []b=new int[2];
2957 a[1]=0;b[1]=0;
2958 a[0]=3;
2959 b[0]=5;
2960 System.out.println(a[0]+","+b[0]);
2961 int []d=new int[4];
2962 String []c=new String[2];
2963 c=getgline(a, b);
2964 d=getviewnum(a, b, c, start, end);
2965 route=getview(a, b, d[0], d[2],d[1],d[3]);
2966 if(c[1]!="")
2967 {
2968 String route1="";
2969 System.out.println("");
2970 System.out.print("第二条路线:");
2971 c=getgline(a, b);
2972 d=getviewnum1(a, b, c, start, end);
2973 route=route+"**********";
2974 route1=getview(a, b, d[0], d[2],d[1],d[3]);
2975 route=route+"第二条路线:"+route1;
2976 }
2977 }//3-5
2978 if(num1==5&&num2==3)
2979 {
2980 int []a=new int[2];
2981 int []b=new int[2];
2982 a[1]=0;b[1]=0;
2983 a[0]=5;
2984 b[0]=3;
2985 System.out.println(a[0]+","+b[0]);
2986 int []d=new int[4];
2987 String []c=new String[2];
2988 c=getgline(a, b);
2989 d=getviewnum(a, b, c, start, end);
2990 route=getview(a, b, d[0], d[2],d[1],d[3]);
2991 if(c[1]!="")
2992 {
2993 String route1="";
2994 System.out.println("");
2995 System.out.print("第二条路线:");
2996 c=getgline(a, b);
2997 d=getviewnum1(a, b, c, start, end);
2998 route=route+"**********";
2999 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3000 route=route+"第二条路线:"+route1;
3001 }
3002 }//5-3
3003 if(num1==3&&num2==6)
3004 {
3005 int []a=new int[2];
3006 int []b=new int[2];
3007 a[1]=0;b[1]=0;
3008 a[0]=3;
3009 b[0]=6;
3010 System.out.println(a[0]+","+b[0]);
3011 int []d=new int[4];
3012 String []c=new String[2];
3013 c=getgline(a, b);
3014 d=getviewnum(a, b, c, start, end);
3015 route= getview(a, b, d[0], d[2],d[1],d[3]);
3016 if(c[1]!="")
3017 {
3018 String route1="";
3019 System.out.println("");
3020 System.out.print("第二条路线:");
3021 c=getgline(a, b);
3022 d=getviewnum1(a, b, c, start, end);
3023 route=route+"**********";
3024 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3025 route=route+"第二条路线:"+route1;
3026 }
3027 }//3-6
3028 if(num1==6&&num2==3)
3029 {
3030 int []a=new int[2];
3031 int []b=new int[2];
3032 a[1]=0;b[1]=0;
3033 a[0]=6;
3034 b[0]=3;
3035 System.out.println(a[0]+","+b[0]);
3036 int []d=new int[4];
3037 String []c=new String[2];
3038 c=getgline(a, b);
3039 d=getviewnum(a, b, c, start, end);
3040 route=getview(a, b, d[0], d[2],d[1],d[3]);
3041 if(c[1]!="")
3042 {
3043 String route1="";
3044 System.out.println("");
3045 System.out.print("第二条路线:");
3046 c=getgline(a, b);
3047 d=getviewnum1(a, b, c, start, end);
3048 route=route+"**********";
3049 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3050 route=route+"第二条路线:"+route1;
3051 }
3052 }//6-3
3053 if(num1==4&&num2==5)
3054 {
3055 int []a=new int[2];
3056 int []b=new int[2];
3057 a[1]=0;b[1]=0;
3058 a[0]=4;
3059 b[0]=5;
3060 System.out.println(a[0]+","+b[0]);
3061 int []d=new int[4];
3062 String []c=new String[2];
3063 c=getgline(a, b);
3064 d=getviewnum(a, b, c, start, end);
3065 route=getview(a, b, d[0], d[2],d[1],d[3]);
3066 if(c[1]!="")
3067 {
3068 String route1="";
3069 System.out.println("");
3070 System.out.print("第二条路线:");
3071 c=getgline(a, b);
3072 d=getviewnum1(a, b, c, start, end);
3073 route=route+"**********";
3074 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3075 route=route+"第二条路线:"+route1;
3076 }
3077 }//4-5
3078 if(num1==5&&num2==4)
3079 {
3080 int []a=new int[2];
3081 int []b=new int[2];
3082 a[1]=0;b[1]=0;
3083 a[0]=5;
3084 b[0]=4;
3085 System.out.println(a[0]+","+b[0]);
3086 int []d=new int[4];
3087 String []c=new String[2];
3088 c=getgline(a, b);
3089 d=getviewnum(a, b, c, start, end);
3090 route=getview(a, b, d[0], d[2],d[1],d[3]);
3091 if(c[1]!="")
3092 {
3093 String route1="";
3094 System.out.println("");
3095 System.out.print("第二条路线:");
3096 c=getgline(a, b);
3097 d=getviewnum1(a, b, c, start, end);
3098 route=route+"**********";
3099 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3100 route=route+"第二条路线:"+route1;
3101 }
3102 }//5-4
3103 if(num1==4&&num2==6)
3104 {
3105 int []a=new int[2];
3106 int []b=new int[2];
3107 a[1]=0;b[1]=0;
3108 a[0]=4;
3109 b[0]=6;
3110 System.out.println(a[0]+","+b[0]);
3111 int []d=new int[4];
3112 String []c=new String[2];
3113 c=getgline(a, b);
3114 d=getviewnum(a, b, c, start, end);
3115 route=getview(a, b, d[0], d[2],d[1],d[3]);
3116 if(c[1]!="")
3117 {
3118 String route1="";
3119 System.out.println("");
3120 System.out.print("第二条路线:");
3121 c=getgline(a, b);
3122 d=getviewnum1(a, b, c, start, end);
3123 route=route+"**********";
3124 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3125 route=route+"第二条路线:"+route1;
3126 }
3127 }//4-6
3128 if(num1==6&&num2==4)
3129 {
3130 int []a=new int[2];
3131 int []b=new int[2];
3132 a[1]=0;b[1]=0;
3133 a[0]=6;
3134 b[0]=4;
3135 System.out.println(a[0]+","+b[0]);
3136 int []d=new int[4];
3137 String []c=new String[2];
3138 c=getgline(a, b);
3139 d=getviewnum(a, b, c, start, end);
3140 route=getview(a, b, d[0], d[2],d[1],d[3]);
3141 if(c[1]!="")
3142 {
3143 String route1="";
3144 System.out.println("");
3145 System.out.print("第二条路线:");
3146 c=getgline(a, b);
3147 d=getviewnum1(a, b, c, start, end);
3148 route=route+"**********";
3149 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3150 route=route+"第二条路线:"+route1;
3151 }
3152 }//6-4
3153 if(num1==5&&num2==6)
3154 {
3155 int []a=new int[2];
3156 int []b=new int[2];
3157 a[1]=0;b[1]=0;
3158 a[0]=5;
3159 b[0]=6;
3160 System.out.println(a[0]+","+b[0]);
3161 int []d=new int[4];
3162 String []c=new String[2];
3163 c=getgline(a, b);
3164 d=getviewnum(a, b, c, start, end);
3165 route=getview(a, b, d[0], d[2],d[1],d[3]);
3166 if(c[1]!="")
3167 {
3168 String route1="";
3169 System.out.println("");
3170 System.out.print("第二条路线:");
3171 c=getgline(a, b);
3172 d=getviewnum1(a, b, c, start, end);
3173 route=route+"**********";
3174 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3175 route=route+"第二条路线:"+route1;
3176 }
3177 }//5-6
3178 if(num1==6&&num2==5)
3179 {
3180 int []a=new int[2];
3181 int []b=new int[2];
3182 a[1]=0;b[1]=0;
3183 a[0]=6;
3184 b[0]=5;
3185 System.out.println(a[0]+","+b[0]);
3186 int []d=new int[4];
3187 String []c=new String[2];
3188 c=getgline(a, b);
3189 d=getviewnum(a, b, c, start, end);
3190 route=getview(a, b, d[0], d[2],d[1],d[3]);
3191 if(c[1]!="")
3192 {
3193 String route1="";
3194 System.out.println("");
3195 System.out.print("第二条路线:");
3196 c=getgline(a, b);
3197 d=getviewnum1(a, b, c, start, end);
3198 route=route+"**********";
3199 route1=getview(a, b, d[0], d[2],d[1],d[3]);
3200 route=route+"第二条路线:"+route1;
3201 }
3202 }//6-5
3203 return route;
3204 }
3205 }

Dao.java