an_mysql.rar_ android Mysql_Android 数据库_Android数据库_MYSQL_android

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.EditText; import android.widget.TextView; public class AndroidMsql extends Activity { private EditText Et; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); Button btn=(Button)findViewById(R.id.btn); EditText Et=(EditText) findViewById(R.id.Et); btn.setOnClickListener(new OnClickListener() { @Override public void onClick(View v) { sqlCon(); } }); } private void sqlCon(){ try { Class.forName("com.mysql.jdbc.Driver"); } catch (Exception e) { e.printStackTrace(); } try { String url ="jdbc:mysql://192.168.1.10:3306/photo?user=dw&password=1234&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 worker";//查询user表语句 ResultSet rs=stmt.executeQuery(sql);//执行查询 StringBuilder str=new StringBuilder(); while(rs.next()){ str.append(rs.getString("workname")+"\n"); } EditText Et=(EditText)findViewById(R.id.Et); Et.setText(str); rs.close(); stmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }