SQL SERVERµ¼ÈëBAKÎļþ
ϵͳ»·¾³£ºwindows xp pro
Êý¾Ý¿â£ºMS Sql 2000
IIS: 5.1 ASP.NET2.0
ÒòΪ´úÂëÊÇ2.0.netµÄ,ûÓа취ֻºÃ°²×°ÁË.netÏÂÔØÄã¿ÉÒÔȥ΢ÈíµÄÍøÕ¾ÉÏÈ¥ÏÂÔØ.Õâ¸öÊÇÃâ·ÑµÄÈí¼þ£¬ÎÒÖªµÀµÄÊÇÃâ·ÑµÄ¡£
Êý¾Ý¿â×öÁËѹËõºó׺ÊÇbakµÄ£¬ËùÒÔÊý¾Ý¿â²»ÄÜÖ±½ÓʹÓã¬ÐèÒªµ¼ÈëÔÚÍøÉϲéÁ˺ܶàµÄ×ÊÁϵ«ÊDz»¶à£¬µ«×Ô¼º³É¹¦µ¼ÈëÁË£¬Ð´ÏÂÀ´×öÒ»¸ö±¸ÍüÒÔÃâÒÔºóÓÖÍü¼ÇÁË¡£
Ê×ÏÈ´ò¿ªSQLµÄÆóÒµ¹ÜÀí¹¤¾ß£¬´ò¿ªÊý¾Ý¿âÏî¿ÉÒÔ¿´µ½×ó²àÓкܶàµÄÊý¾Ý¿â£¬ÄǸöϵͳ×Ô´øµÄ²»Òª¶¯£¬ÔÚÓÒ²à¿Õ°×´¦µãÓÒ¼üÑ¡“ËùÓÐÈÎÎñ”“»¹ÔÊý¾Ý¿â”ÔÚ“»¹Ô”ºóÓÐÈý¸öÑ¡ÏîÒÀ´ÎÊÇ“Êý¾Ý¿â”“Îļþ×é»òÎļþ”“´ÓÉ豸”Ñ¡Ôñ“´ÓÉ豸”ÔÚ“²ÎÊý”Ñ¡ÔñÒ»¸öÉ豸£¬Õâ¸öÆäʵ¾ÍÊÇÄã´æ·ÅBAKÎļþµÄ´ÅÅÌ£»ÁíÒ»¸öÎÊÌâ¾ÍÊÇÑ¡Ôñ“Ñ¡Ïî”Ñ¡Ôñ“ÔÚÏÖÓÐÊý¾Ý¿âÉÏÇ¿ÖÆ»¹Ô”È»ºó´òµ½ÄãÒª»¹ÔµÄBAKÊý¾Ý¿âÑ¡»¹Ô¾Í¿ÉÒÔÁË¡£
ÔÚ»¹ÔµÄ¹ý³ÌÖÐÓöµ½Ò»¸ö´íÎóµÄÌáʾ´óÌåÒâ˼ÊÇ˵É豸´íÎó»òËð»µÎÞ·¨»¹ÔÖ¸¶¨µÄÊý¾Ý¿â£¬¿ªÊ¼µÄʱºò×Ô¼ºÒÔΪÊÇSQLÓÐÎÊÌâµÄ£¬ºóÀ´×Ðϸ¿´ÁËһϷ¾¶£¬ÔÀ´ÊÇĬÈϵÄ·¾¶²»´æÔÚÔì³É´íÎóµÄÌáʾ£¬ÒòΪ×Ô¼ºÔÚ°²×°SQLµÄʱºò°ÑĬÈÏ´æ·ÅÊý¾Ý¿âµÄ·¾¶ÐÞ¸ÄÁË£¬ËùÒÔÔì³ÉÁË´íÎó£¬Õâ¸öÎÊÌâ±È½ÏºÃ½â¾ö£¬¾ÍÊÇ°ÑÒª»¹ÔµÄÊý¾Ý¿âÖØÐÂÖ¸¶¨Ò»Ï·¾¶ÎÊÌâ¾Í¿ÉÒÔ½â¾öÁË£¡
Ïà¹ØÎĵµ£º
1.½¨±íÓï¾ä£ºcreate table
Ó÷¨: create table ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£)
¾ÙÀý£ºÀýÈç´´½¨Ò»¸öѧÉú³É¼¨±í£¬°üº¬µÄ×Ö¶ÎÓУ¬Ñ§Éúid£¬ÐÕÃû£¬ÐԱ𣬰༶£¬³É¼¨create table score(
create table score(
sid nvarchar(10) primary key,
sname nvarchar(10) not null,
sex nvarchar(2),
sc ......
mysqlµ¼ÈësqlÎļþ:Mysqlµ¼Èëµ¼³ö.sqlÎļþ
²½ÖèÈçÏ£º
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER ......
ºÍjava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinalÕ½¶·ÁË°ëÌ죬º¹°¡£¡
ʹÓÃjpa + strut+ hibernate ¾Í±¨org.hibernate.QueryException: JPA-style positional param was not an integral ordinal
Ò»°ã°ÑhqlÓï¾äдÔÚÒ»ÐУ¬»áºÜ³¤£¬ÔÚideÖÐÐèÒ ......
DECLARE
TYPE list IS TABLE OF t_stu.project%TYPE INDEX BY BINARY_INTEGER;
project_list list;
v_pro_num NUMBER;
sql_str VARCHAR(255);
t_stu
SID SUBJECT SCORE
1 Êýѧ &n ......
1.µ½http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.htmlÏÂÔØ
11.1.0.7.0 °æµÄ¼´Ê±¿Í»§¶Ë³ÌÐò°ü — Basic£¨²»ÊÇBasic Lite£©
2.½«ÏÂÔص½µÄÎļþ½âѹ£¬½âѹºóÎÒ½«Ä¿Â¼instantclient_11_1ÀïµÄÈ«²¿Îļþ¿½±´µ½ÁËÒ»¸öеÄĿ¼£ºE:\programs\OracleClient¡£ÄãÒ²¿ÉÒÔ²»¿½±´£¬Ö ......