JAVAÁ¬½Ósql server 2005 Êý¾Ý¿âÐĵÃ
Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ÉèÖÃΪ°üº¬ sqljdbc.jar Îļþ¡£Èç¹û classpath ȱÉÙ sqljdbc.jar ÏӦÓóÌÐò½«Òý·¢“ÕÒ²»µ½Àà”µÄ³£¼ûÒì³£¡£
sqljdbc.jar ÎļþµÄ°²×°Î»ÖÃÈçÏ£º
<°²×°Ä¿Â¼>\sqljdbc_<°æ±¾>\<ÓïÑÔ>\sqljdbc.jar
ÏÂÃæÊÇÓÃÓÚ Windows Ó¦ÓóÌÐòµÄ CLASSPATH Óï¾äʵÀý£º
CLASSPATH =.;%ProgramFiles%\sqljdbc_1.2\chs\sqljdbc.jar
ÉèÖÃSQL Server·þÎñÆ÷
ÎÒʹÓõÄÊÇSQL Server 2005±ê×¼°æSP2£¬ÕâЩ¶¼Ä¬Èϼ´¿É£¬Ò»°ã²»ÓÃÅäÖá£Èç¹ûÐèÒªÅäÖö˿ÚÇë¿´ÏÂÃæ¡£
1¡¢“¿ªÊ¼”→“³ÌÐò”→“Microsoft SQL Server 2005”→“ÅäÖù¤¾ß”→“SQL Server ÅäÖùÜÀíÆ÷”→“SQL Server 2005 ÍøÂçÅäÖÔ→“MSSQLSERVER µÄÐÒé”
2¡¢Èç¹û“TCP/IP”ûÓÐÆôÓã¬ÓÒ¼üµ¥»÷Ñ¡Ôñ“Æô¶¯”¡£
3¡¢Ë«»÷“TCP/IP”½øÈëÊôÐÔÉèÖã¬ÔÚ“IP µØÖ·”À¿ÉÒÔÅäÖÓIPAll”ÖеēTCP ¶Ë¿Ú”£¬Ä¬ÈÏΪ1433¡£
4¡¢ÖØÐÂÆô¶¯SQL Server»òÕßÖØÆô¼ÆËã»ú¡£
½¨ÒéÖØÆôµçÄÔ¡£
ÔÚEclipseÖвâÊÔ
1¡¢´ò¿ªEclipse£¬“Îļþ”→“н¨”→“ÏîÄ¿”→“Java ÏîÄ¿”£¬ÏîÄ¿ÃûΪTest
2¡¢ÔÚEclipseÖУ¬Ñ¡Ôñ“´°¿Ú”→“Ê×Ñ¡Ïî...”→“Java”→“ÒѰ²×°µÄ JRE”£¬Ñ¡ÔñÒѰ²×°µÄ JRE£¬µã»÷“±à¼”→“Ìí¼ÓÍⲿ”£¬Ñ¡Ôñ%ProgramFiles%\sqljdbc_1.1\chs\sqljdbc.jar
3¡¢ÔÚTestÏîÄ¿µÄ“JRE ϵͳ¿â”ÖпÉÒÔ¿´¼ûsqljdbc.jar£¬Èç¹ûûÓпÉÒÔÓÒ¼üµ¥»÷ÏîÄ¿Test→“¹¹½¨Â·¾¶”→“ÅäÖù¹½¨Â·¾¶...”→“Java ¹¹½¨Â·¾¶”→“¿â”→“Ìí¼ÓÍⲿ JAR...”£¬Ñ¡Ôñ%ProgramFiles%\sqljdbc_1.1\chs\sqljdbc.jar
4¡¢±àдJava´úÂ룬ÈçÏ£º
import java.sql.*;
public class
Ïà¹ØÎĵµ£º
ûÓбØÒªÓÃÒ»¶ÑÈÆ¿ÚµÄÐÎÈÝ´ÊÀ´ÃèÊöʲô½Ð¶à̬£¬Ö»¾Ù³ö¼¸¸ö¹Ø¼üµã¡£
É裺gunΪ¸¸À࣬shootgunºÍpistolΪgunµÄ×ÓÀà¡£
Java:
class gun {
void shoot() {
  ......
JavaµÄÏ̵߳÷¶È²Ù×÷ÔÚÔËÐÐʱÊÇÓëÆ½Ì¨Î޹صġ£Ò»¸ö¶àÈÎÎñϵͳÐèÒªÔÚÈÎÎñÖ®¼äʵÏÖQoS(Quality of Service)¹ÜÀíʱ£¬Èç¹ûCPU×ÊÔ´µÄ·ÖÅä»ùÓÚJavaÏ̵߳ÄÓÅÏȼ¶£¬ÄÇôËüÔÚ²»Í¬Æ½Ì¨ÉÏÔËÐÐʱµÄЧ¹ûÊǺÜÄÑÔ¤²âµÄ¡£±¾ÎÄÀûÓÃе÷ʽ¶àÈÎÎñÄ£ÐÍ£¬Ìá³öÒ»¸öÓëÆ½Ì¨Î޹ء¢²¢ÇÒÄÜÔÚÈÎÎñ¼ä¶¯Ì¬·ÖÅäCPU×ÊÔ´µÄ·½°¸¡£
ÏÖÔÚ£¬ÓÉÓÚ¼ÆËã»úϵͳÒѾ´ÓÈ ......
JavaÐéÄâ»úĬÈÏ·ÖÅä64MÄڴ棬Èç¹ûÄãµÄÓ¦ÓñȽϴ󣬳¬³ö64MÄڴ棬JavaÐéÄâ»ú¾Í»áÅ׳öOutOfMemoryError£¬²¢Í£Ö¹ÔËÐС£²»¹ÜÊÇʲôӦÓã¨WebÓ¦Óá¢ApplicationµÈ£©£¬Ö»ÐèÒªÐÞ¸ÄÄãµÄ»úÆ÷ÉϵÄÔËÐÐJavaÃüÁÔÚjava xxxÃüÁîÖÐÌí¼Ó-Xms(×îСʹÓÃÄÚ´æ)¡¢-Xmx£¨×î´óʹÓÃÄڴ棩¼´¿É½â¾ö¡£µ±È»£¬Õâ¶ùµÄÄÚ´æÈÝÁ¿¶¼ÊÇÖ¸ÎïÀíÄڴ棬²»Ä ......
±¾ÎÄÊôÓÚ×ªÔØ£¬ÔÚ±¾ÏµÁеĵڶþ²¿·Ö»áÌÖÂÛ¸ü¼Ó¸´ÔÓµÄÇé¿ö¡£
ÏÂÃæµÄÂÛÊöÕë¶Ô32λϵͳ£¬¶Ô64λϵͳ²»ÊÊÓ㬺óÐð¾³£ÄãдÁËÒ»¸ö³ÌÐò£¬Ò»²âÊÔ£¬¹¦ÄÜûÎÊÌ⣬һ¿´ÄÚ´æÕ¼ÓÃÒ²²»¶à£¬¾Í²»È¥¿¼ÂÇÆäËüµÄ¶«Î÷ÁË¡£µ«¿ÉÄܳÌÐòʹÓÃÁËÒ»¸öʲôÊý¾Ý½á¹¹£¬»áµ±Êý¾Ý¹æÄ£±ä´óʱ£¬ÄÚ´æÕ¼Óü¤Ôö¡£
»ù±¾&&¹Ø¼üµÄÎÊÌâÊÇ£¬JavaÀï¸÷ÖÖ¶«¶«Õ ......
1.¼ÆËãijһÔ·ݵÄ×î´óÌìÊý
Calendar time=Calendar.getInstance();
time.clear();
time.set(Calendar.YEAR,year); //year Ϊ int
time.set(Calendar.MONTH,i-1);//×¢Òâ,Calendar¶ÔÏóĬÈÏÒ»ÔÂΪ0
int day=time.getActualMaximum(Calendar.DAY_OF_MONTH);//±¾Ô·ݵÄÌìÊý
×¢£ºÔÚʹÓÃset·½·¨Ö®Ç°£¬±ØÐëÏÈ ......