package cjy.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.widget.ListView;
public class TestActivity extends Activity {
ListView list;
MyAdapter adapter;
ArrayList<MyData> arrData;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
query2();
//어댑터 생성
adapter = new MyAdapter(this, arrData);
//리스트뷰에 어댑터 연결
list = (ListView)findViewById(R.id.list);
list.setAdapter(adapter);
}
public void query2(){
Log.i("Android","MSSQL Connet Example.");
Connection conn = null;
Log.i("Android","1");
try{
Log.i("Android","2");
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Log.i("Connection","MSSQL driver load");
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://"+mssqlurl);
Log.i("Connection","MSSQL open");
Statement stmt = conn.createStatement();
ResultSet reset = stmt.executeQuery("select cust03,comp02,cust04 from cm_cust inner join cm_comp on custid01 = compid ");
arrData = new ArrayList<MyData>();
while(reset.next()){
arrData.add(new MyData(R.drawable.ic_launcher, reset.getString(0), reset.getString(1), reset.getString(2)));
}
conn.close();
}catch(Exception e){
Log.w("Error connection",""+e.getMessage());
}
}
}
접속정보는 제대로 입력을 했는데요.
자꾸 net.sourceforge.jtds.jdbc.Driver Error connection
이렇게 LogCat 에 남네요.
공부하는데 이부분때문에 진행이 안나갑니다.
자바는 초보입니다. 잘 부탁드려요.
