在A(yíng)ndroid中訪(fǎng)問(wèn)電腦數據庫,問(wèn)電可以使用以下步驟:
(圖片來(lái)源網(wǎng)絡(luò )(′▽?zhuān)?,腦數侵刪)1、據庫安裝MySQL JDBC驅動(dòng)
2、問(wèn)電添加網(wǎng)絡(luò )權限
在A(yíng)ndroidManifest.xml文件中添加網(wǎng)絡(luò )權限:
??220;`xml
<u(′?`)sespermission android:name="android.permission.INTERNET" />
“`
3、腦數編寫(xiě)代碼連接數據庫
創(chuàng )建一個(gè)類(lèi)((′?`*)如DBHelper),據庫用于連接數據??庫:
“`java
impor??t java.sql.DriverManager;
import java.sヾ(′?`)?ql.ResultSet;
import java.sql.State(′?`)ment;
public class DBHelper {
private static final String URL = "jdbc:mysql://電腦IP地址:端口號/數據庫名";
private static final String USER = "用戶(hù)名";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL,問(wèn)電 USER, PASSWORD);
} catch (E??xception e) {
e.printStackTrace();
}
return con??n;
}
}
“`
4、查詢(xún)數據
“`java
import androi(???)d??.os.Bundle;
import android.widget.ArrayAdapter;
import androidx.appcompat.app.AppCompatActiヽ(′▽?zhuān)?ノvity;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util(′?`).ArrayList;
import java.util.List;
public class MainActivit(′?`)y extends AppCompatActivi??ty {
priva(′?ω?`)te ListView listView;
private List<String> dataList?? = new ArrayList<>();
private ArrayAdapter<String> ad┐(′?`)┌apter;
@Override
protected void onCreate(Bundle sa??vedInsヽ(′?`)ノtanceState) {
super.onCreate(savedInstanceS??tate);
setContentView(R.layout.activity_main);
adapter = new ArrayAdapter<>(this,問(wèn)電 android.R.layout.simple_list_it(′?`*)em_1, dataList);
list(′▽?zhuān)?View.setAdapter(adapter);??
getDataFromDB();
}
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
tr??y {
connection = DBHelper.getConnection();
statement = connection??.createStatement();
while (resultSet.next())?? {
dataList.add(d??ata);
}
} catch (Exception e) {
} finally {
try {
if (resultSet != null) {
}
if (statement != null) {
}
if (connection != null) {
connection.?close();
}
e.printStac(???)kTr??ace(???);
}
}
adap(′▽?zhuān)?ter.notifyDataSetChanged(); // 刷新列表顯示數據更新后的結果集內容,如果數據沒(méi)有變化,腦數可以省略這一步(bu)。據庫