jdbs mssql

最近看jsp，被弄糊了好多次，特别是干JDBC的时候，完全蒙了，先以为SUN公司在怎么也得把比较出名得数据库得驱动集成进去，结果 。
       老大些说了，时不时的把解决问题得过程记下来，呵~~~，经过我驱猫上网，终于，那在那BaiDu的一角发现了它，"ci qu dong bi xu zai http://windowsupdate.microsoft.com/ down yi ge "当场久晕到~~~先还以为是鸟语~~，可是这还不是为难得地方，那个下载地址才是关键呀找到了几个


       sun:   http://developers.sun.com/product/jdbc/drivers （不推荐）
Microsoft:  http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en (不推荐)
自己用的： http://file.mofile.com/cn/docs/index.do?currentFolderID=16090965 （文件提取码： 0113870640464819）
Microsoft SQL Server 2005 JDBC 驱动程序
http://www.microsoft.com/downloads/details.aspx?FamilyID=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&DisplayLang=zh-cn




还要做得就是，那他加入环境变量（必须）
如果是windows，将安装目录下的三个jar文件添加到CLASSPATH中， 绿色的为添加的  
自己得设置：
CLASSPATH    .;%JAVA_HOME%/lib/dt.jar;%JAVA_HOME%/lib/tools.jar; %TOMCAT%/msbase.jar;%TOMCAT%/mssqlserver.jar;%TOMCAT%/msutil.jar
TOMCAT     c:/IDE/Tomcat5.0/common/lib(解压的文件存放位置)

别以为到这里就完了~你还得看看你得sql2000 打了sp3补丁了么，没打话打上，别期望没这补丁你就那么轻易的连上了sql2000。
Microsoft:  http://www.microsoft.com/downloads/details.aspx?familyid=7824ba50-3e29-45cf-8c02-5597c014a707&displaylang=en (安全)


mport java.sql.*;
public class LinkDB {
    public static void main(String arg[]) throws NoClassDefFoundError,ClassNotFoundException,SQLException,Exception {
     Connection con=null;
     String  url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
     String UserName="test";
     String PassWord="admin";
     try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
      System.out.println("连接中");
      con=DriverManager.getConnection(url,UserName,PassWord);
      System.out.println("连接完成");
      Statement stmt=con.createStatement();
      String sql="create table test(id int,name char)";
      stmt.executeUpdate(sql);
      System.out.println("表已经添加进去了");
     }
     catch(NoClassDefFoundError ncdfe){
      System.out.println("No Class Define Found Error");
     }
     catch(ClassNotFoundException cnfe){
      System.out.println("ClassNotFoundException");
     }
     catch(SQLException sqle){
      System.out.println("SQLException:"+sqle.toString());
     }catch(Exception e){
      System.out.println("An unknow error"+e.toString());
     }
     finally{
       try{
        if(con!=null){
         con.close();
        }
        else {
         System.out.println("数据库根本没连接");
        }
       }
       catch(Exception e){
         System.out.println("无法关闭数据库");
          }
        
           }
    
    
    }
}


经过执行这段代码，会载pubs数据库中新建一个test的表

网上流传着一种 mysql/oracle/sybase 通用JDBC驱动，有兴趣得朋友可以去看看
网址： http://www.dingl.com/view.shtml?xh=547

附上其他DataBase的资料（以下为网上copy的，谨慎使用，仅供参考）
Db Name: oracle
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: Connector/J
Home Page: http://www.oracle.com/technology/software/tech/java/
JDBC Ver: (based on oracle)
Download: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/
Conn Code:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");
Db Name: MySQL
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: Connector/J
Home Page: http://dev.mysql.com/
JDBC Ver: 3.1
Download: http://dev.mysql.com/downloads/
Conn Code:
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");
Db Name: Sybase
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: jConnect
Home Page: http://www.sybase.com.cn/cn/content/SDN/
JDBC Ver: 4.5/5.5
Download: http://www.sybase.com/detail_list?id=13&morenavId=8668&multi=true&SR=Y&show=1265
Conn Code:
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
DriverManager.getConnection("jdbc:sybase:Tds:IP:2638?ServiceName="+database,"user","password");
Db Name: Postgresql
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: PostgreSQL JDBC
Home Page: http://jdbc.postgresql.org/
JDBC Ver: 8.0 Build 310
Download: http://jdbc.postgresql.org/download.html
Conn Code:
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");
Db Name: IBM Informix
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: Informix JDBC Driver (IBM Informix JDBC V3.0)
Home Page: http://www-306.ibm.com/software/data/informix/
JDBC Ver: 3.0.JC1
Download: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc
Conn Code:
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
Connection conn= DriverManager.getConnection("jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";);
Db Name: IBM DB2
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
JDBC Name: DB2 JDBC Universal Driver
Home Page: http://www-306.ibm.com/software/data/db2/udb/
JDBC Ver:
Download: http://www-128.ibm.com/developerworks/db2/downloads/jcc/
Conn Code:
Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
Connection conn= DriverManager.getConnection("jdbc:db2://localhost:5000/sample",user,password);
IBM AS400主机在用的JDBC语法
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
有装V4R4以上版本的Client Access Express
可以在C:Program FilesIBMClient Accessjt400lib
找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar
Conn Code:
java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());
Class.forName("com.ibm.as400.access.AS400JDBCConnection");
con = DriverManager.getConnection("jdbc:as400://IP","user","password");
Db Name: Ms Access or Ms Foxpro
~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~
Conn Code:
step 1: 配置 odbc (例如：myDb)
step 2:
String dbURL = "jdbc:odbc:myDb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
　Connection conn = DriverManager.getConnection(dbURL);
or
String dbURL = "jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=dabaseName.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
　Connection conn = DriverManager.getConnection(dbURL);
 
 
呵呵~~侃侃~~经验