javaÁ¬½ÓÊý¾Ý¿â
1.javaÁ¬½ÓOracleÊý¾Ý¿â£º
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:È«¾ÖÊý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
2.jdbcÇŽÓodbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcÊý¾ÝÔ´";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
3.javaÁ¬½Ómysql
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/Êý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum rn from (select * from Person) a where rownum <= MaxN ......
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¡¢×ö¹ý¹¤×÷Á÷ÏîÄ¿£¨ ......
×÷ÕߣºÎ´Öª À´Ô´£ºÔ¹âÈí¼þÕ¾ ¼ÓÈëʱ¼ä£º2005-5-13¡¡Ô¹âÈí¼þÕ¾
ÔÌ⣺ ¹ØÓÚJavaÕ»Óë¶ÑµÄ˼¿¼[/B]
1. Õ»(stack)Óë¶Ñ(heap)¶¼ÊÇJava[/B]ÓÃÀ´ÔÚRamÖдæ·ÅÊý¾ÝµÄµØ·½¡£ÓëC++²»Í¬£¬Java[/B]×Ô¶¯¹ÜÀíÕ»ºÍ¶Ñ£¬³ÌÐòÔ±²»ÄÜÖ±½ÓµØÉèÖÃÕ»»ò¶Ñ¡£
¡¡¡¡2. Õ»µÄÓÅÊÆÊÇ£¬´æÈ¡ËٶȱȶÑÒª¿ì£¬½ö´ ......
ÖÚËùÖÜÖª£¬ÔÚ³ÌÐò¿ª·¢ÖУ¬ÄÑÃâ»áÓöµ½ÐèҪƥÅä¡¢²éÕÒ¡¢Ìæ»»¡¢ÅжÏ×Ö·û´®µÄÇé¿ö·¢Éú£¬¶øÕâЩÇé¿öÓÐʱÓֱȽϸ´ÔÓ£¬Èç¹ûÓô¿±àÂ뷽ʽ½â¾ö£¬ÍùÍù»áÀ˷ѳÌÐòÔ±µÄʱ¼ä¼°¾«Á¦¡£Òò´Ë£¬Ñ§Ï°¼°Ê¹ÓÃÕýÔò±í´ïʽ£¬±ã³ÉÁ˽â¾öÕâһì¶ÜµÄÖ÷ÒªÊֶΡ£
´ó ¼Ò¶¼ÖªµÀ£¬ÕýÔò±í´ïʽÊÇÒ»ÖÖ¿ÉÒÔÓÃÓÚģʽƥÅäºÍÌæ»»µÄ¹æ·¶£¬Ò»¸öÕýÔò±í´ïʽ¾ÍÊÇÓ ......