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µÄ°²È«ÈÏÖ¤ÊÇ·ñÓÐÑ¡Ôñ»ìº
Ïà¹ØÎĵµ£º
package com.infowarelab.java.test;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
public class ReflectTester {
@SuppressWarnings("unchec ......
Ê×ÏÈ£¬×öÒ»µã˵Ã÷¡£FlexÊDz»ÄÜÖ±½ÓÁ¬½ÓÊý¾Ý¿âµÄ£¬ÕâÒ»µã´ó¼ÒÐèÒªÖªµÀ£¬ËüÖ»Äܼä½ÓµØÁ¬½ÓÊý¾Ý¿â¡£FlexÖÐÌṩÁËÈýÖÖ·½Ê½£ºHttpService£¬WebService ºÍRemoteObject¡£ÆäÖÐHttpService¿ÉÒÔÖ±½Ó»ñÈ¡XMLÖеÄÊý¾Ý£¬»¹¿ÉÒÔͨ¹ýJSP,ASPÒÔ¼°PHP¶ÁÈ¡Êý¾Ý¿âÖеÄÊý¾Ý£¬Õâ¸ö±È½Ï¼òµ¥£¬¶øÇÒÍøÉÏÒ²ÓкܶàÀý×Ó£¬ÎҾͲ»¶à˵ÁË¡£WebServi ......
¹Ø¼ü×Ö: axis
ÓÉÓÚûѧϰ¹ý.net
£¬×î½ü³ÌÐòÖÐÐèÒªµ÷ÓÃ.net
µÄwebservice
½Ó¿ÚµÃµ½Ò»ÕÅͼƬ¡£ÔÚÍøÉÏÕÒÁ˺öà×ÊÁÏÑ¡ÓõÄaxisÀ´ÊµÏÖµ÷Óá£
Ê×ÏÈ¿´¿´.net
ʵÏÖWebmehodµÄÁ½ÖÖ·½Ê½£¬ÕâÁ½ÖÖ·½Ê½java
´«²ÎÊýµÄ·½Ê½Ò²Óв»Í¬
1.rpc·½Ê½£º
Java
´úÂë
using System;
using& ......
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 ......
ÕâÁ½ÌìÓиöÐèÇó£¬ÐèÒªÔÚÊý¾Ý¿âÖÐÅжÏ×Ö·û´®µÄ¸ñʽ£¬ÓÚÊÇ´ÓÍøÉÏËѼ¯ÁËһЩ×ÊÁÏ£¬ÕûÀíÁËһϡ£
ÏÂÃæÕâ¸öÊÇÒ»¸ö×Ô¶¨Ò庯Êý£¬Óû§¿ÉÒÔµ÷ÓÃÕâ¸öº¯ÊýÅжÏÖ¸¶¨µÄ×Ö·û´®ÊÇ·ñ·ûºÏÕýÔò±í´ïʽµÄ¹æÔò.
CREATE FUNCTION dbo.find_regular_expression
(
@source varchar(5000), --ÐèҪƥÅäµÄÔ´× ......