androidé¤äºsqliteæ°æ®åºï¼è¿æ¯å¯ä»¥ä½¿ç¨mysqlæ°æ®åºï¼ä½¿ç¨æ¥éª¤å¦ä¸ï¼
1. å
³émysqlæå¡å¨çé²ç«å¢ã
2. å å
¥MySQLçjdbcå
ï¼æ·»å å°libsæ件夹å
ã
3.ADTåSDK为16å16以ä¸ï¼17以ä¸çä¸è½è®¿é®ã
4.ææºåmysqæå¡å¨läºç¸pingéã
5.æ·»å ç½ç»æé ï¼ <uses-permission Android:name="android.permission.INTERNET" />
6.å¨Threadä¸è¿æ¥è®¿é®mysqlï¼é²æ¢ANRã
7.设置mysqlå
许è¿ç¨è¿æ¥ã
代ç å¦ä¸ï¼
package com.mayi.mysql_test;
import java.sql.DriverManager;
import java.sql.ResultSet;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import android.os.Bundle;
import android.app.Activity;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
public class MainActivity extends Activity {
private static final String TAG = "MainActivity";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
findViewById(R.id.select).setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
select();
}
});
}
public void select(){
try{
//è°ç¨Class.forName()æ¹æ³å 载驱å¨ç¨åº
Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("æåå è½½MySQL驱å¨ï¼");
String url="jdbc:mysql://192.168.1.113:3306/test"; //JDBCçURL
Connection conn;
conn = (Connection) DriverManager.getConnection(url,"mayi","123456");
Statement stmt = (Statement) conn.createStatement(); //å建Statement对象
System.out.println("æåè¿æ¥å°æ°æ®åºï¼");
String sql = "select * from person"; //è¦æ§è¡çSQL
ResultSet rs = stmt.executeQuery(sql);//å建æ°æ®å¯¹è±¡
System.out.println("ç¼å·"+"\t"+"å§å"+"\t"+"å¹´é¾");
while (rs.next()){
System.out.print(rs.getInt(1) + "\t");
System.out.print(rs.getString(2) + "\t");
System.out.print(rs.getString(3) + "\t");
System.out.print(rs.getString(4) + "\t");
System.out.println();
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e)
{
Log.e(TAG, e.getMessage());
e.printStackTrace();
}
}
}