안드로이드를 배우고 있는 학생입니다
지금 mysql에 있는 데이터를 listview에 뿌려주려고 하는데
접근 방법 자체를 모르겠네요 ㅜㅜ
책이나 구글링을 통해 찾아봐도 햇갈리기만 하고..
php파일을 이용해서 데이터를 가져오는건 맞죠...?
제가 하는 방법이 뭐가 잘못된건지..좀 알려주세요 부탁드립니다...몇 일째 막히네요..
package com.example.androidproject;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import android.app.Activity;
import android.database.SQLException;
import android.os.Bundle;
import android.view.Menu;
public class Lock1Activity extends Activity {
public static void mian(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String url = "jdbc:mysql://localhost/jongjin";
String sql = "select * from db";
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,"root", "apmesetup");
System.out.println("연결 성공");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
System.out.println("No\tName\t Phone");
System.out.println("--------------------");
while (rs.next()) {
System.out.print(rs.getString("name")+"\t");
System.out.print(rs.getString("subname")+"\t");
System.out.print(rs.getString("period")+"\t");
System.out.print(rs.getString("place")+"\t");
System.out.print(rs.getString("time")+"\t");
System.out.print(rs.getString("intro")+"\t");
System.out.print(rs.getString("region")+"\t");
System.out.print(rs.getString("month")+"\t");
System.out.print(rs.getString("auspice")+"\t");
System.out.print(rs.getString("manage")+"\t");
System.out.print(rs.getString("sponsor")+"\t");
System.out.print(rs.getString("hom")+"\t");
}
}
catch (Exception e) {
e.printStackTrace();
}finally {
try {
if(rs != null)rs.close();
if(stmt != null)stmt.close();
if(conn != null)conn.close();
}catch (SQLException e){
e.printStackTrace();
}
}
}
};
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_lock1);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.activity_lock1, menu);
return true;
}
}