当前位置:   article > 正文

mysql数据库与app_mysql数据库怎么连接到安卓app

app连接本地mysql数据库 那打包之后 app要怎么连到数据库

105cdcc58ec395e19f709415a553460e.png

largeQ

android 链接mysql数据库实例:package com.hl;import java.sql.DriverManager;import java.sql.ResultSet;import com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;import android.app.Activity;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.TextView;public class AndroidMsql extends Activity {@Overridepublic void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.main);Button btn=(Button)findViewById(R.id.btn);btn.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {sqlCon();}});}private void mSetText(String str){TextView txt=(TextView)findViewById(R.id.txt);txt.setText(str);}private void sqlCon(){try {Class.forName("com.mysql.jdbc.Driver");} catch (Exception e) {e.printStackTrace();}try {String url ="jdbc:mysql://192.168.142.128:3306/mysql?user=zzfeihua&password=12345&useUnicode=true&characterEncoding=UTF-8";//链接数据库语句Connection conn= (Connection) DriverManager.getConnection(url); //链接数据库Statement stmt=(Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql="select * from user";//查询user表语句ResultSet rs=stmt.executeQuery(sql);//执行查询StringBuilder str=new StringBuilder();while(rs.next()){str.append(rs.getString(1)+"\n");}mSetText(str.toString());rs.close();stmt.close();conn.close();} catch (Exception e) {e.printStackTrace();}}}不过eclipse老是提示:warning: Ignoring InnerClasses attribute for an anonymous inner class that doesn't come with an associated EnclosingMethod attribute. (This class was probably produced by a broken compiler.)

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/盐析白兔/article/detail/267213
推荐阅读
相关标签
  

闽ICP备14008679号