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
제목 | 글쓴이 | 날짜 | 조회 |
---|---|---|---|
2003-09-20 |
11798 |
||
2003-09-20 |
11346 |
||
2003-09-20 |
20442 |
||
지구인 |
2010-08-27 |
19283 |
|
지구인 |
2009-09-07 |
13587 |
|
2010-01-29 |
15556 |
||
2004-10-07 |
16659 |
||
2013-07-23 |
1724 |
||
지금이순감 |
2013-07-19 |
2348 |
|
hmily1314 |
2013-06-05 |
2044 |
|
2013-05-28 |
3086 |
||
2013-05-24 |
1477 |
||
2013-05-20 |
2029 |
||
2013-05-04 |
1812 |
||
2936 [웹 프로그래밍] 简单的游戏外挂 |
hmily1314 |
2013-04-28 |
2376 |
hmily1314 |
2013-04-22 |
2514 |
|
hmily1314 |
2013-04-14 |
1737 |
|
hmily1314 |
2013-04-14 |
1669 |
|
hmily1314 |
2013-04-14 |
2278 |
|
2931 [공개소스] 그누보드 4.36.20 |
2013-04-11 |
2365 |
|
2013-04-11 |
2226 |
||
2013-04-11 |
1460 |
||
2013-04-11 |
1500 |
||
2013-04-11 |
1606 |
||
2013-04-11 |
1416 |
||
2013-04-11 |
1535 |
||
진심은 |
2013-03-29 |
4125 |
|
진심은 |
2013-03-29 |
4142 |