你有没有限制的jdbc for sql2000的驱动吗?发一份给我吧。[email protected]
解决方案 »
- 请教一个问题
- java比较英语单词
- 一个outputStream的write方法的问题?
- 新手问题!!.进来看看啊
- 如何在JFileChooser中以xml形式保存文件
- 如何将word,ps等格式的文件转为pdf格式,
- 怎样得到一个文件的创建时间??
- 请问怎样用java来实现sqlserver数据库的备份和恢复
- 求websphere4.0升级到4.03升级包的下载地址!以及如何升级!!
- Linux下的Java开发环境????
- 一个方法中,用Connection con变量连接数据库,执行完sql以后,关闭con,返回resultset,报错“关闭的连接: next”
- java在执行时,与代码的书写顺序有关吗?
import java.sql.*;
import javax.servlet.*;
public class connSql
{
private String strDBDriver=null;
private String strConn=null;
private String strDataBase=null;
private String strUser=null;
private String strPassWord=null;
private String strHint=null;
private int nConnCount=0;
private Connection conn=null;
private ResultSet rs=null;
private Statement stmt=null;
public connSql()
{
//Microsoft Sql Server 2000 JDBC
strDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
strConn="jdbc:microsoft:sqlserver://sq:1433";
//opta 2000 JDBC
//strDBDriver="com.inet.tds.TdsDriver";
//strConn="jdbc:inetdae:sq:1433?sql7=true";
//common variable
strHint="Initializing...";
nConnCount=0;
strDataBase="club";
strUser="sa";
strPassWord="";
}
public String getStrHint()
{
return strHint;
}
public int getNConnCount()
{
return nConnCount;
}
public String getDBDriver()
{
return strDBDriver;
}
public String getConn()
{
return strConn;
}
public boolean initDBDriver()
{
try
{
Class.forName(strDBDriver);
strHint="Initialization successfully";
return true;
}
catch(java.lang.ClassNotFoundException err)
{
strHint="Initialization :"+err.getMessage();
return false;
}
}
public ResultSet executeQuery(String strSql)
{
rs=null;
try
{
conn=DriverManager.getConnection(strConn,strUser,strPassWord);
conn.setCatalog(strDataBase);
stmt=conn.createStatement();
rs=stmt.executeQuery(strSql);
nConnCount++;
}
catch(SQLException err)
{
strHint="executeQuery: "+err.getMessage();
}
return rs;
}
public boolean executeUpdate(String strSql)
{
try
{
conn=DriverManager.getConnection(strConn,strUser,strPassWord);
conn.setCatalog(strDataBase);
stmt=conn.createStatement();
stmt.executeUpdate(strSql);
nConnCount++;
return true;
}
catch(SQLException err)
{
strHint="executeUpdate: "+err.getMessage();
return false;
}
}
public boolean closeConn()
{
try
{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(conn!=null)
{
conn.close();
}
return true;
}
catch(SQLException err)
{
strHint="closeConnection: "+err.getMessage();
return false;
}
}
public static String parseChinese(String in)
{
String s=null;
byte temp[];
if(in==null)
{
System.out.println("Warn:null");
return new String("");
}
try
{
temp=in.getBytes("iso-8859-1");
s=new String(temp);
}
catch(Exception err)
{
System.out.println(err.toString());
}
return s;
}
public static void main(String[] args)
{
connSql clsTemp=new connSql();
System.out.println(clsTemp.getStrHint());
ResultSet rsTemp=null;
String strTemp=null;
try
{
clsTemp.initDBDriver();
rsTemp=clsTemp.executeQuery("select * from dept");
while(rsTemp.next())
{
//strTemp=parseChinese(rsTemp.getString("dname"));
strTemp=(rsTemp.getString("dname"));
System.out.println(strTemp);
}
System.out.println("THE COUNT OF CONNECTION IS:"+clsTemp.getNConnCount());
clsTemp.closeConn();
}
catch(Exception e)
{
System.out.println(e.toString());
e.printStackTrace();
}
}
}
http://www.microsoft.com/sql/downloads/2000/jdbc.asp
public class sqlserver
{
public static void main(String args[])
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("load success");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.21:1433","study","study");
System.out.println("connected jdbc");
conn.setCatalog("club");
conn.close();
}catch(Exception e){
System.out.println(e);
}
}
}
那下面的代码有错误吗?但是实际就是不行,说找不到com.microsoft.jdbc.sqlserver.SQLServerDriver
要去download一个mssql的jdbc驱动程序,然后在jbuilder中设置classpath,加入jdbc驱动程序,如果是freetds_jdbc.jar
可以这样写,以下运行okimport java.sql.*;
import com.internetcds.jdbc.tds.*;
public class sqlserver
{
public static void main(String args[])
{
try{
Class.forName("com.internetcds.jdbc.tds.Driver");
System.out.println("load success");
}catch(Exception e){
System.out.println(e);
}
}
}