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

oracleµ÷ÓÃjava³ÌÐòÁ¬sqlserver2005

1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
    public static String entry(String str1,String str2) {
       String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
       // ¼ÓÔØjdbcÇý¶¯
    String a = "0";
       String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=wb"; // Á´½ÓÊý¾Ý¿â·þÎñºÍÇý¶¯sample
       String userName = "sa"; // Óû§Ãû
       String userPwd = "giap"; // ÃÜÂë
       Connection dbConn;
       try {
      a = "1";
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           String sql = "insert into ry_jbxx (RYBH,XM) values ('" + str1
                  + "','" + str2 + "')";
           PreparedStatement pstmt = dbConn.prepareStatement(sql);
           pstmt.addBatch();
           pstmt.executeBatch();
      a = "2";
       } catch (Exception e) {
           e.printStackTrace();
      a = "error";
          
  &n


Ïà¹ØÎĵµ£º

ORACLE sqlÓï¾ä±Ê¼Ç

windowsÉÏ´æÔÚ32bitµÄÏÞÖÆ£¬ÈçAIX¡¢HP UNIX µÈÓÐÃ÷È·µÄ64BIT OS and ORACLEµÄ°æ±¾£¬32bit oracle¿ÉÒÔ×°ÔÚ64bit os ÉÏ£¬64 bit oracle²»ÄÜ×°ÔÚ32 bit OSÉÏ
oracleÊÇ64bit or 32 bit,32bit ͨ³£ SGAÓÐ 1.7G µÄÏÞÖÆ(ijЩOSµÄ´¦Àí»òÕßWINDOWSÉÏÓÐÌØ¶¨É趨¿ÉÒÔÖ§³Öµ½2GÒÔÉÏÉõÖÁ´ïµ½3.7G
ÈçºÎ²é³öǰ̨ÕýÔÚ·¢³öµÄsqlÓï¾ä:
sele ......

jsp Á´½ÓOracleµÄÁ¬½Ó³ØºÍ²éÑ¯Ìø×ª´úÂ루´øµÇ¼£©

'-------------------------------------------------------------------ÒÔÏÂÊǵǼ´úÂë
<%@ page contentType="text/html; charset=gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3 ......

[×ªÔØ]javaÖеÄ×¢Ê͹淶

 JAVA×¢ÊÍ·½·¨¼°¸ñʽ
1¡¢µ¥ÐÐ(single-line)--¶Ì×¢ÊÍ£º//……   
µ¥¶ÀÐÐ×¢ÊÍ£ºÔÚ´úÂëÖе¥ÆðÒ»ÐÐ×¢ÊÍ£¬ ×¢ÊÍǰ×îºÃÓÐÒ»ÐпÕÐУ¬²¢ÓëÆäºóµÄ´úÂë¾ßÓÐÒ»ÑùµÄËõ½ø²ã¼¶¡£Èç¹ûµ¥ÐÐÎÞ·¨Íê³É£¬ÔòÓ¦²ÉÓÿé×¢ÊÍ¡£
×¢Ê͸ñʽ£º/* ×¢ÊÍÄÚÈÝ */
ÐÐÍ·×¢ÊÍ£ºÔÚ´úÂëÐеĿªÍ·½øÐÐ×¢ÊÍ¡£Ö÷ҪΪÁËʹ¸ÃÐд ......

Java¶àÏ̱߳à³Ì×ܽá

ת×Ô:http://lavasoft.blog.51cto.com/62575/27069
Java¶àÏ̱߳à³Ì×ܽá
 
Ò»¡¢ÈÏʶ¶àÈÎÎñ¡¢¶à½ø³Ì¡¢µ¥Ï̡߳¢¶àÏß³Ì
ÒªÈÏʶ¶àÏ߳̾ÍÒª´Ó²Ù×÷ϵͳµÄÔ­Àí˵Æð¡£
 
ÒÔǰ¹ÅÀϵÄDOS²Ù×÷ϵͳ£¨V 6.22£©Êǵ¥ÈÎÎñµÄ£¬»¹Ã»ÓÐÏ̵߳ĸÅÄϵͳÔÚÿ´ÎÖ»ÄÜ×öÒ»¼þÊÂÇé¡£±ÈÈçÄãÔÚcopy¶«Î÷µÄʱºò²»ÄÜrenameÎļþÃû¡£ÎªÁËÌá¸ß ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ