[android] 안드로이드에서 mssql 직접연동하기

안드로이드에서 mssql 직접연동하기

 

안드로이드에서 mssql연동하기 위해 많이 헤매다가 만들었다.

 

우선 아래의 라이브러리를 추가해주어야한다.

 

jtds-1.2.5.jar

 

소스

 

package com.example.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.os.Handler;

import android.os.Message;

import android.util.Log;

import android.view.View;

import android.widget.ArrayAdapter;

import android.widget.ListView;

import android.os.AsyncTask;

 

public class MainActivity extends Activity {

ArrayList<String> list;

ArrayAdapter<String> adapter;

ListView listView;

 

private AsyncTask<String, String, String> mTask;

 

 

 

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.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);

 

mTask = new MyAsyncTask().execute();

}

 

public void query2()

{

Connection conn = null;

try {

Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();

conn = DriverManager.getConnection("jdbc:jtds:sqlserver://서버주소/DB이름","아이디","패스워드");

Statement stmt = conn.createStatement();

ResultSet reset = stmt.executeQuery("select * from v_state");

 

while(reset.next()){

list.add(reset.getString(1)+" "+reset.getString(2)+" "+reset.getString(3));

}

conn.close();

}

catch (Exception e)

{

Log.w("Error connection","" + e.getMessage());

}

}

// 아래함수가 중요

public class MyAsyncTask extends AsyncTask<String, String, String>
{
   // @Override
   protected void onPreExecute() {}
   // @Override
   protected String doInBackground(String... params) {
       if (isCancelled())
           return (null); // don't forget to terminate this method
       query2();
       return null;
   }
   //@Override
   protected void onPostExecute(String result) {}
   //@Override
   protected void onCancelled(){
       super.onCancelled();
   }

}

}