怪事。。帮看看什么问题

haryjiang19 2011-08-25 12:51:03

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>

<html>
<head>
<title>Proxool-test.jsp</title>
</head>
<body>
<table><tr><td>ddddddddddddd</tr></td></table>
<h2>使用 Proxool Connection Pool</h2>

<%
Connection con = null;
Statement stmt = null;
//ResultSet rs = null;
String St = "";

try
{
con = DriverManager.getConnection("proxool.net");

CallableStatement proc =con.prepareCall("{call Pro_ProductFirstRawMtlTypeList (?,?)}");
proc.setString(1, "11");
proc.setString(2, "Str=79");
ResultSet rs=proc.executeQuery();

while(rs.next()) {
St = rs.getString("name");

%>
姓名为：<%= St %><br>

<%
}

stmt.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}

%>

</body>
</html>
直接显示空白页。。连网页标题都没有

...全文

93 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

liangzaizjl 2011-09-16

打赏
举报

驱动没有啊、、、、

双月友 2011-09-16

打赏
举报

驱动包没有放好吧！把驱动包放在项目的Lib文件夹下，驱动包就是数据库驱动包.....

softroad 2011-09-16

打赏
举报

没看见
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

wei1kai2 2011-08-26

打赏
举报

1楼不是让你抓包了吗

haryjiang19 2011-08-25

打赏
举报

八月 25, 2011 12:59:57 下午 org.logicalcobwebs.proxool.Prototyper sweep
严重: Prototype
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)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)