글쓴이 :장진우 2000년 5월 03일 15:25:14
In Reply to: 혹시..(바이너리 변환) posted by 앙마 on 2000년 5월 03일 14:21:20:
답변 감사드리구요...
찾으시는 사람은 아니구요..
아래처럼 하라는 얘기이신가요?
아래처럼 하면 똑같이 나오는데요...
한번 더 도움 주시면 감사하겠습니다.
byte[] bt = new byte[30];
bt = resultset.getBytes (column);
field = bt.toString();
System.out.println("field: " + field);
테스트한 샘플 소스는 아래와 같구요...
다시 한번 설명을 드리면 table01의 field3에 "0xFFFFFF" 라는 값이 들어있을때
아래 샘플을 실행시키면 "[B@bed0a620" 같은 이상한 값이 나오네요..
<< table01 >>
CREATE TABLE table01 (
field1 int NOT NULL ,
field2 varchar(10) NOT NULL ,
field3 binary(3) NOT NULL
)
<< dbConnect.java >>
import java.sql.*;
public class dbConnect {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ResultSetMetaData rsmd = null;
Object[] columnName = null;
Object[][] dataTable = null;
static int colCount = 0;
static int rowCount = 0;
public dbConnect (String driver, String url, String username, String passwd) {
try {
Class.forName (driver);
conn = DriverManager.getConnection (url, username, passwd);
}
catch (ClassNotFoundException e1) {
System.out.println (e1.getMessage());
}
catch (SQLException e2) {
System.out.println (e2.getMessage());
}
}
public void dbExecuteQuery (String query) {
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
rsmd = rs.getMetaData();
colCount = rsmd.getColumnCount();
columnName = new Object[colCount];
for (int i=0;i<colCount;i++) {
columnName[i] = rsmd.getColumnLabel(i+1);
}
dataTable = new Object[100][colCount];
int i =0;
while (rs.next()) {
for (int j=0;j<colCount;j++) {
dataTable[i][j] = rs.getObject ((String)columnName[j]);
}
i++;
rowCount++;
}
}
catch(SQLException e3) {
System.out.println (e3.getMessage());
}
}
public void dbDisconnect() {
try {
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
}
catch (SQLException e4) {
System.out.println (e4.getMessage());
}
}
}
<< myTest01.java >>
import java.sql.*;
import javax.swing.*;
import java.awt.Dimension;
public class myTest01 {
static String driver = null;
static String url = null;
static String uname = null;
static String passwd = null;
static String query = null;
public myTest01 (String driver, String url, String uname, String passwd, String query) {
dbConnect dc = new dbConnect (driver, url, uname, passwd);
System.out.println ("Connect...");
dc.dbExecuteQuery (query);
JFrame frame = new JFrame ("myTest");
JTable myTable = new JTable (dc.dataTable, dc.columnName);
JScrollPane scrollpane = new JScrollPane (myTable);
scrollpane.setPreferredSize (new Dimension(700, 300));
frame.getContentPane().add(scrollpane);
frame.pack();
frame.setVisible(true);
dc.dbDisconnect();
System.out.println ("Disconnect..");
}
public static void main (String[] args) {
driver = "sun.jdbc.odbc.JdbcOdbcDriver";
url = "jdbc:odbc:MYDSN";
uname = "user";
passwd = "pass";
query = "select * from table01";
new myTest01 (driver, url, uname, passwd, query);
}
}