3.26全部完成android和web端的地铁查询系统
web端的思想在前面已经写了,Android端的思想
跟web端差不多少,其中不一样的就是连接MySQL
数据库,其要求的jar包是5版本左右的,而且还涉及
到线程的问题,在连接MySQL的时候要另外启动一个
线程进行连接,主要思想上没啥改变,就是每次每种
查询要加一个button并且对应Onclick事件,在这个事件
里面启动一个新的线程。
我的队友是高一榀,我俩在此次开发中收获了很多。
以下是改变部分的代码:
package mysqll;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBOpenHelper {
private final static String driver = "com.mysql.jdbc.Driver";
private final static String url = "jdbc:mysql://10.99.121.251/kebiao?useUnicode=true&characterEncoding=UTF-8&useSSL=false";//
private final static String username = "root";
private final static String password = "123456";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
System.out.println("加载驱动错误");
}
}
//2. 获取连接
public static Connection getConnect() throws Exception {
return DriverManager.getConnection(url, username, password);
}
//3. 释放连接资源
public static void release(Connection conn, Statement st, ResultSet rs) throws Exception {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
}
/*private static String diver = "com.mysql.jdbc.Driver";
//加入utf-8是为了后面往表中输入中文,表中不会出现乱码的情况
private static String url = "jdbc:mysql://10.99.117.52/xinwe?characterEncoding=utf-8";
private static String user = "root";//用户名
private static String password = "hzl02096";//密码
*//*
* 连接数据库
* *//*
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(diver);
conn = (Connection) DriverManager.getConnection(url,user,password);//获取连接
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}*/
}
public int findstationsatrole(String roles) throws Exception {
Connection conn = null;
Statement state = null;
ResultSet find = null;
int stationsnumber = 0;
try {
conn = DBOpenHelper.getConnect();
state = conn.createStatement();
roles = roles + "号线";
String sql = "SELECT sname FROM biejing_subway"
+ " WHERE sline='" + roles + "';";
find = state.executeQuery(sql);
stationsnumber = -1;
while (find.next()) {
stationsnumber++;
onrolestation[stationsnumber] = new String();
onrolestation[stationsnumber] = find.getString(1);
}
if (stationsnumber != -1) {
for (int i = 0; i <= (stationsnumber / 2) + 1; i++) {
stationss = stationss + onrolestation[i]+" , ";
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBOpenHelper.release(conn, state, find);
}
return stationsnumber;
}
public int findrolesatstation(String stations) throws Exception {
Connection conn = null;
Statement state = null;
ResultSet find = null;
int stationsnumber = 0;
int rolesnumber = 0;
try {
conn = DBOpenHelper.getConnect();
state = conn.createStatement();
String sql = "SELECT sline FROM biejing_subway"
+ " WHERE sname='" + stations + "';";
find = state.executeQuery(sql);
rolesnumber = -1;
int zhuanhuan = 0;
while (find.next()) {
if (zhuanhuan % 2 == 0) {
rolesnumber++;
onstationatroles[rolesnumber] = new String();
onstationatroles[rolesnumber] = find.getString(1);
}
System.out.print(rolesnumber);
zhuanhuan++;
}
if(rolesnumber!=-1) {
for (int i = 0; i <= rolesnumber; i++) {
rolessss = rolessss + onstationatroles[i] + " , ";
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBOpenHelper.release(conn, state, find);
}
return rolesnumber;
}