jsp连接sql server的问题~~~

shuqianlz 2004-04-22 10:52:38
<%@ 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)




这些错误该怎么解决啊？哪位高手指点一下
...全文
461 13 打赏 收藏 转发到动态 举报
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
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
  • 打赏
  • 举报
 回复
我还是自己顶一下吧
JSP2.0技术手册pdf(带示例源码).zip
JSP 2.0，重点介绍Java在展示层的两项重要技术：Java Servlet与JavaServer Pages。 它们是最重要的 Java 核心技术。对这两项技术的深入了解，将有助于您未来对于 JavaServer Faces(JSF)技术以及Java Web Services...
基于JAVA的网上订票系统源码(J2EE)
sql server 2000 数据库文件在WebRoot的DB文件中！ 本系统实现了会员注册，会员登录，密码修改，以及会员信息的修改！ 初步实现了在线订购，订单查询，班次查询以及系统管理--对火车信息的添加等。 操作过程...
JSP&Servlet应用开发-标签使用篇
学习之前需要具备一定的Java编程基础~ 本课程的主要内容是EL表达式和JSTL标签库的使用~ EL表达式应用起来更简洁、更高效~ JSTL标签库包括核心库、函数库、格式化库和sql库~ 二者综合应用能够代替JSP页面中的Java脚本...
jsp连接SqlServer中文乱码问题
jsp连接SqlServer中文乱码问题 初学jsp与SqlServer连接，在完成一系列的连接数据库操作后，成功的存入数据 结果在输入中文时出现了乱码（如下图所示） 下面是我解决的过程： 1.首先，jsp开头加入 charset=gb2312 ...
如何在jsp中连接SQLserver数据库
如何在jsp中连接SQLserver数据库 1、加载jdbc驱动程序 2、创建连接对象connection的实例对象，这里的url就是SqlServer在电脑中地址，一般都是jdbc:sqlserver://localhost:1433（端口要和自己电脑上的一致），至于...
Web 开发

81,092

社区成员

341,716

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章