解决该错误代码需要在onCreate(View view)方法中添加如下代码:即新建一个线程,防止在请求数据库时主线程卡死:
// Android 4.0 之后不能在主线程中请求HTTP请求
new Thread(new Runnable(){
@Override
public void run() {
try {
Class.forName("com.mysql.jdbc.Driver");
//获取数据库连接对象url=jdbc:mysql://IPAddress:3306/DatabaseName
connection= DriverManager.getConnection("jdbc:mysql://192.168.1.99:3306/wzglxt","root","root");
String sql="select * from user";//查询表中的所有内容
Statement statement=connection.createStatement();//创建Statement
ResultSet rs=statement.executeQuery(sql);
while (rs.next()){
sbmysql.append(rs.getInt("id")+"\t"+rs.getString("uname")+"\t"+rs.getString("pwd")+"\n");
}
textView.setText(sbmysql.toString());
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
textView.setText(e.toString());
}
}
}).start();