使用JDBC从Android连接到MySQL

我用下面的代码连接MySQL在localhost从Android系统。它仅显示catch部分中给出的操作。我不知道是否是连接问题。


package com.test1;


import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;


import android.app.Activity;

import android.os.Bundle;

import android.widget.TextView;


public class Test1Activity extends Activity {

    /** Called when the activity is first created. */

    String str="new";

    static ResultSet rs;

    static PreparedStatement st;

    static Connection con;


    @Override

    public void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.main);

        final   TextView tv=(TextView)findViewById(R.id.user);


        try

        {

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

              con=DriverManager.getConnection("jdbc:mysql://10.0.2.2:8080/example","root","");

            st=con.prepareStatement("select * from country where id=1");

            rs=st.executeQuery();

             while(rs.next())

             {

             str=rs.getString(2);



             }



            tv.setText(str);

            setContentView(tv);

        }

        catch(Exception e)

        {

            tv.setText(str);

        }

    }

}

当此代码执行时,它在avd中显示“new”。


java.lang.management.ManagementFactory.getThreadMXBean, referenced from method com.mysql.jdbc.MysqlIO.appendDeadlockStatusInformation

Could not find class 'javax.naming.StringRefAddr', referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.storeTo

Could not find method javax.naming.Reference.get, referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.initializeFrom

有谁能建议一些解决方案?并提前感谢


当年话下
浏览 651回答 3
3回答
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

Android
MySQL