JSP中数据库连接问题

来源:百度知道 编辑:UC知道 时间:2024/06/07 04:16:14
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /chuli.jsp:17

14: <%
15: String sql1="select * from user1 where username='"+person.getName()+"'";
16: ResultSet rs=db.executeQuery(sql1);
17: if(rs.next())
18: {out.print("对不起,该用户名被别人注册过,请重新注册!三秒后跳到注册页面");
19: response.setHeader("Refresh","3;URL=zhuce.jsp");
20: }else{

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.Ht

public class DataBaseConnection
{

public static Connection getConnection()
{
Connection con=null;
String CLASSFORNAME="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/student";
String user="root";
String password="";

try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(url,user,password);

}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
}

如果你有用的是tomcat请到
\\Tomcat5\work\Catalina\localhost\网站文件夹\org\apache\jsp\chuli_jsp.java

差不多是这样的路径了,
java.lang.NullPointerException
org.apache.jsp.chuli_jsp._jspService(chuli_jsp.java:79)

79行,参数传递可能有问题

华夏博大是在深圳,那儿的IT产业本来就发展的早,对于找工作来说是很有优势的。他们Java的教学质量很好 你符合条件的话还可以先就业后付款,加油吧!