关于MYSQL与JSP 连接问题
/*
* Bean.java
*
* Created on 2004年10月25日, 下午10:11
*/
package liuyp;
import java.sql.*;
public class guozhw
{
Connection conn = null;
java.sql.Statement stmt = null;
ResultSet rs = null;
//String url;
String url="jdbc:mysql://eauking:1031/test?user=liuyp&password=123";
public static void main(String arg[]){
System.out.println("ok!");
}
public guozhw()
{
try {
Class.forName ("org.gjt.mm.mysql.Driver");
System.out.println("ok!");
}
catch (java.lang.ClassNotFoundException e) {
System.err.println("elib():"+e.getMessage());
}
}
public ResultSet select(String sql){
try{
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
}
[
------
回复此文章
<%@ page contentType="text/html;charset = gb2312"%>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.lang.*" %>
<jsp:useBean id = "conn" scope = "page" class="liuyp.guozhw"/>
<html>
<head><title>JSP Page</title></head>
<body>
<%
String name1;
String sql;
ResultSet rs = null;
boolean go;
sql = "select * from xiao";
rs=conn.select(sql);
while (rs.next()) {
out.println(rs.getString(1));
}
%>
</body>
</html>
------
回复此文章
但是不知道为什么他还是有错误！
驱动位置是正确放置的！
------
回复此文章 |
怎么不把错误提示贴出来呢！？
------
回复此文章 |
Class.forName ("org.gjt.mm.mysql.Driver");
这个驱动好古老呀，你不会是用这个版本的吧。
这是2.x版的，现在地球人都用3.x版的。
------
回复此文章 |
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:305)
root cause
java.lang.NullPointerException
org.apache.jsp.Java.guozhw.select_jsp._jspService(select_jsp.java:66)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:305)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.19
------
回复此文章 |
找本书自己抄一个不就得了
要不到网上找一下
一个问题僵持在这对后面的学习很不利的
开始我都没看明白你写的是什么 哥们太高深了吧
后来在余老师借给我的那书上看到才知道是怎么回事
* Bean.java
*
* Created on 2004年10月25日, 下午10:11
*/
package liuyp;
import java.sql.*;
public class guozhw
{
Connection conn = null;
java.sql.Statement stmt = null;
ResultSet rs = null;
//String url;
String url="jdbc:mysql://eauking:1031/test?user=liuyp&password=123";
public static void main(String arg[]){
System.out.println("ok!");
}
public guozhw()
{
try {
Class.forName ("org.gjt.mm.mysql.Driver");
System.out.println("ok!");
}
catch (java.lang.ClassNotFoundException e) {
System.err.println("elib():"+e.getMessage());
}
}
public ResultSet select(String sql){
try{
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
}
[
------
回复此文章
<%@ page contentType="text/html;charset = gb2312"%>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.lang.*" %>
<jsp:useBean id = "conn" scope = "page" class="liuyp.guozhw"/>
<html>
<head><title>JSP Page</title></head>
<body>
<%
String name1;
String sql;
ResultSet rs = null;
boolean go;
sql = "select * from xiao";
rs=conn.select(sql);
while (rs.next()) {
out.println(rs.getString(1));
}
%>
</body>
</html>
------
回复此文章
但是不知道为什么他还是有错误！
驱动位置是正确放置的！
------
回复此文章 |
怎么不把错误提示贴出来呢！？
------
回复此文章 |
Class.forName ("org.gjt.mm.mysql.Driver");
这个驱动好古老呀，你不会是用这个版本的吧。
这是2.x版的，现在地球人都用3.x版的。
------
回复此文章 |
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:305)
root cause
java.lang.NullPointerException
org.apache.jsp.Java.guozhw.select_jsp._jspService(select_jsp.java:66)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:305)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.19
------
回复此文章 |
找本书自己抄一个不就得了
要不到网上找一下
一个问题僵持在这对后面的学习很不利的
开始我都没看明白你写的是什么 哥们太高深了吧
后来在余老师借给我的那书上看到才知道是怎么回事
hofman
2005-11-19 22:58:23
评论:0
阅读:472
引用:0