javaʹÓÃjdbcÁ¬½Ó¸÷ÖÖÊý¾Ý¿â
1¡¢Oracle8/8i/9iÊý¾Ý¿â£¨thinģʽ£©
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orclΪÊý¾Ý¿âµÄSID
String user="test";
String password="test";
Connection conn= DriverManager.getConnection(url,user,password);
¡¡¡¡2¡¢DB2Êý¾Ý¿â
Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
String url="jdbc:db2://localhost:5000/sample"; //sampleΪÄãµÄÊý¾Ý¿âÃû
String user="admin";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
¡¡¡¡3¡¢Sql Server7.0/2000Êý¾Ý¿â
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydbΪÊý¾Ý¿â
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
¡¡¡¡4¡¢SybaseÊý¾Ý¿â
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url =" jdbc:sybase:Tds:localhost:5007/myDB";//myDBΪÄãµÄÊý¾Ý¿âÃû
Properties sysProps = System.getProperties();
SysProps.put("user","userid");
SysProps.put("password","user_password");
Connection conn= DriverManager.getConnection(url, SysProps);
¡¡¡¡5¡¢InformixÊý¾Ý¿â
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
String url = "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword"; //myDBΪÊý¾Ý¿âÃû
Connection conn= DriverManager.getConnection(url);
¡¡¡¡6¡¢MySQLÊý¾Ý¿â
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //»òÕßClass.forName("com.mysql.jdbc.Driver");
String&nbs
Ïà¹ØÎĵµ£º
ͨ³£µÄ¹ÛÄîÈÏΪ£¬ÊÂÎñ½öÓëÊý¾Ý¿âÏà¹Ø¡£
ÊÂÎñ±ØÐë·þ´ÓISO/IECËùÖÆ¶¨µÄACIDÔÔò¡£ACIDÊÇÔ×ÓÐÔ£¨atomicity£©¡¢Ò»ÖÂÐÔ£¨consistency£©¡¢¸ôÀëÐÔ£¨isolation£©ºÍ³Ö¾ÃÐÔ£¨durability£©µÄËõд¡£ÊÂÎñµÄÔ×ÓÐÔ±íʾÊÂÎñÖ´Ðйý³ÌÖеÄÈκÎʧ°Ü¶¼½«µ¼ÖÂÊÂÎñËù×öµÄÈκÎÐÞ¸ÄʧЧ¡£Ò»ÖÂÐÔ±íʾµ±ÊÂÎñÖ´ÐÐʧ°Üʱ£¬ËùÓб»¸ÃÊÂÎñÓ°ÏìµÄ ......
¼òµ¥Ð´ÁËÒ»¸ö£¬Ö»ÊÇÑéÖ¤Ò»ÏÂÊý¾ÝÁ÷»¥Ïà´«ËÍ£¬¾ßÌ幦ÄÜ¿ÉÒÔ×Ô¼º¼Ótest.java ¿Í»§¶Ë£º¶ÁÈ¡1.xmlÎļþ·¢Ë͸øDataServer£¨servlet£©,¶ÁÈ¡servlet·µ»ØµÄÄÚÈÝDataServer.java ·þÎñÆ÷servlet:¶ÁÈ¡test·¢Ë͵ÄxmlÄÚÈÝ£¬°ÑÄÚÈÝÔÙ·µ»Ø¸ø¿Í»§¶Ë¡£
/**
* * ¿Í»§¶Ë£¬· ......
·´±àÒëÕæµÄÈÃJAVA / .net ÖÆ×÷ÕßÌÖÑáµÄ¶«Î÷¡£Ä㻨´óÁ¿µÄ¾«Á¦×öÁËÒ»¸öºÜºÃµÄÈí¼þ£¬È´ÓÐÈ˵ÁÓã¬
µÁÓö¼ËãÁË
È˼һ¹ÓÃÀ´ÉÌÒµ...
¾ÍÏñijÎÄ˵µÄ.ÄãµÄÈí¼þÂò XXXXXXXX´óÔª.È˼ҹ«Ë¾Âò200Ôª.....
Ôõô×öµ½ÄØ£¿¾ÍÊÇͨ¹ý·´±àÒë¡£
ÎÒÃÇ¿ÉÒÔ¿´µ½
¾ÍËã±£»¤ºÜÇ¿µÄreflector4/6 ҲδÄÜÐÒÃâ
Èç¹ûÄã²»½«ÄãµÄApplication½øÐб£»¤£¬Ëü ......
½ñÌì¿Î¼ä¸úͬѧÃÇÁÄÌìµÄʱºòÁÄÆð×î½ü¼¸ÌìÉϿεÄÄÚÈÝ,ͬѧÃǶ¼¸Ð¾õÕ⼸ÌìѹÁ¦ºÜ´ó£¬ÒòΪÕ⼸ÌìÉϿν²½âµÄ¶«Î÷¶¼ÊÇһЩ»ù´¡µÄµ«ÊǷdz£ÖصãµÄ¶«Î÷£¬¸úÒÔºóµÄ¿Î³ÌµÄѧϰÁªÏµÊ®·ÖÃÜÇУ¬Õ⼸Ìì½²µÄ¶«Î÷ѧ²»ºÃµÄ»°£¬µÈµ½ºóÃæÑ§Ï°Èý´ó¿ò¼Ü»áºÜ³ÔÁ¦£¬ÓÐÒ»¸ö¸çÃÇÓÃÁËÒ»¸ö±ÈÓ÷ºÜÌùÇУ¬Ëû˵ÏÖÔÚÿÌì¶¼ÏñÊÇÔÚ´ò ......