Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

javaÁ¬½ÓSqlServer2005£¨netbeans£©

»¨ÁË´ó°ëÌìµÄʱ¼äÖÕÓÚ½â¾öÁËÎÊÌ⣬ÏÂÃæ·ÖÏíÒ»ÏÂÎҵĹý³Ì£º
ÎÒµÄϵͳ°²×°µÄÊÇjdk6,netbeansºÍMycrosoft SqlServer 2005£¬javaÁ¬½ÓÊý¾Ý¿âÒ»°ãÒª·ÖÁù²¿×ß
1.×¢²áÇý¶¯
2.ÓÃÇý¶¯¹ÜÀíÀà´´½¨Á¬½Ó
3.´´½¨Óï¾ästatement·â×°sql½Å±¾Óï¾ä
4.Ö´ÐÐ
5.´¦Àí·µ»ØµÄ½á¹û
6.¹Ø±ÕÏà¹ØÁ¬½Ó
ÔÚÕâÀïÁ¬½ÓµÄÊÇSqlServer2005£¬ÊôÓÚµÚÈý·½Çý¶¯£¬Ê×ÏȵôÓÍøÉÏÏÂÔظÃÇý¶¯£¬¿ÉÒÔµ½Î¢Èí¹Ù·½ÍøÕ¾ÉÏÏÂÔØ×îа汾µÄJDBC 1.2£¬
È»ºó½«ÏÂÔصÄsqljdbc_1.2.2828.100_chs(¼´Microsoft SQL Server 2005 JDBC Driver 1.2ÖÐÎÄ°æ)½âѹËõµ½C:\Program Files\Microsoft SQL Server 2005 JDBC Driver£¬ÔÚclasspathºóÃæ¼ÓÉÏÒ»ÏîC:\Program Files\sqljdbc_1.2\chs\sqljdbc.jar
½Ó×ÅÒªÆôÓÃsqlserverµÄtcp/ipЭÒ飬·½·¨£º
¿ªÊ¼-ËùÓгÌÐò-Microsoft SQL Server 2005-ÅäÖù¤¾ß-SQL Server Configrution Manager¡£
´ò¿ªºóÕÒµ½SQL Server 2005ÍøÂçÅäÖÃÏÂÃæµÄSQLEXPRESSЭÒ飬ÔÚÓұߵĴ°¿Ú»á¿´¼ûTCP/IP£¬ÓÒ ¼ü µã»÷£¬Ñ¡ÔñÆôÓã¬ÔÙË«»÷TCP/IP£¬ÔÚЭÒéÏÂÈ«²¿ÕìÌýÑ¡ÊÇ£¬ÆôÓÃÑ¡ÊÇ¡£ÔÚpµØÖ·À¸£¬Ñ¡Ôñippall½«tcp¶Ë¿ÚÉèÖÃΪ1433£¬È·¶¨Ö®ºó£¬ÔÚ·þÎñÀォSQL Server (MSSQLSERVER)ºÍSQL Server (SQLEXPRESS)ÖØÐÂÆô¶¯Ò»Ï¡£
½Ó×ÅÒª¶Ônetbeans½øÐÐÉèÖÃ
Êý¾Ý¿â->Çý¶¯³Ìʽ£¬°´Êó±êÓÒ¼ü£¬Ñ¡Ôñ²Ëµ¥“н¨Çý¶¯³Ìʽ..."£¬´Ëʱ½«µ¯³öÒ»¸ö¶Ô»°¿ò£º“н¨JDBCÇý¶¯³Ìʽ”£¬µã»÷“Ìí¼Ó(A)...”°´Å¥£¬ÕÒµ½ÄãÄã·ÅÇý¶¯°üµÄλÖã¬ÎÒµÄÊÇ£ºC:\Program Files\sqljdbc_1.2\chs\sqljdbc.jar£¬ÔÙÔÚÃû³ÆÄÇÀïÊäÈë¸öÃû×Ö£¬ÈçÎÒµÄÊÇ£ºMicrosoftware Sql server 2005£¨1£©£¬È»ºóÈ·¶¨¡£
Çý¶¯¼ÓÈëÒÔºó£¬ÔÚ"Êý¾Ý¿â"->"Çý¶¯³Ìʽ"϶àÁËÒ»¸ö¸ÕÊäÈëµÄ"SQLServer2005"£¬Ñ¡ÖÐËü²¢°´Êó±êÓÒ¼ü£¬Ñ¡Ôñ"Á¬½ÓʹÓÃ..."£¬´Ëʱ½«µ¯³öÒ»¸ö¶Ô»°¿ò£¬ÔÚ"Êý¾Ý¿âURL(A)"´¦ÊäÈ룺"jdbc:sqlserver://localhost:1433; DatabaseName=(ÄúµÄÊý¾Ý¿âÃû)", È»ºóÔÙÊäÈëÓû§ÃûÓë¿ÚÁ²¢¹´Ñ¡ÉÏ"Ôڴ˻ỰÆÚ¼ä¼Çס¿ÚÁî"(´ËÏî·Ç±ØÑ¡)£¬×îºó°´"È·¶¨"°´Å¥£¬´ËʱӦ¸Ã¾ÍÏÔʾÁ¬½Ó³É¹¦(ÈôÏÔʾ³ö´íÎÞ·¨Á¬½Ó£¬Çë¿´ÏÂÒ»²½µÄ´¦Àí£¬´¦ÀíºÃºóÔÙ¼ÌÐø)£¬²¢Ó¦¸ÃÔÚÊý¾Ý¿â϶àÁËÒ»¸öÃû³ÆÐÎÈ磺"jdbc:sqlserver....."µÄСͼ±ê£¬Ñ¡ÖÐËü²¢°´Êó±êÓÒ¼ü£¬Ñ¡Ôñ²Ëµ¥"Á¬½Ó..."£¬´ËʱһÇоÍOKÁË¡£
ÈôÔÚÉÏÒ»²½Ã»ÓÐÁ¬½Ó³É¹¦£¬³öÏÖ´íÎóѶϢ£¬Ó¦¸Ã¼ì²éÉÏÃæµÄ.ÄúµÄSQL ServerÊÇ·ñÓÐÆô¶¯TCP/IPͨѶЭ¶¨£¬²¢ÊÖ¹¤Ö¸¶¨ÁËPortºÅÈç1433£»2.ÄúµÄSQL ServerµÄ°²È«ÈÏÖ¤ÊÇ·ñÓÐÑ¡Ôñ»ìº


Ïà¹ØÎĵµ£º

java·´Éä»úÖÆ


package com.infowarelab.java.test;   
  
import java.lang.reflect.Field;   
import java.lang.reflect.Method;   
  
public class ReflectTester {   
    @SuppressWarnings("unchec ......

Flex+JavaÁ¬½ÓSQLServerÊý¾Ý¿â

 Ê×ÏÈ£¬×öÒ»µã˵Ã÷¡£FlexÊDz»ÄÜÖ±½ÓÁ¬½ÓÊý¾Ý¿âµÄ£¬ÕâÒ»µã´ó¼ÒÐèÒªÖªµÀ£¬ËüÖ»Äܼä½ÓµØÁ¬½ÓÊý¾Ý¿â¡£FlexÖÐÌṩÁËÈýÖÖ·½Ê½£ºHttpService£¬WebService ºÍRemoteObject¡£ÆäÖÐHttpService¿ÉÒÔÖ±½Ó»ñÈ¡XMLÖеÄÊý¾Ý£¬»¹¿ÉÒÔͨ¹ýJSP,ASPÒÔ¼°PHP¶ÁÈ¡Êý¾Ý¿âÖеÄÊý¾Ý£¬Õâ¸ö±È½Ï¼òµ¥£¬¶øÇÒÍøÉÏÒ²ÓкܶàÀý×Ó£¬ÎҾͲ»¶à˵ÁË¡£WebServi ......

javaµ÷ÓÃ.net webservice ·µ»ØͼƬ

 ¹Ø¼ü×Ö: axis
ÓÉÓÚûѧϰ¹ý.net
£¬×î½ü³ÌÐòÖÐÐèÒªµ÷ÓÃ.net
µÄwebservice
½Ó¿ÚµÃµ½Ò»ÕÅͼƬ¡£ÔÚÍøÉÏÕÒÁ˺öà×ÊÁÏÑ¡ÓõÄaxisÀ´ÊµÏÖµ÷Óá£
Ê×ÏÈ¿´¿´.net
ʵÏÖWebmehodµÄÁ½ÖÖ·½Ê½£¬ÕâÁ½ÖÖ·½Ê½java
´«²ÎÊýµÄ·½Ê½Ò²Óв»Í¬
1.rpc·½Ê½£º
Java
´úÂë
using System;     
using& ......

java»ñÈ¡µ±Ç°Â·¾¶

java»ñÈ¡µ±Ç°Â·¾¶
 
1¡¢ÀûÓÃSystem.getProperty()º¯Êý»ñÈ¡µ±Ç°Â·¾¶£º
System.out.println(System.getProperty("user.dir"));//user.dirÖ¸¶¨Á˵±Ç°µÄ·¾¶
2¡¢Ê¹ÓÃFileÌṩµÄº¯Êý»ñÈ¡µ±Ç°Â·¾¶£º
File directory = new File("");//É趨Ϊµ±Ç°Îļþ¼Ð
try{
    System.out.println(directory.getCano ......

sqlserverÖÐʹÓÃÕýÔò±í´ïʽ2

 
ÕâÁ½ÌìÓиöÐèÇó£¬ÐèÒªÔÚÊý¾Ý¿âÖÐÅжÏ×Ö·û´®µÄ¸ñʽ£¬ÓÚÊÇ´ÓÍøÉÏËѼ¯ÁËһЩ×ÊÁÏ£¬ÕûÀíÁËһϡ£
ÏÂÃæÕâ¸öÊÇÒ»¸ö×Ô¶¨Ò庯Êý£¬Óû§¿ÉÒÔµ÷ÓÃÕâ¸öº¯ÊýÅжÏÖ¸¶¨µÄ×Ö·û´®ÊÇ·ñ·ûºÏÕýÔò±í´ïʽµÄ¹æÔò.
CREATE FUNCTION dbo.find_regular_expression
(
  @source varchar(5000),   --ÐèҪƥÅäµÄÔ´× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ