Çë½Ì¹ØÓÚJavaÁ¬½ÓÊý¾Ý¿âµÄÎÊÌâ - Java / JavaÏà¹Ø
´ÓÍøÉϲéÕҵĻù±¾É϶¼ÊÇÁ¬½ÓJDBCµÈÎÄÕ¡£µ«²¢Ã»ÓнéÉÜÈçºÎ´Ó¶à¸ö¿âÖÐ׼ȷÕÒµ½Òª²Ù×÷µÄÊý¾Ý¿â£¬¾ßÌåÎÊÌâÊÇҪΪ³É½ÌÔº×ö¸ö²éѯϵͳ£¬½¨ÁËÒ»¸öÊý¾Ý¿âAdults£¬Í¬Ê±Sql Server2000Öл¹ÓÐÆäËû¿â£¬ÀýÈçϵͳ±¾ÉíÓÐÊý¾Ý¿âmaster£¬ÏÖÔÚÒª´ÓÊý¾Ý¿âAdultsÖеÄUserinfo±íÖÐÈ¡³öÊý¾Ý£¬³ÌÐòÓ¦¸ÃÈçºÎ±àд£¿
×öÁËÒ»¸ötest.java³ÌÐòÈçÏÂËùʾ£¬ËäÈ»Userinfo±íÖÐÓдóÁ¿Êý¾Ý£¬µ«ÊÇÈ´·µ»Ø¿ÕÖ¸ÕëÏìÓ¦¡£ºÜÆæ¹Ö
import java.sql.*;
import java.util.*;
public class Test {
public static void main(String[] args) throws SQLException{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=Adults";
String userName = "adu";
String userPwd = "adu";
Connection conn = null;
String load="select * from Userinfo";
ResultSet rs = null;
Statement stmt = null;
{
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
catch (Exception e) {
e.printStackTrace();
}
Statement stm=conn.createStatement();
rs=stmt.executeQuery("select * from Userinfo");
System.out.println("for test");
}
}
}
ÔËÐнá¹û¼°´íÎóÌáʾΪ£º
Connection Succe
Ïà¹ØÎÊ´ð£º
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
ÔõôÔÚ¿ØÖÆÌ¨ÖÐÊäÈëÀàËÆÏÂÃæµÄÐÅÏ¢£º
s1234 50
s1235 80
s1234 90
s1234 40
s1236 90
ÿµ±»Ø³µÊ± ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
²úÆ·µÄÅäÖÃÒ³Ãæ¹²ÓÃÒ»¸öÓÃJavaScriptµÄdTreeʵÏÖµÄÊ÷Ðνṹ£¬ÏÔʾµÄʱºò£¬Ê÷Ðνṹ¿¿ÔÚÒ³ÃæµÄ×î×ó±ß£¬¸úÎÒµÄÅäÖÃÒ³ÃæÖмä¸ôÁËÒ»´ó¿é£¬ÏÖÔÚÏë°ÑÊ÷ÐÎĿ¼¾ÓÖУ¬½ô¿¿ÔÚÅäÖÃÄÚÈÝÅԱߣ¬ÈçºÎ¿ØÖÆÊ÷ÐÎĿ¼µÄλÖã¬ÒÔ¼°¿É²»¿ ......