51,408
社区成员
发帖
与我相关
我的任务
分享關鍵字 'user' 附近的語法不正確。 求助
CallableStatement proc =con.prepareCall("{call Pro_Product (user,Style)}");
报错 關鍵字 'user' 附近的語法不正確。 什么原因啊
报错 關鍵字 'user' 附近的語法不正確。 什么原因啊
...全文
请发表友善的回复…
发表回复
haryjiang19 2011-08-25
- 打赏
- 举报
<%@ 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>
直接显示空白页。。连网页标题都没有
<%@ 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>
直接显示空白页。。连网页标题都没有
qybao 2011-08-25
- 打赏
- 举报
从你的程序来看，user是存储过程的参数，如果是对象，那么就按1L的代码处理，如果是字符串，那么要加上单引号，即
CallableStatement proc =con.prepareCall("{call Pro_Product ('user','Style')}");
注意参数的区别
CallableStatement proc =con.prepareCall("{call Pro_Product ('user','Style')}");
注意参数的区别
haryjiang19 2011-08-25
- 打赏
- 举报
八月 25, 2011 11:31:05 上午 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)
还是这个程序报了这个错误。。什么原因啊
gmogle 2011-08-25
- 打赏
- 举报
USER 加上[] 中括号
淡定的峰哥 2011-08-25
- 打赏
- 举报
CallableStatement proc =conn.prepareCall("{call Pro_Product (?,?)}");
proc.setString(1,user);
proc.setString(2,Style);
proc.execute();
