android使用mysql的方法总结

1
compile files('libs/mysql-connector-java-5.1.18-bin.jar')

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
protected void onCreate(Bundle savedInstanceState) {

  super.onCreate(savedInstanceState);

  setContentView(R.layout.activity_jdbc);

  new Thread(runnable).start();

}

Handler myHandler=new Handler(){

  public void handleMessage(Message msg) {

    // TODO Auto-generated method stub

    super.handleMessage(msg);

    Bundle data=new Bundle();

    data=msg.getData();

    //System.out.println("id:"+data.get("id").toString());  //输出第n行，列名为“id”的值

    Log.e("TAG","id:"+data.get("id").toString());

    TextView tv= (TextView) findViewById(R.id.jdbc);

    //System.out.println("content:"+data.get("content").toString());

  }

};

Runnable runnable=new Runnable() {

  private Connection con = null;

  @Override

  public void run() {

    // TODO Auto-generated method stub

    try {

      Class.forName("com.mysql.jdbc.Driver");

      //引用代码此处需要修改，address为数据IP，Port为端口号，DBName为数据名称，UserName为数据库登录账户，Password为数据库登录密码

      con =

          //DriverManager.getConnection("jdbc:mysql://192.168.1.202:3306/b2b", "root", "");

      DriverManager.getConnection("jdbc:mysql://http://192.168.1.100/phpmyadmin/index.php:8086/b2b",

          UserName,Password);

    } catch (SQLException e) {

      // TODO Auto-generated catch block

      e.printStackTrace();

    } catch (ClassNotFoundException e) {

      // TODO Auto-generated catch block

      e.printStackTrace();

    }

    try {

      testConnection(con);  //测试数据库连接

    } catch (java.sql.SQLException e) {

      // TODO Auto-generated catch block

      e.printStackTrace();

    }

  }

  public void testConnection(Connection con1) throws java.sql.SQLException {

    try {

      String sql = "select * from ecs_users";    //查询表名为“oner_alarm”的所有内容

      Statement stmt = con1.createStatement();    //创建Statement

      ResultSet rs = stmt.executeQuery(sql);     //ResultSet类似Cursor

      //<code>ResultSet</code>最初指向第一行

      Bundle bundle=new Bundle();

      while (rs.next()) {

        bundle.clear();

        bundle.putString("id",rs.getString("userid"));

        //bundle.putString("content",rs.getString("content"));

        Message msg=new Message();

        msg.setData(bundle);

        myHandler.sendMessage(msg);

      }

      rs.close();

      stmt.close();

    } catch (SQLException e) {

    } finally {

      if (con1 != null)

        try {

          con1.close();

        } catch (SQLException e) {}

    }

  }

};

1
<uses-permission android:name=”android.permission.INTERNET”/>