Android에서 데이터베이스에 직접접근하려면(java도 마찬가지겠죠)

jtds.jar를 import 시켜주면 됩니다.

java build path =>

1 .Libraries => Add External JARs

2.Order and Export (jtds.jar 선택)

mssql연결소스 :

try {
   System.out.println("01");
   Class.forName("net.sourceforge.jtds.jdbc.Driver");
   System.out.println("02");
   conn = DriverManager.getConnection("jdbc:jtds:sqlserver://" + url + ";databaseName="+ dbName + ";", "아이디", "패스워드");
   System.out.println("03");
   if(conn != null) stmt = conn.createStatement();
   System.out.println("04");
   if(conn != null){
    System.out.println("conn : "+conn);
   }else{
    System.out.println("conn : 연결안됨");
   }
   System.out.println("05");
   if(stmt != null){
    System.out.println("stmt : "+stmt);
   }else{
    System.out.println("stmt : 생성안됨");
   }
   
  } catch (ClassNotFoundException e) {
   System.out.println("error 01 ==========================");
   e.printStackTrace();
   StackTraceElement[] elem = e.getStackTrace();
   DataLoader.writeErrorLog(elem, e.getMessage(), insertLog);
   return false;
  } catch (IllegalArgumentException e) {
   System.out.println("error 02 ==========================");
   e.printStackTrace();
   StackTraceElement[] elem = e.getStackTrace();
   DataLoader.writeErrorLog(elem, e.getMessage(), insertLog);
   return false;
  } catch (SQLException e) {
   System.out.println("error 03 ==========================");
   e.printStackTrace();
   StackTraceElement[] elem = e.getStackTrace();
   DataLoader.writeErrorLog(elem, e.getMessage(), insertLog);
   return false;
  }

기타 데이터베이스 연결스트링

mysql connetString : jdbc:mysql://hostname/myDatabase?autoReconnect=true

derby connectString : jdbc:derby:database-location;create=false

oracle connectString : jdbc:oracle:thin:@hostname:1521:SID

db2 connectString : jdbc:db2:myDatabase

sybase connectString : jdbc:jtds:sybase://hostname:4000/database

ms access connectString : jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0; Data Source=//{database server name}/{database shared folder}/{database name}.mdb;jet oledb:system database=//{workgroup server name}/{workgroup shared folder}/{workgroup name}.mdw;IzmRoyaltyFree=643223965;IzmJdbcEsc=yes

주의할점 : jdk버전과 jtds버전을 맞추어야 합니다.

jtds 2.5 는 jdk 1.6

jtds 3.0 은 jdk 1.7