package com.example.dbtest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Timer;
import java.util.TimerTask;
import android.app.Activity;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.util.Log;
import android.widget.ArrayAdapter;
import android.widget.ListView;
public class testactivity extends Activity {
ArrayList<String> list;
ArrayAdapter<String> adapter;
ListView listView;
final Handler handler = new Handler() {
public void handleMessage(Message msg) {
list.clear();
query2();
adapter.notifyDataSetChanged();
}
};
TimerTask myTask = new TimerTask(){
@Override
public void run()
{
Log.i("test", "timer");
Message msg = handler.obtainMessage();
handler.sendMessage(msg);
}
};
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
list = new ArrayList<String>();
adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, list);
listView = (ListView)findViewById(R.id.list);
listView.setAdapter(adapter);
// query2();
//
// 리스트뷰에 어댑터 연결
Timer timer = new Timer();
timer.schedule( myTask, 1000, 2000 );
}
public void query2()
{
Log.i("Android"," MSSQL Connect Example.");
Connection conn = null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Log.i("Connection","MSSQL driver load");
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/Soen_Database","sa","sa");
Log.i("Connection","MSSQL open");
Statement stmt = conn.createStatement();
ResultSet reset = stmt.executeQuery("select * from User");
while(reset.next()){
list.add(reset.getString(20)+" "+reset.getString(20)+" "+reset.getString(20)+" "+reset.getString(20)+" "+reset.getString(20));
}
conn.close();
}
catch (Exception e)
{
Log.w("Error connection","" + e.getMessage());
}
}
}
I/andorid ( 355): mssql connect example
I/Connection( 355): MSSql driver load
W/Error ( 355): null
I/test ( 355): timer
I/andorid ( 355): mssql connect example
I/Connection( 355): MSSql driver load
W/Error ( 355): null
I/test ( 355): timer
I/andorid ( 355): mssql connect example
I/Connection( 355): MSSql driver load
W/Error ( 355): null
LOGCAT 널 오류가 나는데. . . 디비는 들어가있는데 뭐가 문제인걸까요 ㅠㅠ