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

javaÊý¾Ý¿âÁ¬½Ó¼°²âÊÔ(sqlserver)


package com.test.util;
import java.sql.*;
public class ConnectDB {
 private Connection conn=null;
 private PreparedStatement pt=null;
 private ResultSet rs=null;
 private String uname="sa";
 private String upwd="sa";
 private String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=vsktest";
 
 
 public Connection getConnection() throws Exception{
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  conn=DriverManager.getConnection(url, uname, upwd);
  return conn;  
 }
 public void closeDB() throws Exception{
  if(rs!=null){
   rs.close();
  }
  if(pt!=null){
   pt.close();
  }
  if(conn!=null){
   conn.close();
  }
   
 }
 public static void main(String[] args) throws Exception {
  Connection conn=new ConnectDB().getConnection();
  PreparedStatement pt=conn.prepareStatement("select * from test");
  ResultSet rs=pt.executeQuery();
  while(rs.next())
  {
   System.out.println(rs.getString("testname"));
  }
   
 }//end main
}


Ïà¹ØÎĵµ£º

ÀûÓÃjmapºÍheapAnalyzer¶Ôjava½ø³Ì½øÐÐÄÚ´æÊ¹ÓÃÂÊ·ÖÎö

ÓÐʱºòÎÒÃÇ»áÓöµ½java³ÌÐòʹÓÃÄÚ´æ¹ý¶àµÄÇé¿ö£¬ÕâÖÖÇé¿öÒ»°ãÊÇÒòΪ³ÌÐòÓÐÄÚ´æÐ¹Â©£¬ÄÇôÈçºÎ·ÖÎöÊÇ·ñÓÐÄÚ´æÐ¹Â©ÄØ£¿ÆäʵԭÒò±È½Ï¼òµ¥£¬ÏÈÓÃjmapÀ´Éú³ÉÒ»¸ö½ø³ÌµÄÄÚ´æ¿ìÕÕ£¬È»ºóÀûÓÃheapAnalyzer»òÕßMod4JÀ´¶ÔÕâ¸ö¿ìÕÕ½øÐзÖÎö£¬ÕÒµ½ÄÚ´æÊ¹ÓÃ×î¶àµÄ¶ÔÏ󡣯äʵÓÐÎÞÄÚ´æÐ¹Â©µÄÒ»¸ö±íÏÖ¾ÍÊÇÄÚ´æ·Ö²¼ÊÇ·ñ¾ùÔÈ£¬Èç¹û²»¾ùÔÈ£¬Ò»°ãÀ ......

ArrayParameters.java £¨j»ù p45£©

//´«µÝ²ÎÊý£¬ºÍcÖд«µØÖ·ÓеãÏñ
public class ArrayParameters {
public static void changeOrNot (int i, double[] x) {
i =-1;
x[0] = -2.0;
double[] y = x;
y[1] = -3.0;
double[] z = {4.0, 4.0, 4.0};
x = z;
}
public static void main (String[] args) {
String s1 = ......

XpϵͳÏÂsqlServer 2000ÖÐ1433¶Ë¿Ú´ò²»¿ªµÄÎÊÌâ

 ÎÒ×°µÄÊÇXpϵͳ£¬µ±ÎÒ×°Sql Server2000Êý¾Ý¿âºó£¬ÓÃJava³ÌÐòÀ´½øÐÐÊý¾Ý¿âÁ¬½Óʱ³ö´íÁË£¬·¢ÏÖÊÇ1433¶Ë¿ÚûÓдò¿ª£¬ÔÚÍøÉÏÕÒÁËЩ½â¾ö°ì·¨£¬·½·¨ËµµÄ²»ÊǺÜÇå³þ£¬»¹ÓеãÂÞàÂÁË¡£ÎÒ½â¾öºó·¢ÏÖ°ì·¨ÊÇ£ºÊ×ÏÈÊDz鿴ÄãµÄ°æ±¾£¬¿ÉÒÔÓÃselect @@versionÀ´²é¿´¡£×°ÍêSql Server 2000 1433¶Ë¿ÚÓÐÊÇûÓдò¿ª£¬¿ÉÒÔÓÃnet -an -p tcp ......

javaѧϰ˳Ðò

½áºÏ±¾ÈËѧϰ¾­ÑéºÍÍøÉÏÅàѵ»ú¹¹µÄ×ÊÁÏ£¬ÁгöjavaѧϰµÄ˳Ðò¡£
Ò»£ºJ2SE
¡ðÃæÏò¶ÔÏó£­·â×°¡¢¼Ì³Ð¡¢¶à̬
¡ðÄÚ´æµÄ·ÖÎö
¡ðµÝ¹é
¡ð¼¯ºÏÀà¡¢·ºÐÍ¡¢×Ô¶¯´ò°üÓë½â°ü¡¢Annotation
¡ðIO
¡ð¶àÏ̡߳¢Ïß³Ìͬ²½
¡ðTCP/UDP
¡ðAWT¡¢Ê¼þÄ£ÐÍ¡¢ÄäÃûÀà
¡ðÕýÔò±í´ïʽ
¡ð·´Éä»úÖÆ
2£ºÊý¾Ý¿â£¨Oracle»òÕßMySQL£©
¡ðSQLÓï¾ä ......

java ÊÂÎñÏÝÚå

ÕâÆªÎÄ×ÖдµÄºÜºÃ£¬ÍƼö¸ø×Ô¼ººÍ´ó¼Ò£¡
ÊÂÎñ²ßÂÔ: Á˽âÊÂÎñÏÝÚå
ÔÚ Java ƽ̨ÖÐʵÏÖÊÂÎñʱҪעÒâµÄ³£¼û´íÎó
 
 
 
¼¶±ð£º Öм¶
Mark Richards, Ö÷¹ÜºÍ¸ß¼¶¼¼Êõ¼Ü¹¹Ê¦, Collaborative Consulting, LLC
2009 Äê 3 ÔÂ 06 ÈÕ
ÊÂÎñ´¦ÀíµÄÄ¿±êÓ¦¸ÃÊÇʵÏÖÊý¾ÝµÄ¸ß¶ÈÍêÕûÐÔºÍÒ»ÖÂÐÔ¡£±¾ÎÄÊÇΪ Java ƽ̨¿ª· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ