java.sql.Statement stmt=con.createStatement();
rs.getString("name"));
rs.getString("name"));
解决方案 »
- 该字符串如何正则获取符合的字符串
- log4j 之 DailyRollingFileAppender 问题,为什么不是每天生产新的日志文件呢???
- easyui url是否可以动态加载struts地址获得json数据
- graphics2d 动态画图时,能不能也用MVC模式
- session为何总传空值?
- 40度高温下,我仍要提问,路过的进来凉快一下,代码问题,,,
- java如何解析html文档呢
- 怎样将class文件打包为.jar文件?在调用过程中是否有注意点?在线等待。。。
- context:component-scan 与 context:annotation-config 的问题
- 如何用SERVLET实现,当别人通过我的PROXY的是时候,给对方一个广告的功能
- 我的浏览器不支持applet 请问该岛拿下载插件
- 100分问题:大家来讨论一下TOMCAT4老死机的解决方案!!!!
还有java.sql.Statement stmt=con.createStatement();
为什么要加前缀?不是import java.sql.*了吗?
另外("jdbc:mysql://localhost/book","wangf","liduanduan");里面的user和password,是在mysql数据库user表里面的用户名和密码吗?
rs.getString("name"));实在是想不明白!哈哈user和password 是你登陆数据库的用户名和密码,它是管理数据库的!最高权限为 root !
我用的是MySQL,那个user和password是不是在winmysqladmin里面的那个,
另外这个user和password好象没什么用,我好象不需要输入用户名和密码就可以直接进入winmysqladmin啊,
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/book","wangf","liduanduan");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from book");
while(rs.next()){%>
<%=rs.getSring("name")%>
<%}%>
<% rs.close();
con.close();
%><%}
catch(Exception e){}
%>
调试跟踪一下看看还有什么错?
catch(Exception e){}
%>
改为:
<%}
catch (ClassNotFoundException ex) {
System.out.print("1");
}
catch (SQLException ex) {
System.out.print("2");
}
%>
Error: 500
Location: /wangf/ttj2.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
E:\tomcat\work\localhost_8080%2Fwangf\_0002fttj_00032_0002ejspttj2_jsp_0.java:68: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt=con.createStatement();
^
E:\tomcat\work\localhost_8080%2Fwangf\_0002fttj_00032_0002ejspttj2_jsp_0.java:76: Method getSring(java.lang.String) not found in interface java.sql.ResultSet.
out.print(rs.getSring("name"));
^
2 errors, 1 warning at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247)
at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:536)
Statement stmt=con.createStatement();
^
这行我看懂了,“Ambiguous class:”模糊的类名,
但是下面的个呢?
out.print(rs.getSring("name"));
^
靠!Method getSring(java.lang.String) not found in interface java.sql.ResultSet是getString,不是getSring
Error: 500
Location: /wangf/ttj.jsp
Internal Servlet Error:javax.servlet.ServletException: Unable to load class org.git.mm.mysql.Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)
at _0002fttj_0002ejspttj_jsp_0._jspService(_0002fttj_0002ejspttj_jsp_0.java:92)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:536)Root cause:
java.lang.ClassNotFoundException: Unable to load class org.git.mm.mysql.Driver
at org.apache.jasper.runtime.JspLoader.findClass(JspLoader.java:184)
at org.apache.jasper.runtime.JspLoader.loadClass(JspLoader.java:136)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at _0002fttj_0002ejspttj_jsp_0._jspService(_0002fttj_0002ejspttj_jsp_0.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:536)怎么无法加载驱动,我设置的有问题吗?jdk应该没问题了吧。其他设置有哪些要注意的?
初学jsp,还望指教。
^^^
驱动程序是org.gjt.mm.mysql.Driver
^^^
但是还有个问题就是("jdbc:mysql://localhost/book","wangf","liduanduan");
里的用户名和密码到底是哪里的,我用的是mysql数据库,是表mysql.user里的,还是winmysqladmin里面的,
初学jsp,还望指点。
并没有指定端口号,它怎么连上数据库的?