这个是我连接数据库的JAVA代码
package com.csl.imis.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class DBConnectSQL
{
public static void main(String[] args)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//设置JDBC-ODB驱动程序类型
System.out.println( "classforname sucess!" );
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","");//建立ODBC数据源之间的连接
System.out.println( "classforname sucess!" );
Statement stmt=con.createStatement();
System.out.println( "createStatement sucess!" );
ResultSet rs=stmt.executeQuery("select * from BackSale");
//显示结果
while(rs.next())
{
System.out.print("\t 退货单编号: "+rs.getString(1));
System.out.print("\t 退货日期: "+rs.getString(2));
System.out.print("\t 退货部门: "+rs.getString(3));
System.out.print("\t 退入仓库: "+rs.getString(4));
System.out.print("\t 退货人 : "+rs.getString(5));
System.out.print("\t 退货原因 : "+rs.getString(6));
}
rs.close(); //释放资源
stmt.close();
con.close();
}catch(Exception e)
{
e.printStackTrace();
}
}}
package com.csl.imis.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class DBConnectSQL
{
public static void main(String[] args)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//设置JDBC-ODB驱动程序类型
System.out.println( "classforname sucess!" );
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","");//建立ODBC数据源之间的连接
System.out.println( "classforname sucess!" );
Statement stmt=con.createStatement();
System.out.println( "createStatement sucess!" );
ResultSet rs=stmt.executeQuery("select * from BackSale");
//显示结果
while(rs.next())
{
System.out.print("\t 退货单编号: "+rs.getString(1));
System.out.print("\t 退货日期: "+rs.getString(2));
System.out.print("\t 退货部门: "+rs.getString(3));
System.out.print("\t 退入仓库: "+rs.getString(4));
System.out.print("\t 退货人 : "+rs.getString(5));
System.out.print("\t 退货原因 : "+rs.getString(6));
}
rs.close(); //释放资源
stmt.close();
con.close();
}catch(Exception e)
{
e.printStackTrace();
}
}}
我在CLASSPATH 已经设置了这三个文件的环境变量,
为什么还是不行啊,,
我的数据库是用SQL SERVER2000 打了SP3和SP4补丁,,
数据源测试时是成功的,
WEB-INF 的 lib 目录下就可以了。
解压后的文件夹结构为:
com-
|
microsoft
|
jdbc,jdbcx,util
注意,你应该将解压后的文件放入对应的文件夹里,然后将此com下的文件放入你的程序文件夹com下
加入Mic的sql jar包
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=name","sa","");
import java.sql.*;
class PureDriver{
public static void main(String [] args){
Connection con=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost;DatabaseName=pubs";
con=DriverManager.getConnection(url,"sa","");
System.out.println ("成功");
}catch(SQLException s){
s.printStackTrace();
}catch(Exception c){
c.printStackTrace();
}finally{
try{
if(con!=null)con.close();
}catch(Exception s){
s.printStackTrace();
}
}
}
}