不知道为什么啊! jdbc-odbc能连!但下面这个就报异常
------------------------------------下面是Pubs.jsp--------------------------------------------------
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" import="java.util.*,accp.*,java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<table>
<tr>
<td>Author ID</td>
</tr>
<%
PubsBean bean=new PubsBean();
ArrayList<String> ids=bean.getIDs();
for(String id:ids)
{
// out.print("<tr><td><a href='show.jsp?au_id="+id+"'>"+id+"</a></td></tr>");
// out.print("<tr><td>"+id+"</td></tr>");
out.print("<tr><td><a href='show.jsp?"+id+"'>"+id.substring(id.indexOf("=")+1,id.indexOf("&"))+"</a></td></tr>");
}
%>
</table>
</body>
</html>
---------------------------------------下面是PubsBean类------------------------------------------------
package accp;
import java.awt.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
public class PubsBean {
Connection conn=null;
Statement stat=null;
ResultSet rset=null;
public ArrayList<String> getIDs() throws Exception
{
ArrayList<String> ids=new ArrayList<String>();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:19888;DatabaseName=pubs","sa","sa");
stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rset=stat.executeQuery("select au_id,au_fname,au_lname from authors");
while(rset.next())
ids.add("au_id="+rset.getString(1)+"&au_fullname="+rset.getString(2)+"."+rset.getString(3));
rset.close();
stat.close();
conn.close();
return ids;
}
public String getFullNameById(String id) throws Exception
{
String fullname="";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:19888;DatabaseName=pubs","sa","sa");
stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rset=stat.executeQuery("select au_fname+'.'+au_lname from authors where au_id='"+id+"'");
rset.next();
fullname=rset.getString(1);
rset.close();
stat.close();
conn.close();
return fullname;
}
----------------------------------报的异常-----------------------------------------------
严重: Servlet.service() for servlet jsp threw exception
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)