jsp连接sql server的问题~~~

2004-04-22 10:52:38 515 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

海鸥派OpenEuler开发板实战：从烧写到SSH连接的完整指南本文提供海鸥派OpenEuler开发板从开箱到SSH远程连接的完整实战指南。详细介绍了基于海思SD3403/SS928芯片的算力开发板系统烧写、存储扩容、网络配置等关键步骤，帮助开发者快速上手这款AI边缘计算设备，并实现高效的远程开发与管理。阅读详情

<%@ page contentType="text/html;charset=gb2312"%>
　　<%@ page import="java.sql.*"%>
　　<html>
　　<body>
　　<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
　　String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
　　//pubs为你的数据库的
　　String user="sa";
　　String password="";
　　
　　Connection conn= DriverManager.getConnection(url,user,password);
　　Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
　　String sql="select * from test";
　　ResultSet rs=stmt.executeQuery(sql);
　　while(rs.next()) {%>
　　您的第一个字段内容为：<%=rs.getString(1)%>
　　您的第二个字段内容为：<%=rs.getString(2)%>
　　<%}%>
　　<%out.print("数据库操作成功，恭喜你");%>
　　<%rs.close();
　　stmt.close();
　　conn.close();
　　
　　%>
　　</body>
　　</html>

运行后提示：
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
[javac] Compiling 1 source file

C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:49: illegal character: \12288

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
????String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
^

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:51: illegal character: \12288
????String user="sa";
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:52: illegal character: \12288
????String password="";
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:52: illegal character: \12288
????String password="";
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:53: illegal character: \12288
????
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:53: illegal character: \12288
????
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:54: illegal character: \12288
????Connection conn= DriverManager.getConnection(url,user,password);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:54: illegal character: \12288
????Connection conn= DriverManager.getConnection(url,user,password);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:55: illegal character: \12288
????Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:55: illegal character: \12288
????Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:56: illegal character: \12288
????String sql="select * from test";
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:56: illegal character: \12288
????String sql="select * from test";
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:57: illegal character: \12288
????ResultSet rs=stmt.executeQuery(sql);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:57: illegal character: \12288
????ResultSet rs=stmt.executeQuery(sql);
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:58: illegal character: \12288
????while(rs.next()) {
^

An error occurred at line: 5 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:58: illegal character: \12288
????while(rs.next()) {
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:74: illegal character: \12288
????stmt.close();
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:74: illegal character: \12288
????stmt.close();
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:75: illegal character: \12288
????conn.close();
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:75: illegal character: \12288
????conn.close();
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:76: illegal character: \12288
????
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:76: illegal character: \12288
????
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:77: illegal character: \12288
????
^

An error occurred at line: 20 in the jsp file: /aa.jsp

Generated servlet error:
C:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\aa_jsp.java:77: illegal character: \12288
????
^
28 errors

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

这些错误该怎么解决啊？哪位高手指点一下

...全文

MWORKS 2025a电气模型库实战：手把手教你搭建全桥LLC电路（附避坑指南）本文详细介绍了如何使用MWORKS 2025a电气模型库搭建全桥LLC电路，包括环境准备、电路拓扑构建、参数优化及故障诊断。通过实战案例和避坑指南，帮助电源工程师高效设计谐振转换器，提升转换效率至98%以上。文章特别强调了Modelica模型库在电气系统建模中的关键作用。阅读详情

shuqianlz

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

crazycy 2004-04-28

打赏
举报

????
肯定是因为写字板的格式造成的
而你的sa？？？这个问题你这样来看看行不行：
把数据源配置的混合模式换成 window自带的模式（记不清楚了，好像就是不用输入sa和密码的那个地方）
不行的话，请加我：33682690（QQ）

shuqianlz 2004-04-23

打赏
举报

我按你说的做了，这次提示：
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? 'sa' ?????
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.my_jsp._jspService(my_jsp.java:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? 'sa' ?????
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.my_jsp._jspService(my_jsp.java:52)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

好象是没有找到数据源吧，请问sql server下怎么创建一个数据源呢？
另外，我开始用写字板保存的文件有什么问题吗？

crazycy 2004-04-23

打赏
举报

SORRY：
我以为你用的是ODBC数据源
你是用写字板写成然后保存的吧？
你看这样行不行？

　　<%@ page import="java.sql.*" contentType="text/html;charset=gb2312"%>
　　<html>
　　<body>
　　<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
String user="sa";
String password="555wahaha";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from Employees";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}
%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
　　</html>

crazycy 2004-04-23

打赏
举报

我按你写的做了一次；
如果你配置了ODBC数据源，就能通过了；
请配置好ODBC数据源

shuqianlz 2004-04-23

打赏
举报

用JDBC-ODBC桥可以成功

但用mssql的jdbc驱动老出错，我可以确定连接密码都是对的

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]??? 'Employees' ???
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.my_jsp._jspService(my_jsp.java:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]??? 'Employees' ???
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
org.apache.jsp.my_jsp._jspService(my_jsp.java:55)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Ranmei 2004-04-23

打赏
举报

msbase.jar mssqlserver.jar msutil.jar都放到classpath中(%Tomcat_Home%\common\lib).
第四类jdbc驱动不用odbc

nzy2000 2004-04-23

打赏
举报

有没有搞错，没密码你还能够不报错，你去银行取钱，密码错误人家会给你钱不，你这个帖子是在那我们当猴耍

nzy2000 2004-04-23

打赏
举报

建议你用ODBC试试看看

shuqianlz 2004-04-23

打赏
举报

sql驱动应该都装好，不然回提示出错的
我忘记了sql server的密码，那我在连接它时会不会出错啊？

我用tomcat5

芒果 2004-04-23

打赏
举报

ＳＱＬ的驱动程序是三个文件：分别是 msbase.jar mssqlserver.jar msutil.jar

也不知你用的什么ＷＥＢ服务？？？

芒果 2004-04-23

打赏
举报

这种情况下我想是因为SQL　我驱动程序是不是有点问题呢？

ＱＱ：５０９６４０２４

izdlywn 2004-04-23

打赏
举报

关注中...............

shuqianlz 2004-04-23

打赏
举报

我还是自己顶一下吧

jsp连接sql server的问题~~~

相关推荐