#############连SQL Server2000库时抛出奇怪的错误################

Question

你的sql server是否有sp3补丁？

Answer 1

package Bean;import java.sql.*;
import  java.io.*;  
import  java.io.File;
import  javax.servlet.http.*;
import javax.servlet.*;
public class ConnectionData
{
   public Statement stmt;
   public Connection conn;
   public ResultSet rs;
   boolean  packFrame  =  false;  
   String dir=new String();
   int copy=0;
   PreparedStatement ps=null;
public void getConnection()
{
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String SERVANDDB="jdbc:microsoft:sqlserver://168.160.192.88:1433;DatabaseName=a";
    String USER="a";
    String PWD="a"; 
    
    try 
     {
       Class.forName(CLASSFORNAME).newInstance();
            conn=DriverManager.getConnection(SERVANDDB,USER,PWD);
            stmt=conn.createStatemen();//ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            
            //stmt=conn.createStatement();
// stmt.executeUpdate(sql);
     }
    catch(Exception ex){
       ex.printStackTrace();
       }
   
}
    public void close()
{
try
{
if(conn!=null)
{
rs.close();
stmt.close();
conn.close();
//rs=null;
//stmt=null;
//conn=null;
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}

public boolean QueryData(String sql)
{
try
{
getConnection();
if(conn!=null)
{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if(!rs.next())
{
return false;
}
else
{
return true;
}
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
return false;
}

public ResultSet Query(String sql)
{
try
{
getConnection();
if(conn!=null)
{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
return rs;
}


public boolean Update (String sql){
try{
getConnection();
if(conn!=null){
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
return true;
}
catch(Exception e)
{
System.out.println(e.getMessage());
return false;
} }