글쓴이 :장혜남 1999년 2월 05일 14:32:38
In Reply to: [질문]JDBC를 애플릿으로 Informix DBMS에 연결하는 방법... posted by 조신제 on 1999년 2월 04일 20:34:13:
제가 사용한 애플릿입니다.
import java.awt.*;
import java.applet.*;
import java.io.*;
import java.sql.*;
import java.net.*;
public class show extends Applet
{
static final String driver_class = "com.informix.jdbc.IfxDriver";
static final String connect_string = "jdbc:informix-sqli://128.134.11.1:2000/testDB2:
informixserver=duksung;user=h03022;password=********";
Connection conn;
int rc, cnt, j=0;
String cmd = null;
Statement sqlstmt = null;
PreparedStatement pstmt;
String s;
ResultSet r;
:
:
:
public void start(){
/***** CONNECTION PART *****/
try{
Class.forName(driver_class);
}
catch(Exception e){
}
try{
conn = DriverManager.getConnection(connect_string);
}
catch(SQLException e){
}
try{
if (temp.equals("92"))
pstmt = conn.prepareStatement("Select * from student where id_num > '92000
000' and id_num < '93000000' order by id_num");
else if (temp.equals("93"))
pstmt = conn.prepareStatement("Select * from student where id_num > '93000
000' and id_num < '94000000' order by id_num");
else if (temp.equals("94"))
pstmt = conn.prepareStatement("Select * from student where id_num > '94000
000' and id_num < '95000000' order by id_num");
}
catch(SQLException e){
}
try{
while(r.next()) {
:
s = r.getString(1);
:
}
catch(SQLException e){
}
} /* end of start */
:
:
: