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

2ÖÖÁ¬½ÓÊý¾Ý¿âºÍ¶ÁÈ¡sqlÎļþÌí¼ÓÊý¾Ý¿âºÍ±í

import java.io.*;
import java.sql.*;
public class DBConn {
 private String ADDRESS ;
 private int PORT ;
 private String DBNAME ;
 private String USERNAME ;
 private String PASSWORD ;
 private Connection conn ;
 private PreparedStatement pstmt ;
 private Statement stmt ;
 private ResultSet rs ;
 
 
 /***
  * Á¬½ÓMYSQLÊý¾Ý¿â
  * @return
  */
 public Connection getMySqlConn(){
  try{
   ADDRESS = "127.0.0.1";
   PORT = 3306;
   DBNAME = "test";
   USERNAME = "root";
   PASSWORD = "123456";
   if(conn==null){
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection("jdbc:mysql://"+ADDRESS+":"+PORT+"?user="+USERNAME+"&password="+PASSWORD+"&useUnicode=true&characterEncoding=utf8");
   }
  }catch(Exception e){
   e.printStackTrace();
  }
  return conn;
 }
 
 
 /***
  * Á¬½ÓMSSQLÊý¾Ý¿â
  * @return
  */
 public Connection getMSSqlConn(){
  try{
   
   ADDRESS = "127.0.0.1";
   PORT = 1433;
   DBNAME = "mytest";
   USERNAME = "sa";
   PASSWORD = "";
   
   if(conn==null){
    Class.forName("net.sourceforge.jtds.jdbc.Driver");
    conn = DriverManager.getConnection("jdbc:jtds:sqlserver://"+ADDRESS+":"+PORT,USERNAME,PASSWORD);
   }
  }catch(Exception e){
   e.printStackTrace();
  }
  return conn;
 }
 
 /**
  * ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
  * @return
  */
 public void closeConn(){
  try{
   


Ïà¹ØÎĵµ£º

SQLµÝ¹éÁ½ÕÅÊý¾Ý±í

²¿ÃŽṹ
Id name parentId
-----------------
1 ÈËʲ¿ 0
2
¿ª·¢²¿ 1
3 ·þÎñ²¿ 1
Óû§½á¹¹
Id name departId
--------------------
101
ÕÅÈý 2
102 ÀîËÄ 2
103 ÍõÎå 3
ÏëµÃµ½
ID name
parentId
-------------------
1 ÈËʲ¿ 0
2 ¿ª·¢²¿ 1
101
ÕÅ ......

³¹µ×Çå³ýSQL SERVERÊý¾Ý¿â

ÔÚ¸ø¸÷ºÏ×÷ѧУ°²×°Ó¦ÓÃϵͳ¹ý³ÌÖУ¬·¢ÏÖѧУÀïµÄSQL SERVER 2000Êý¾Ý¿âËð»µÁË֨װºó¶¼·¢ÉúÁËͬÑùµÄÎÊÌ⣬ÄǾÍÊǰ²×°SQL SERVERÊý¾Ý¿â²»³É¹¦¡£Ô­Òò£º¼´Ê¹Äãͨ¹ý¿ØÖÆÃæ°åÀïµÄ“Ìí¼Ó/ɾ³ý³ÌÐò” Õý³£µÄÐ¶ÔØSQL SERVERÊý¾Ý¿â£¬µ«ÊÇ£¬SQL SERVER»¹ÊÇûÓÐÍêÈ«Ð¶ÔØ¸É¾»£¬»¹ÐèÒªÊÖ¹¤½øÐÐһЩ²Ù×÷¡£Òò´ËÖØÐ°²×°²»³É¹¦£¬º ......

¹úÍâ¿Õ¼äSqlÊý¾ÝÂÒÂëÎÊÌâ

¹úÍâ¿Õ¼äÃ²ËÆ¶ÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆÎª varchar ÀàÐ͵ϰ ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ  "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆÎª nvarchar ÀàÐÍ
create table cs
(
   txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ')  -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt ......

SQL·ÖÒ³


SQL·ÖÒ³
ÍòÄÜ·ÖÒ³
.net´úÂë
select top Ã¿Ò³ÏÔʾµÄ¼Ç¼Êý * from topic where id not in     
 (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc)  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ