锘??xml version="1.0" encoding="utf-8" standalone="yes"?>
$cd /usr;mkdir java;cd java;
$cp /soft/jdk-6u37-linux-i586.bin jdk-6u37-linux-i586.bin
$chmod +x jdk-6u37-linux-i586.bin
$./jdk-6u37-linux-i586.bin
$vi /etc/profile
灝嗕笅闈㈢殑鍐呭娣誨姞鍒版渶鍚庡茍淇濆瓨
#set java environment
JAVA_HOME=/usr/java/jdk1.6.0_37
CLASSPATH=.:$JAVA_HOME/lib.tools.jar
PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME CLASSPATH PATH
####$$$$$$$$鎵ц涓嬮潰鐨勫懡浠や嬌涔嬬敓鏁?娉ㄦ剰鑻辨枃絎﹀彿“.”,絀烘牸鍚庡啀鍔犱笂鏂囦歡鍚?$$$$$$$$$
[root@localhost mqsoft]#. /etc/profile
##鏌ョ湅jdk鏄惁瀹夎鎴愬姛
[root@localhost mqsoft]#java -version
2.榪涘叆鍒癕Q杞歡鍖呮墍鍦ㄧ殑鐩綍
[root@localhost mqsoft]#cd /soft
3.
[root@localhost mqsoft]#mkdir mqsoft
4.
[root@localhost mqsoft]#cd mqsoft
5.
[root@localhost mqsoft]#tar -zxvf ../MQ_7.5_TRIAL_FOR_LNX_ON_X86_32_ML.tar.gz
6.
[root@localhost mqsoft]#./mqlicense.sh -accept
7.
[root@localhost mqsoft]# rpm -ivh MQSeriesRuntime-7.5.0-0.i386.rpm
Creating group mqm
Creating user mqm
[root@localhost mqsoft]# rpm -ivh MQSeriesSDK-7.5.0-0.i386.rpm
[root@localhost mqsoft]# rpm -ivh MQSeriesServer-7.5.0-0.i386.rpm
[root@localhost mqsoft]# rpm -ivh MQSeriesClient-7.5.0-0.i386.rpm
[root@localhost mqsoft]# rpm -ivh MQSeriesSamples-7.5.0-0.i386.rpm
[root@localhost mqsoft]# rpm -ivh MQSeriesJava-7.5.0-0.i386.rpm
Preparing... ########################################### [100%]
1:MQSeriesJava ########################################### [100%]
[root@localhost mqsoft]# rpm -ivh MQSeriesMsg_Zh_CN-7.5.0-0.i386.rpm
Preparing... ########################################### [100%]
1:MQSeriesMsg_Zh_CN ########################################### [100%]
[root@localhost mqsoft]# rpm -ivh MQSeriesMan-7.5.0-0.i386.rpm
Preparing... ########################################### [100%]
1:MQSeriesMan ########################################### [100%]
8. 瀹夎榪囩▼鍒涘緩浜?jiǎn)涓涓悕涓?mqm 鐨勭敤鎴峰拰涓涓悓鏍峰悕涓?mqm 鐨勭粍銆傛鏃訛紝鏂扮敤鎴鋒槸琚攣瀹氱殑錛屾?zhèn)ㄥ繀椤昏畡〗竴涓瘑鐮佹潵瑙i攣錛岃繖鏍鋒墠鑳界戶(hù)緇湰鏂囩殑絎簩閮ㄥ垎銆傚彲鐢?passwd 鍛戒護(hù)鍋氬埌榪欎竴鐐癸細(xì)
[root@localhost mqsoft]# passwd mqm
9.鍒囨崲鍒癿qm鐢ㄦ埛涓嬫墽琛宑rtmqm鍒涘緩涓涓槦鍒楃鐞嗗櫒
-bash-3.2$ crtmqm -q QM1
姝?WebSphere MQ 鍓湰鐨勮瘯鐢ㄦ湡榪樺墿 90 澶┿?br />WebSphere MQ 闃熷垪綆$悊鍣ㄥ凡鍒涘緩銆?br />宸插垱寤虹洰褰?#8220;/var/mqm/qmgrs/QM1”銆?br />闃熷垪綆$悊鍣ㄤ笌瀹夎“Installation1”鍏寵仈銆?br />姝e湪鍒涘緩鎴栨浛鎹㈤槦鍒楃鐞嗗櫒“QM1”鐨勭己鐪佸璞°?br />緙虹渷瀵硅薄緇熻錛?4 涓凡鍒涘緩銆? 涓凡鏇挎崲銆? 涓凡澶辮觸銆?br />姝e湪瀹屾垚璁劇疆銆?br />璁劇疆瀹屾垚銆?br />10.濡傛灉鎵цcrtmqm鍛戒護(hù)鏃舵彁紺?br />-bash-3.2$ crtmqm
-bash: crtmqm: command not found
鍒欓渶瑕侀厤緗甿qm鐢ㄦ埛鐨勭幆澧冨彉閲忥紝緙栬緫濡備笅鏂囦歡錛屽茍娣誨姞涓嬮潰鐨勫唴瀹癸紝濡備笅錛?br />1錛?bash-3.2$ vi /var/mqm/.bash_profile
PATH=$PATH:/opt/mqm/samp/bin:/opt/mqm/bin:bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
2錛夋墽琛?#8220;.”鍛戒護(hù)錛屼嬌榪欎釜鏂囦歡鐢熸晥
-bash-3.2$ . .bash_profile
3錛夊啀嬈″皾璇曞疄琛宑rtmqm鎴栨槸dspmqm鍛戒護(hù)錛屽嵆鍙彂鐜板凡緇忕敓鏁堛?/p>
select 'select * from '||tname||';' from tab where lower(tname) like 'tb_evt_ydq_%'
<a4j:outputPanel id="accountHTable">
<h:dataTable headerClass="title2" >
</h:dataTable>
</a4j:outputPanel>
import com.ice.jni.registry.RegStringValue;
import com.ice.jni.registry.Registry;
import com.ice.jni.registry.RegistryKey;
public class TestC {
public static void main(String[] str) {
try {
RegistryKey child = Registry.HKEY_CURRENT_USER
.openSubKey("Software").openSubKey("ODBC").openSubKey("ODBC.INI").openSubKey("data_0930",RegistryKey.ACCESS_ALL);//鎿嶄綔鏉冮檺鏄氳繃RegistryKey鏉ヨ幏鍙栫殑銆?br />
String de = "F:\\commony\\test\\data\\070901"; //鎴戠殑DBF鏁版嵁鐨勭洰褰?br />
//鍏朵腑錛宒ata_0930鏄垜絎竴嬈¤緗殑鏁版嵁婧愮殑涓涓敞鍐岃〃鐨勫悕縐?br />
System.out.println(child.getStringValue("SourceDB"));
child.setValue(new RegStringValue(child,"SourceDB",de));
System.out.println(child.getFullName());
} catch (Exception e) {
e.printStackTrace();
}
}
}
鐒跺悗灝辨槸閫氳繃錛宻un.jdbc.odbc.JdbcOdbcDriver鏉ヨ幏鍙栨暟鎹紝
import java.sql.DriverManager;
import java.sql.*;
public class TestOdbc {
public TestOdbc() {
}
public static void main(String[] args) {
java.sql.Connection conn = null;
java.sql.PreparedStatement pt = null;
java.sql.ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex1) {
}
try {
conn = DriverManager.getConnection("jdbc:odbc:data_0930", "", "");
pt = conn.prepareStatement(" select * from test_table");
rs = pt.executeQuery();
while(rs.next()){
System.out.println("==="+rs.getString(1));
System.out.println("==="+rs.getString(2));
System.out.println("==="+rs.getString(3));
System.out.println("==="+rs.getString(4));
System.out.println("==="+rs.getString(5));
}
}
catch (SQLException ex) {
}
}
}
鍏跺疄鐪熺殑寰堢畝鍗曘?br /> 鍏跺疄錛屾枃浠跺悕錛屾槸鍙互鍔ㄦ佽幏鍙栫殑錛屼竴鑸彲浠ラ氳繃java涓殑File綾繪潵鑾峰彇錛?br />
import java.io.File;
public class TestD {
public static void main(String[] args){
File file = new File("F:\\commony\\test\\data");
File[] df = file.listFiles();
for(int k =0;k<df.length;k++){
if(df[k].isDirectory()){ //鍥犱負(fù)鏂囦歡澶逛腑鍖呭惈DBF鏂囦歡錛屾墍浠ュ垽鏂槸鏂囦歡澶癸紝鑰屼笉鏄枃浠?br />
System.out.println("===kkkk=="+k+"====="+df[k].getName());
}
}
}
}
絎竴縐嶅氨鏄繖鏍鳳紝闇瑕佹敞鎰忕殑鏄痳egistry鐨勪嬌鐢紝鍏跺疄寰堢畝鍗曠殑錛屽彧瑕佹妸DLL鏂囦歡鏀懼埌classpath涓嬪氨鍙互浜?jiǎn)銆?br /> 絎簩縐嶅叾瀹炴洿綆鍗曪紝灝辨槸閫氳繃鍙︿竴涓紑鍏冪殑綾誨寘jdbf.jar錛屼嬌鐢ㄦ柟娉曚篃寰堢畝鍗曪紝緗戜笂鏈夊緢澶氳祫鏂欙紝鍙互鏌ヨ銆備篃灝變笉澶氳浜?jiǎn)銆?br />