JAVA Á¬½Ó SQLServer 2000.
JAVA Á¬½Ó SQLServer 2000 ËùÐèÒªµÄÈý¸öJAR°ü¡£
http://download.csdn.net/source/2283940
----------------
Code:
------------------------
Connection conn = null;
Statement sta = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
if (conn == null || conn.isClosed()) {
conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa", "");
}
sta = conn.createStatement();
ResultSet rs = sta.executeQuery("select * from jobs ");
while (rs.next()) {
System.out.print(rs.getInt(1) + "\t");
System.out.print(rs.getString(2) + "\t");
System.out.print(rs.getString(3) + "\t");
System.out.println(rs.getString(4));
System.out.println("--------------------------");
}
} catch (Exception e) {
System.out.println(e);
}
Ïà¹ØÎĵµ£º
×î½üÓÉÓÚÒª»»î¶¯Í¼£¬ËùÒÔÐèÒª»´øÓмýÍ·µÄÏ߶Σ¬ÓÚÊǽáºÏÓйØ×ÊÁÏ£¬Ð´³öÁËÕâ¸ö·½·¨¡£
import java.awt.*;
import javax.swing.*;
import java.awt.geom.*;
public class test//¶ÁÕß¿ÉÒÔ¸ü¸ÄÀàtestµÄÃû×Ö£¬ÒÔÊʺÏ×Ô¼º¶¨ÒåµÄ.javaÎļþ£¬ÒòΪËüÖ»ÊÇÓÃÀ´²âÊԵġ£
{
public static void main (String args[]){
&nb ......
windows xpÏÂÅäÖÃJDK»·¾³±äÁ¿£º
1.°²×°JDK£¬°²×°¹ý³ÌÖпÉÒÔ×Ô¶¨Ò尲װĿ¼µÈÐÅÏ¢£¬ÀýÈçÎÒÃÇÑ¡Ôñ°²×°Ä¿Â¼ÎªD:\java\jdk1.5.0_08£»
2.°²×°Íê³Éºó£¬ÓÒ»÷“ÎҵĵçÄÔ”£¬µã»÷“ÊôÐÔ”£»
3.Ñ¡Ôñ“¸ß¼¶”Ñ¡Ï£¬µã»÷“»·¾³±äÁ¿”£»
&nb ......
ÔÚ SQLServer2005 ÖÐ¶Ô XML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊÇ¶Ô xml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......
½«Ä³ class ²úÉú³öÒ»¸ö instance Ö®ºó£¬´Ë class ËùÓÐµÄ instance field ¶¼»áÐÂÔöÒ»·Ý£¬ÄÇôËùÓÐµÄ instance method ÊÇ·ñÒ²»áÐÂÔöÒ»·Ý£¿´ð°¸ÊDz»»á£¬ÎÒÃÇÓÃfield±íʾ×ֶΣ¬ÓÃmethod±íʾ·½·¨£¬ÄÇô¼ÓÉÏstaticÇø·Öºó¾Í ÓÐËÄÖÖ£º
class field£ºÓÐÓÃstaticÐÞÊεÄfield
class method£ºÓÐÓÃstaticÐÞÊεÄmethod
instance fi ......
1.JavaµÄ´úÂëÒ»°ã·ÖΪÁ½´óÀࣺһÖÖÊǽṹ¶¨ÒåÓï¾ä£»Ò»ÖÖÊǹ¦ÄÜÓï¾ä£¨¹¦ÄÜÓï¾äÒªÓ÷ֺŽá⣩¡£
2.ÓÃ/* ÄÚÈÝ */×¢ÊÍ£¬ÄÚÈÝÀïÃæÊDz»ÄÜ´æÔÚ/* */µÄ£»µ«ÊÇ¿ÉÒÔ´æÔÚ//£»ÒòΪÕâÑù¾Í²»»á·¢Éúϵͳ²»ÖªµÀÄĸö*/²ÅÊÇÕæµÄ½áÊø·û¡£
3.±äÁ¿Ê¹ÓÃÇ°±ØÐë³õʼ»¯£¬Ê¹Óõ¥ÒýºÅµÄ×÷ÓþÍÊÇ°ÑÀïÃæµÄ×Ö ......