赞
踩
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.)
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。