2008-08-29 22:59
|
鐢╬owerdesigner鍒涘緩access鏁版嵁搴? 1銆佸厛鐢╬owerdesigner璁捐濂借〃錛岀敓鎴恠ql璇彞銆?br /> 2銆佸垱寤轟竴涓猘ccess絀虹殑鏁版嵁搴撱?br /> 3銆佹墦寮powerdesigner鎵鍦ㄧ洰褰曪紝涓嬭竟鏈変竴涓猅ools鐩綍錛屾墦寮鐩綍涓嬬殑Access.mdb 4銆佸弻鍑誨嚭鐜頒竴涓璇濇錛岄夋嫨濂芥暟鎹簱鏂囦歡(.mdb),閫夋嫨濂藉垰鎵嶇敓鎴愮殑sql鏂囦歡錛岀偣鍑籧reat銆?br /> 5銆丱K銆?/div> |
powerdesigner 鍑犱釜鍩烘湰闂
紿佺劧瑕佺敤powerdesigner鍋氭暟鎹簱琛ㄨ璁★紝 鏈鍚庡彂鐜板鍑簊ql鑴氭湰灝卞嚭鐜頒簡闂錛?棣栧厛鏄瓧孌甸兘甯︿笂浜嗗弻寮曞彿錛?鑰屼笖榪樻繪槸鎶ラ敊瀛楁鍚嶈繃闀褲?
鍙﹀榪樺彂鐜癱olumn灞炴э紝Code鎵嶆槸鏈緇堜駭鐢熺殑Table Name 錛岃孨ame灝辨湁鐐瑰儚鏄弿榪頒簡銆?
瀵逛簬涓婇潰闂鎵句簡鎵撅紝榪樻槸鍦ㄥ潧瀛愰噷闈㈠彂鐜版湁涓摜浠創鍑轟簡瑙ｇ瓟鏂規硶錛?
http://www.javaeye.com/topic/120979
鎰熻阿涓涓嬶紝鍏蜂綋鍐呭濡備笅錛?
鍦?Database閲岄夋嫨浣犵殑鏁版嵁搴撶劧鍚庡湪 DBMS閲岄潰閫夋嫨(娉ㄦ剰鐪嬫竻妤歅DM鐨勫紩鐢ㄦā寮忔槸鍝釜鏁版嵁搴?
Script->Sql->Format->EnableOwnerPrefix value=Yes;
Script->Sql->Format->CaseSensitivityUsingQuote=No;
榪欐椂鍐嶅鍑?琛ㄧ殑鍚嶇О灝辨甯鎬簡
PowerDesigner9 縐繪鍒?PowerDesigner12 鐨勯棶棰橈細
榛樿闀垮害鐨勯棶棰橈紝鎴戝湪PowerDesigner9瀵煎嚭娌￠棶棰樼殑鏁版嵁搴撹剼鏈嬁鍒癙owerDesigner12瀵煎嚭鍑虹幇濡備笅闂錛?
Column constraint name maximum length is limited to 15 characters
鍦ㄤ嬌鐢≒D12鏃跺嚭鐜拌濡備互涓嬮敊璇細
Reference constraint name maximum length is limited to 7 characters
Key constraint name maximum length is limited to 7 characters
Table code maximum length
Column code maximum length
……
瀵艱嚧鐢熸垚寤鴻〃SQL鏃墮氫笉榪囷紝緇嗙┒鍘熷洜鍘熸潵鏄粯璁よ緗殑闂錛屾敼涓嬪氨鍙互浜嗭細錛?
璋冩暣浠ヤ笅鍙傛暟錛?
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\MaxConstLen value=>255
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\Table\Maxlen value=>255
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\Column\Maxlen value=>255
鍐嶈璇村浣曞湪 PowerDesigner12閲屽垱寤哄甫瀵煎嚭鍒嗗尯鐨勮剼鏈?
榛樿鎯呭喌涓嬪垎鍖鴻緗槸闅愯棌鐨?鎵浠ヨ閫夌璇ヨ〃 鐒跺悗鍐嶇偣宸︿笅鑴氱殑More>>
閫夋嫨Physical Options 榪欎釜閫夐」 榪欓噷鍙互娣誨姞琛ㄧ┖闂村拰绱㈠紩絀洪棿 鎴戜範鎯洿鎺ヨ緗垎鍖篠QL璇彞 榪欐牱閬垮厤浜嗗緢澶氬瀮鍦捐鍙ョ敓鎴?
閫夋嫨 SQL 鐒跺悗鍒涘緩鍒嗗尯
partition by list
( data_part )
( partition Pd00
values ( '0' ) )
灝監K浜?鍘籔artitions閫夐」閲屽彲浠ョ湅鍒拌繖涓鍒楀垎鍖烘晥鏋?
璁劇疆绱㈠紩榛樿絀洪棿錛?
閫夋嫨KEY閫夐」鎴栬匢ndex閫夐」 鐩存帴鍙屽嚮璇ョ儲寮?鐒跺悗璁劇疆Physical Options
鐩存帴杈撳叆SQL鍒涘緩榛樿绱㈠紩鎸囧悜琛ㄧ┖闂?nbsp; using index tablespace index_emcspace
PowerDesigner鍔熻兘寮哄ぇ 瀹屽叏鍙互緇存姢澶ч儴鍒嗙殑鏁版嵁搴撳緩妯?
鐜板湪鍦∣racle鏁版嵁搴撶淮鎶ゆ湁浜涢棶棰?鍒涘緩鏁版嵁搴撶殑Package 鎴栬?Types 銆丏irectories銆丣obs絳?娌″姙娉曠淮鎶よ繘鍘匯?
------------------------------------------------------------------------------------------------------
鍥犱負鎴戜笅杞界殑pd11鏄瘯鐢ㄧ増錛屽姛鑳藉彈闄愶紝 index瀵煎嚭鎬繪槸鎶ラ敊錛?鎹㈢敤浜唒d12鐨勭牬瑙ｇ増錛?娌℃湁闂浜嗐?
鑰屼笖鏀筼bject鏈澶ч暱搴﹁緗紝鍙璁懼畾涓涓叏灞鐨勶紝鏂逛究涓浜涳細
PGSQL73::Script\Objects\MaxConstLen
value=>255
PGSQL73::Script\Objects\Table\Maxlen
value=>255
鍙﹀鍙戠幇pd12涔熸病鏈夎〃闀垮害闀夸竴鐐瑰氨鎶ラ敊鐨勯棶棰橈紝 涓嶇敤鍍忓墠闈㈤偅鏍鋒敼闀垮害浜嗐?
鍙﹀榪樺彂鐜癱olumn灞炴э紝Code鎵嶆槸鏈緇堜駭鐢熺殑Table Name 錛岃孨ame灝辨湁鐐瑰儚鏄弿榪頒簡銆?
瀵逛簬涓婇潰闂鎵句簡鎵撅紝榪樻槸鍦ㄥ潧瀛愰噷闈㈠彂鐜版湁涓摜浠創鍑轟簡瑙ｇ瓟鏂規硶錛?
http://www.javaeye.com/topic/120979
鎰熻阿涓涓嬶紝鍏蜂綋鍐呭濡備笅錛?
鍦?Database閲岄夋嫨浣犵殑鏁版嵁搴撶劧鍚庡湪 DBMS閲岄潰閫夋嫨(娉ㄦ剰鐪嬫竻妤歅DM鐨勫紩鐢ㄦā寮忔槸鍝釜鏁版嵁搴?
Script->Sql->Format->EnableOwnerPrefix value=Yes;
Script->Sql->Format->CaseSensitivityUsingQuote=No;
榪欐椂鍐嶅鍑?琛ㄧ殑鍚嶇О灝辨甯鎬簡
PowerDesigner9 縐繪鍒?PowerDesigner12 鐨勯棶棰橈細
榛樿闀垮害鐨勯棶棰橈紝鎴戝湪PowerDesigner9瀵煎嚭娌￠棶棰樼殑鏁版嵁搴撹剼鏈嬁鍒癙owerDesigner12瀵煎嚭鍑虹幇濡備笅闂錛?
Column constraint name maximum length is limited to 15 characters
鍦ㄤ嬌鐢≒D12鏃跺嚭鐜拌濡備互涓嬮敊璇細
Reference constraint name maximum length is limited to 7 characters
Key constraint name maximum length is limited to 7 characters
Table code maximum length
Column code maximum length
……
瀵艱嚧鐢熸垚寤鴻〃SQL鏃墮氫笉榪囷紝緇嗙┒鍘熷洜鍘熸潵鏄粯璁よ緗殑闂錛屾敼涓嬪氨鍙互浜嗭細錛?
璋冩暣浠ヤ笅鍙傛暟錛?
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\MaxConstLen value=>255
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\Table\Maxlen value=>255
Database=>Edit current DBMS 鏁版嵁搴撶被鍨?:Script\Objects\Column\Maxlen value=>255
鍐嶈璇村浣曞湪 PowerDesigner12閲屽垱寤哄甫瀵煎嚭鍒嗗尯鐨勮剼鏈?
榛樿鎯呭喌涓嬪垎鍖鴻緗槸闅愯棌鐨?鎵浠ヨ閫夌璇ヨ〃 鐒跺悗鍐嶇偣宸︿笅鑴氱殑More>>
閫夋嫨Physical Options 榪欎釜閫夐」 榪欓噷鍙互娣誨姞琛ㄧ┖闂村拰绱㈠紩絀洪棿 鎴戜範鎯洿鎺ヨ緗垎鍖篠QL璇彞 榪欐牱閬垮厤浜嗗緢澶氬瀮鍦捐鍙ョ敓鎴?
閫夋嫨 SQL 鐒跺悗鍒涘緩鍒嗗尯
partition by list
( data_part )
( partition Pd00
values ( '0' ) )
灝監K浜?鍘籔artitions閫夐」閲屽彲浠ョ湅鍒拌繖涓鍒楀垎鍖烘晥鏋?
璁劇疆绱㈠紩榛樿絀洪棿錛?
閫夋嫨KEY閫夐」鎴栬匢ndex閫夐」 鐩存帴鍙屽嚮璇ョ儲寮?鐒跺悗璁劇疆Physical Options
鐩存帴杈撳叆SQL鍒涘緩榛樿绱㈠紩鎸囧悜琛ㄧ┖闂?nbsp; using index tablespace index_emcspace
PowerDesigner鍔熻兘寮哄ぇ 瀹屽叏鍙互緇存姢澶ч儴鍒嗙殑鏁版嵁搴撳緩妯?
鐜板湪鍦∣racle鏁版嵁搴撶淮鎶ゆ湁浜涢棶棰?鍒涘緩鏁版嵁搴撶殑Package 鎴栬?Types 銆丏irectories銆丣obs絳?娌″姙娉曠淮鎶よ繘鍘匯?
------------------------------------------------------------------------------------------------------
鍥犱負鎴戜笅杞界殑pd11鏄瘯鐢ㄧ増錛屽姛鑳藉彈闄愶紝 index瀵煎嚭鎬繪槸鎶ラ敊錛?鎹㈢敤浜唒d12鐨勭牬瑙ｇ増錛?娌℃湁闂浜嗐?
鑰屼笖鏀筼bject鏈澶ч暱搴﹁緗紝鍙璁懼畾涓涓叏灞鐨勶紝鏂逛究涓浜涳細
PGSQL73::Script\Objects\MaxConstLen
value=>255
PGSQL73::Script\Objects\Table\Maxlen
value=>255
鍙﹀鍙戠幇pd12涔熸病鏈夎〃闀垮害闀夸竴鐐瑰氨鎶ラ敊鐨勯棶棰橈紝 涓嶇敤鍍忓墠闈㈤偅鏍鋒敼闀垮害浜嗐?
]]>
http://www.okajax.com/a/200807/0HW9502008.html
涓婚〉 > Ajax鎶鏈?/a> > Ajax妗嗘灦瀛︿範 > extjs > EXt2.0 + jsp 鍒嗛〉
]]>
鎴戠殑瀹為獙錛?br /> 1.鍦≒DM閲屼笉瀛樺湪CDM閲岀殑闂錛屼笉浠呬笉鍚岃〃閲岀殑鍚屽悕瀛楁娌℃湁榪炲姩鍏崇郴錛岃屼笖榪樺彲浠ョ敤鍚屽悕瀛楁鍋氫富閿傜埥錛?br /> 2.鍋氫竴涓湁閲嶅瀛楁鍜岄噸澶嶄富閿瓧孌電殑PDM錛屽弽瀵兼垚CDM錛岀粨鏋滃彂鐜板湪璇DM閲屽眳鐒跺彲浠ュ厑璁擱噸鍚嶅瓧孌靛拰瀛楁涓婚敭浜嗭紝鍚孭DM閲岀殑鎯呭喌涓鏍鳳紝涔熺埥錛佺敱姝ゆ垜瑙夊緱涓瀹氬彲浠ラ氳繃鏌愪簺璁劇疆鍘繪帀鍒濆鍦–DM寤烘ā鍨嬬殑鏃跺欑殑閲嶅悕綰︽潫銆?br />
鎴戠殑瑙ｅ喅鍔炴硶錛?br /> 緇忚繃鑹拌嫤鍗撶粷寰楀姫鍔涳紝緇堜簬鎵懼埌浜嗚緗繖涓噸鍚嶇害鏉熷緱鍦版柟錛佹壘浜嗗ソ鍑犲勾浜嗭紒
浠ュ墠涓鐩翠互涓鴻繖鏄疨D鐨勬紡媧炲憿錛岄棶榪囧ソ鍑犱釜PD鑰佺墰閮芥病瑙ｅ喅錛岀幇鍦ㄦ兂鎯崇畝鐩存儹鎰ф浜嗭紒[濡傛灉鐪嬭創鐨勫悓蹇楁棭灝辯煡閬撹繖涓簡錛岃絎?img height="20" alt="" src="http://www.cnblogs.com/Emoticons/QQ/11.gif" width="20" border="0" />]鍏蜂綋鏂規硶錛?br /> 閫夋嫨"Tools -> Model Options"鍚庯紝寮瑰嚭濡備笅鍥炬墍紺虹獥浣擄細
灝嗙孩妗嗛噷鐨?Unique code"澶嶉夋鐨勯挬鍘繪帀灝監K鍟︼紒鍝堝搱鍝?br />
鍏跺畠闂錛?br /> 澶у娉ㄦ剰涓婂浘綰㈡閲岃繕鏈変竴涓?Allow reuse"澶嶉夋錛屽緩璁妸榪欎釜閽╀篃鍘繪帀錛岄偅涔堜互鍚庡氨涓嶈鎷呭績鍦ㄦā鍨嬮噷鍙戠敓瀛楁榪炲姩淇敼鐨勯棶棰樹簡錛屾垜鍒氬疄楠屼簡涓涓嬶紝鍗充嬌浠庝竴涓〃綺樿創澶嶅埗涓涓瓧孌靛埌鍙︿竴涓〃閲岋紝榪欎袱涓瓧孌典篃涓嶄細榪炲姩淇敼錛佸搱鍝堝搱錛岀埥錛?br />
鏈鍚庡緩璁妸涓や釜閽╅兘鍘繪帀鍚庯紝鐐瑰嚮"Set As Default"鎸夐挳錛屾妸榪欒緗垚榛樿璁劇疆錛屼互鍚庡氨涓囦簨澶у悏浜嗭紒澶埥浜嗭紒
]]>
鎰熻阿
棣栧厛鎰熻阿http://blog.csdn.net/caterpillar_here/archive/2006/09/06/1186566.aspx錛屼粠榪欓噷瀛︾殑絎竴涓猟wr騫惰皟璇曟垚鍔熶簡錛屽拰緗戝弸浠叡鍚屽垎浜?br />欏圭洰綆浠嬪拰鍑嗗
鎴戝仛鐨勮繖涓猟wr鐨勯」鐩洰褰曠洰褰曞涓嬶細
1錛?nbsp; http://getahead.ltd.uk/dwr/涓婁笅杞絛wr.jar錛岀劧鍚庢斁鍒癢EB-INF/lib涓?br />
2錛?nbsp; 緙栧啓web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name>ajaxDWR</display-name>
<servlet>
<servlet-name>dwr-invoker</servlet-name>
<servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
<init-param>
<description></description>
<param-name>debug</param-name>
<param-value>true</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dwr-invoker</servlet-name>
<url-pattern>/dwr/*</url-pattern>
</servlet-mapping>
</web-app>
3錛?nbsp; 緙栧啓Hello.java
package onlyfun.caterpillar;
public class Hello {
public String hello(String name) {
return "Hello!" + name + "!鎮ㄧ殑絎竴涓狣WR錛?;
}
}
4) 緙栧啓dwr.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 1.0//EN"
"http://www.getahead.ltd.uk/dwr/dwr10.dtd">
<dwr>
<allow>
<create creator="new" javascript="Hello">
<param name="class" value="onlyfun.caterpillar.Hello"></param>
</create>
</allow>
</dwr>
5錛?nbsp; 緙栧啓index.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>絎竴涓狣WR</title>
<script type='text/javascript' src='dwr/interface/Hello.js'></script>
<script type='text/javascript' src='dwr/engine.js'></script>
<script type='text/javascript' src='dwr/util.js'></script>
<script type='text/javascript' src='hello.js'></script>
</head>
<body>
<input id="user" type="text" />
<input type='button' value='hello' onclick='hello();' />
<div id="result"></div>
</body>
</html>
瑙ｉ噴錛歞wr/interface/Hello.js鏄敱DWRServlet鏍規嵁dwr.xml涓殑璁懼畾鐢熸垚鐨勶紝engine.js璐熻矗瀹㈡埛绔己鏈嶇娌熼氾紝util.js鏄竴浜涘ソ鐢ㄧ殑JavaScript紼嬪簭錛屽彲浠ヨ浣犲皯鍐欏緢澶欽avaScript銆?br />
6錛?nbsp; 緙栧啓hello.js
function hello() {
var user = $('user').value;
Hello.hello(user, callback);
}
function callback(msg) {
DWRUtil.setValue('result', msg);
}
瑙ｉ噴錛?{'user'}鍙栧緱杈撳叆鏍忎綅鐨凞OM鐗╀歡錛寁alue鍙栧緱褰撲腑鐨勬爮浣嶅鹼紝鑰屽悗鍛煎彨Hello.hello()錛屽茍灝唙alue褰撲綔鍙傛暟浼犻侊紝緇撴灉鏄懠鍙玈erver绔殑Hello Java鐗╀歡錛屽綋緇撴灉浼犲洖鍚庯紝浼氬懠鍙獼avaScript鐨刢allback鍑芥暟錛孌WRUtil鐨剆etValue()鏂規硶浼氬皢浼犲洖鐨刴sg璁懼畾緇欐寚瀹歩d鐨凞OM銆?br />
ok錛屽埌姝ょ粨鏉熴?br /> http://www.aygfsteel.com/Files/kingaragorn/demo.rar
]]>