Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java¿ª·¢DB2³ÌÐò

1. JDBC Çý¶¯³ÌÐò

1.1 DB2 JDBC Type 2 Çý¶¯³ÌÐò

DB2 ¿Í»§»ú

²»½¨ÒéʹÓÃ

COM.ibm.db2.jdbc.app.DB2Driver µ÷ÓÃClass.forName() ·½·¨¡£

1.2 IBM DB2 ͨÓÃJDBC ºÍSQLJ Çý¶¯³ÌÐò

ÌṩÁËType 2 Á¬½ÓÐÔºÍType 4 Á¬½ÓÐÔ

¿ÉÒÔ½«Õâ¸öÇý¶¯³ÌÐòÓÃÓÚapplet ºÍÓ¦ÓóÌÐò

com.ibm.db2.jcc.DB2Driver µ÷ÓÃClass.forName() ·½·¨¡£
2. ½¨Á¢Êý¾Ý¿âÁ¬½Ó

import java.sql.*; Í·Îļþ

String url = "jdbc:db2:sample"; TYPE 2

String url = "jdbc:db2:sample://localhost:50000"; TYPE4

Class.forName("com.ibm.db2.jcc.DB2Driver");

Connection con = DriverManager.getConnection(url);
3. Statement ¶ÔÏó

Statement ¶ÔÏóÊÇʹÓÃConnection.createStatement() ·½·¨´´½¨µÄ
Statement stmt;
stmt = con.createStatement();
stmt.executeUpdate("DELETE from EMPLOYEE WHERE EMPNO = '000099'");
ResultSet rs;
rs = stmt.executeQuery("SELECT EMPNO, LASTNAME from EMPLOYEE");
while (rs.next()) {
System.out.println(rs.getString(1) + ", " + rs.getDate(2));
}
4. PreparedStatement ¶ÔÏó

PreparedStatement ¶ÔÏóÊÇʹÓÃConnection.prepareStatement() ·½·¨´´½¨µÄ
pStmt = con.prepareStatement("UPDATE STAFF SET COMM=? WHERE ID=?");
pStmt.setDouble(1,710.53);
pStmt.setInt(2,350);
pStmt.executeUpdate();
5. Ìá½»ÊÂÎñ

con.setAutoCommit(true); ×Ô¶¯Ìá½»

con.commit(); ...

con.rollback();

Ö´Ðзֲ¼Ê½ÊÂÎñ

DB2XADataSource db2ds = new com.ibm.db2.jcc.DB2XADataSource();
6.¿ª·¢SQLJ Ó¦ÓóÌÐò(¾²Ì¬sql)
6.1 Ìí¼ÓÍ·Îļþ

import sqlj.runtime.*; Í·Îļþ

import java.sql.*; Í·Îļþ

6.2 ½¨Á¢Á¬½ÓÉÏÏÂÎÄ

#sql context Ctx;

String url = " jdbc:db2:sample://localhost:50000"; TYPE 4

Class.forName("com.ibm.db2.jcc.DB2Driver");

Ctx connCtx = new Ctx(url,true);

String url = " jdbc:db2:sample”; TYPE 2

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

6.3 ·¢³öSQL Óï¾ä


Ïà¹ØÎĵµ£º

ת£ºÉîÈëÀí½âjava¶à̬ÐÔ

 ¿´µ½ÕâÆª¹ØÓÚJava¶à̬µÄÌû×Ó£¬¾õµÃºÜ¶à£¬»ù±¾º­¸ÇÁËJava¶à̬µÄ¸÷ÖÖ³¡¾°£¬ÕâÀïת¸ø´ó¼Ò²Î¿¼£º
http://blog.csdn.net/thinkghoster/archive/2008/04/19/2307001.aspx
ÉîÈëÀí½âjava¶à̬ÐÔ
        ×òÌì¿´µ½Ò»¸ö¹ØÓÚ¶à̬ÐÔµÄÌû×Ó£¬²Î¿¼ÁË»ØÌûÕßµÄÀí½â£¬¼ÓÈëÁËһЩ×Ô¼ºµÄ¿´·¨£¬ÕûÀí ......

JAVAʵÏÖOracleÊý¾Ý¿âµÄÊý¾ÝµÄ·ÖÒ³ÏÔʾ

 
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum  rn from (select * from Person) a where  rownum <= MaxN ......

java»Øµ÷»úÖÆ

 »Øµ÷¸ÅÄî:
Èí¼þÄ£¿éÖ®¼ä×ÜÊÇ´æÔÚ×ÅÒ»¶¨µÄ½Ó¿Ú£¬´Óµ÷Ó÷½Ê½ÉÏ£¬¿ÉÒÔ°ÑËûÃÇ·ÖΪÈýÀࣺͬ²½µ÷Óᢻص÷ºÍÒì²½µ÷Óá£Í¬²½µ÷ÓÃÊÇÒ»ÖÖ×èÈûʽµ÷Ó㬵÷Ó÷½ÒªµÈ´ý¶Ô·½Ö´ÐÐÍê±Ï²Å·µ»Ø£¬ËüÊÇÒ»ÖÖµ¥Ïòµ÷Ó㻻ص÷ÊÇÒ»ÖÖË«Ïòµ÷ÓÃģʽ£¬Ò²¾ÍÊÇ˵£¬±»µ÷Ó÷½ÔÚ½Ó¿Ú±»µ÷ÓÃʱҲ»áµ÷ÓöԷ½µÄ½Ó¿Ú£»Òì²½µ÷ÓÃÊÇÒ»ÖÖÀàËÆÏûÏ¢»òʼþµÄ»úÖÆ£¬² ......

°Ñjava¿ª·¢µÄÓ¦ÓóÌÐò×ö³É°²×°³ÌÐò

·½·¨Ò»£º
   ÈôʹÓÃJBuilder7£¬²½ÖèÈçÏ£º 1¡¢Ê×ÏȽ¨Á¢¹¤³Ì£¬Application¡£ÕâЩ¾Í²»ÐèÒªÏêϸ˵Ã÷¡£ 2¡¢Ñ¡Ôñ²Ëµ¥WizardsϵÄarchive Builder 3¡¢ÔÚarchive typeÖÐÑ¡ÔñApplication 4¡¢ÔÚNameÑ¡ÏîÖиø¿ÉÖ´ÐгÌÐòÆðÃû£¬ÆäËûÑ¡ÏîĬÈÏ 5¡¢°üº¬½ø¸Ã¹¤³ÌÖÐËùÓеÄÀàºÍ×ÊÔ´ 6¡¢º¬Àà¿âÖÐËùÓеÄÀàºÍ×ÊÔ´ 7¡¢ÏÂÃæÁ½²½Ä¬ÈÏ 8¡¢ ......

ÄϾ©ÕÐÆ¸JAVA¿ª·¢¹¤³Ìʦ£¨ÔÂн7K£¬¿ÉÃæÒ飩

 http://www.ruijie.cc/Job_Info.php?id=142
ְλÃèÊö £º
¸ºÔðÄϾ©ÏîÄ¿µÄ¿ª·¢¡¢Î¬»¤¡£
ÈÎÖ°ÒªÇó £º
1¡¢3~5Ä깤×÷¾­Ñé
2¡¢JSP,structs »ù´¡Ôúʵ
3¡¢JavaScript½Å±¾ÊìϤ
4¡¢SQLÓï¾äÊìϤ
5¡¢Á˽âAjax»ù±¾¸ÅÄîºÍʵ¼ù¾­Ñé¡£
6¡¢ÊìÏ¤ÕÆÎÕJava¿ªÔ´¿ò¼ÜSSH£¨Spring¡¢Struts¡¢Hibernate£©
5¡¢×ö¹ý¹¤×÷Á÷ÏîÄ¿£¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ