INFORMIX JDBC ¼³Á¤Çϱâ
¼³Ä¡ ȯ°æ
* jdk 1.3.1_02
* apache 1.3.22
* tomcat 4.0
* window 2000 professional
* informix´Â 7.xx unix
0. ¿ì¼± jdk¸¦ ¼³Ä¡ÇÏ°í, classpath±îÁö ¼³Á¤ÇÑ´Ù.
1. informix jdbc ÇÁ·Î±×·¥À» ´Ù¿î·Îµå
- ÇöÀç 2.2 ¹öÀü±îÁö ÀÖÀ½(setup.class)
2. µµ½º¸ðµå¿¡¼ ´ÙÀ½À» ÀÔ·Â (windowsÀÏ °æ¿ì)(serial #, key #´Â ÀúÈñ ȸ»ç°ÍÀ¸·Î ÀÔ·ÂÇß½À´Ï´Ù.)
2-1. interactive setup ÀÏ °æ¿ì
- java setup ? interactive setup
- ȸ鿡 ³ª¿À´Â ÁøÇà ¼ø¼´ë·Î ÁøÇà(°æ·ÎÁöÁ¤->serial #, key # ÀÔ·Â)
2-2. silently setup ÀÏ °æ¿ì
- java setup -o ¼³Ä¡ÇÒ°æ·Î serial=serial# key=key#
3. classpath¿¡ ´ÙÀ½ ÆÄÀÏÀ» µî·Ï
- ifxjdbc.jar, ifxsqlj.jar, ifxtools.jar
4. tomcat ÇÁ·Î±×·¥Æú´õ\common\lib Æú´õ ¹Ø¿¡ ifxjdbc.jar ÆÄÀÏÀ» º¹»ç
-tomcat4.0ÀÇ °æ¿ì ÀÚü ¹ö±×ÀÎÁöµµ ¸ô¶óµµ ¿À¶óŬÀÇ °æ¿ì classes12.zip ÆÄÀÏÀ» classes12.jar·Î º¯°æÇؼ ÀÌ°÷¿¡ º¹»çÇØ¾ß ¿À¶óŬÀ» »ç¿ëÇÒ ¼ö ÀÖÀ½.
- ±×·¡¼ ÀÎÆ÷¹Í½ºµµ ÀÌ·¸°Ô º¹»ç¸¦ ÇØ¾ß »ç¿ëÇÒ ¼ö ÀÖÀ½.
5. tomcat ÇÁ·Î±×·¥Æú´õ\bin Æú´õ ¹Ø¿¡ ÀÖ´Â catalina.sh ÆÄÀÏÀ» edit (CLASSPATHÃß°¡)
-¿¹) CP="$CATALINA_HOME/bin/bootstrap.jar:$CLASSPATH"
-ÀÌÀ¯) tomcat ÇÁ·Î±×·¥ÀÌ classpath¸¦ ÀνÄÇÏÁö ¸øÇÏ´Â ¹®Á¦
6. Å×½ºÆ®
<%@ page contentType="text/html; charset=EUC-KR" %>
<%@ page language="java" import="java.io.*,java.sql.*" %>
<%
/*µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» À§ÇÑ º¯¼ö
ur1 : DB ¼¹öÀÇ Á¾·ù, ip, sid
conn : µ¥ÀÌÅͺ£À̽º Ä¿³Ø¼Ç ¼±¾ð
stmt : SQL ±¸¹® ½ÇÇàÀ» À§ÇÑ statement ¼±¾ð
pstmt : SQL ±¸¹® ½ÇÇàÀ» À§ÇÑ preparedstatement ¼±¾ð
*/
String url = "jdbc:informix-sqli://dbserver_ipaddress:port/dbname:INFORMIXSERVER=servername;user=username;password=userpassword";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String strQuery = "";
strQuery = "select tabname, owner from systables";
out.println("
"+strQuery);
%>
<%
try
{
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
//Query Execution
}
catch (Exception e)
{
out.println("err");
out.println(e.getMessage());
}
%>
Å×À̺í¸í | ¼Ó¼º |
<%=col1%> | <%=col2%> |