±Û¾´ÀÌ :À¯´ë»ó 1999³â 9¿ù 21ÀÏ 17:33:00
In Reply to: [Áú¹®]JDBC - MS SQL Server7.0 ÇÑ±Û Â©¸² Çö»ó posted by À¯´ë»ó on 1999³â 9¿ù 20ÀÏ 14:52:11:
Weblogic »çÀÇ jdbcKona/MSSQLServer4 Driver¸¦ »ç¿ëÇϸé ©¸²Çö»óÀÌ ¾ø¾îÁý´Ï´Ù.
Weblogic»çÀÇ È¨ÆäÀÌÁö(www.weblogic.com)¿¡ °¡¸é trial ¹öÁ¯(30ÀÏ »ç¿ë)À» ´Ù¿î·ÎµåÇÏ¿© »ç¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
Á¤½Ä ¹öÁ¯Àº À¯·áÀÔ´Ï´Ù.
Á¦°¡ ¾Ë±â·Î´Â Java¿¡¼ SQLServer7.0À» Áö¿øÇÏ´Â µå¶óÀ̹ö(JDBC Driver)´Â ÀÌ°Í ¹Û¿¡ ¾ø´Â °Í °°½À´Ï´Ù.
´Ù¸¥ °ÍÀÌ ÀÖÀ¸¸é »¡¸® °¥ÄÑÁÖ¼¼¿ä! T.T
´ÙÀ½Àº µå¶óÀ̹ö¸¦ ÀÌ¿ëÇÑ °£´ÜÇÑ ¿¹Á¦ÀÔ´Ï´Ù.
(À§ÀÇ ¼Ò½º¸¦ º¯°æÇÑ °ÍÀÔ´Ï´Ù.)
import java.sql.*;
import weblogic.common.*;
class testApp
{
public static void main(String[] args)
throws IOException
{
String url="jdbc:weblogic:mssqlserver4:AgentDB@
150.183.109.61:1433";
String pQuery="INSERT INTO RealtimeSearch
(DateUserID,keyword,UserID) VALUES(?,?,?)";
try
{
Class.forName("weblogic.jdbc.mssqlserver4.
Driver").newInstance();
}catch(java.lang.ClassNotFoundException e)
{
System.out.println("driver loading error");
} catch(java.lang.IllegalAccessException ie)
{
System.out.println("driver loading error");
} catch(java.lang.InstantiationException e)
{
System.out.println("driver loading error");
}
Connection con=null;
PreparedStatement pstmt=null;
try
{
String DateUserID="¿ì¸® ³ª¶óÁÁÀº³ª¶óÀÔ´Ï´Ù.";
String strKeywords="±èÈñ¼±+ÅÚ·»Æ®+¹è¿ì";
String UserID="dsyou";
con =DriverManager.getConnection
(url,"AgentDBAdmin","");
pstmt=con.prepareStatement(pQuery);
pstmt.setString(1,DateUserID);
pstmt.setString(2,strKeywords);
pstmt.setString(3,UserID);
pstmt.executeUpdate();
}catch(java.sql.SQLException e)
{
System.out.println("*DB Save Fail[table:
RealtimeSearch]\n"+e.getMessage());
}
try
{
if(pstmt!=null)
{
pstmt.close();
con.close();
}
}catch(java.sql.SQLException e)
{
System.out.println("db close error");
}
}//fn end
}//class end
-- The End --