import java.net.UnknownHostException;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Iterator;
import java.util.List;
import java.util.regex.Pattern;
import org.junit.Test;
import java.sql.*;
import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.DBObject;
import com.mongodb.Mongo;
import com.mongodb.MongoException;
Public Class
MongoDB {
@Test
// MSSQL 연결
public void testMSSQLConnection() throws Exception {
// TODO Auto-generated method stub
Connection conSQL = null;
Statement stmt = null;
ResultSet rs = null;
// MSSQL
String strJDBCDrv = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String strJDBCUrl = "jdbc:sqlserver://localhost:1433;DatabaseName=SQLDB";
String strQuery = "select testID, testName from
T_Test order by testID desc";
// MongoDB
Mongo connection = new Mongo("MongoDBIP", 27017);
DB mongoJUnit = connection.getDB("testDB");
DBCollection dept =
mongoJUnit.getCollection("T_Test");
/*
try{
Class.forName(strJDBCDrv);
System.err.println("드라이버 검색 성공");
}
catch(ClassNotFoundException ee)
{
ee.printStackTrace();
System.err.println("드라이버 검색 실패");
}
*/
try {
Class.forName(strJDBCDrv).newInstance();
conSQL = DriverManager.getConnection(strJDBCUrl,
"sa", "1231231");
stmt =
conSQL.createStatement();
rs =
stmt.executeQuery(strQuery);
BasicDBObject putDB = new BasicDBObject();
//GregorianCalendar cal = new GregorianCalendar();
while(rs.next()){
// System.out.println(rs.getString(1));
putDB.put("testID", rs.getInt(1));
putDB.put("testName", rs.getString(2));
dept.insert(putDB);
putDB.clear();
}
}
catch (Exception
e){
e.printStackTrace();
}
finally {
conSQL.close();
stmt.close();
rs.close();
}
}
}
'Brain Trainning > NoSQL' 카테고리의 다른 글
[MongoDB] Config 파일 옵션 (0) | 2011.03.09 |
---|---|
[MongoDB] Java Code Sample (0) | 2011.02.28 |
[MongoDB] Comparing MongoDB java frameworks (0) | 2011.02.23 |
[MongoDB] 당신의 모든 Backup (0) | 2011.01.25 |
[MongoDB] MongoDB Cacti Plugin Templates (0) | 2011.01.21 |