问题描述
javabean代码：packagecom.am;importjava.sql.*;publicclassOpenDB{StringuserName="root";StringuserPassword="jingxian";Stringdatabase="am";Stringhost="localhost";//privateStringdriverName="org.gjt.mm.mysql.Driver";//privateStringurl="jdbc:mysql://localhost/am?useUnicode=true&characterEncoding=gb2312";ConnectiondbConn;publicOpenDB(){}publicConnectiongetConnection(){try{Class.forName("org.gjt.mm.mysql.Driver").newInstance();dbConn=DriverManager.getConnection("jdbc:mysql://"+host+"/"+database,userName,userPassword);}catch(Exceptionex){System.out.println(ex.toString());dbConn=null;}returndbConn;}}jsp页面代码：<%@pagelanguage="java"contentType="text/html;charset=gb2312"%><%@pageimport="java.sql.*"%><%@pageimport="com.am.*"%><%@pageimport="org.gjt.mm.mysql.Driver"%><jsp:useBeanid="dbconn"scope="application"class="com.am.OpenDB"/><html><head><title>刊物文章管理系统</title><metahttp-equiv="Content-Type"content="text/html;charset=gb2312"><scriptlanguage=javascript><!--functioncheckform(){if(FORM1.txtusername.value==""){alert("请填写用户名.");FORM1.txtusername.focus();returnfalse;}if(FORM1.txtuserPassword.value==""){alert("请填写密码.");FORM1.txtuserPassword.focus();returnfalse;}if(FORM1.txtuserPassword1.value==""){alert("请填写确认密码.");FORM1.txtuserPassword1.focus();returnfalse;}if(FORM1.txtuserPassword.value!=FORM1.txtuserPassword1.value){alert("两次密码不一致.");FORM1.txtuserPassword.focus();returnfalse;}str1=FORM1.txtemail.value;key=str1.match(/@/);if(key==null){alert("Email填写错误.");FORM1.txtemail.focus();returnfalse;}varUnCheck=true;for(i=0;i<document.FORM1.myfields.length;i++){if(document.FORM1.myfields[i].checked){UnCheck=false;break;}}if(UnCheck){alert("请选择研究主题.");document.FORM1.myfields[0].focus();returnfalse;}returntrue;}//--></script></head><body><divalign=center><formaction=userRegisterSave.jspmethod=postname=FORM1onsubmit="checkform()"><tablewidth="60%"border="0"cellpadding="0"cellspacing="0"><trvalign="middle"><tdcolspan="3"align="center"><br><p><strong><fontcolor="#000099"size=6>公司刊物文章管理系统</font></strong></p></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>用户名：</font></td><td><inputtype="text"name="txtusername"size="30"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>密码:</font></td><td><inputsize=30name="txtuserPassword"type="password"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>确认密码：</font></td><td><inputsize=30name="txtuserPassword1"type="password"><fontcolor="red">*</font></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>姓名：</font></td><td><inputsize=30name="txtname"type="text"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>所在公司：</font></td><td><inputsize=30name="txtcompany"type="text"></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>所属部门：</font></td><td><inputsize=30name="txtdepart"type="text"></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>Email：</font></td><td><inputtype=textsize=30name="txtemail"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>研究主题：</font></td><td><%StringstrSqlworkgroups="";Statementstmtworkgroups=dbConn.getConnection().createStatement();strSqlworkgroups="select*fromworkgroupwheretag=0orderbyid";ResultSetrsworkgroups=stmtworkgroups.executeQuery(strSqlworkgroups);while(rsworkgroups.next()){%><inputtype="checkbox"name="txtmyfields"value=<%=rsworkgroups.getLong("ID")%>><%=rsworkgroups.getString("note")+''+rsworkgroups.getString("fieldName")%><br><%}stmtworkgroups.close();rsworkgroups.close();%></td></tr><tr><tdcolspan="2"><fontsize="3"color="#0000FF"><center>带<fontcolor="red">*</font>为必填项</center></font></td></tr><tr><tdalign=centercolspan=2><inputtype=submitvalue="提交"name="btnSubmit"> <inputtype=resetvalue="重填"name="btnReset"></td></tr></table></form></div></body></html>处错误的信息：HTTPStatus500---------------------------------------------------------------------------------typeExceptionreportmessagedescriptionTheserverencounteredaninternalerror()thatpreventeditfromfulfillingthisrequest.exceptionorg.apache.jasper.JasperException:UnabletocompileclassforJSP:Anerroroccurredatline:141inthejspfile:/userRegister.jspdbConncannotberesolved138:<td>139:<%140:StringstrSqlworkgroups="";141:Statementstmtworkgroups=dbConn.getConnection().createStatement();142:strSqlworkgroups="select*fromworkgroupwheretag=0orderbyid";143:ResultSetrsworkgroups=stmtworkgroups.executeQuery(strSqlworkgroups);144:while(rsworkgroups.next())Stacktrace:org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93)org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)noteThefullstacktraceoftherootcauseisavailableintheApacheTomcat/5.5.27logs.--------------------------------------------------------------------------------ApacheTomcat/5.5.27
解决方案
解决方案二：
dbconn给为dbConn
解决方案三：
<%@pagelanguage="java"contentType="text/html;charset=gb2312"%><%@pageimport="java.sql.*"%><%@pageimport="com.am.*"%><%@pageimport="org.gjt.mm.mysql.Driver"%><jsp:useBeanid="dbconn"scope="application"class="com.am.OpenDB"/><html><head><title>刊物文章管理系统</title><metahttp-equiv="Content-Type"content="text/html;charset=gb2312"><scriptlanguage=javascript><!--functioncheckform(){if(FORM1.txtusername.value==""){alert("请填写用户名.");FORM1.txtusername.focus();returnfalse;}if(FORM1.txtuserPassword.value==""){alert("请填写密码.");FORM1.txtuserPassword.focus();returnfalse;}if(FORM1.txtuserPassword1.value==""){alert("请填写确认密码.");FORM1.txtuserPassword1.focus();returnfalse;}if(FORM1.txtuserPassword.value!=FORM1.txtuserPassword1.value){alert("两次密码不一致.");FORM1.txtuserPassword.focus();returnfalse;}str1=FORM1.txtemail.value;key=str1.match(/@/);if(key==null){alert("Email填写错误.");FORM1.txtemail.focus();returnfalse;}varUnCheck=true;for(i=0;i<document.FORM1.myfields.length;i++){if(document.FORM1.myfields[i].checked){UnCheck=false;break;}}if(UnCheck){alert("请选择研究主题.");document.FORM1.myfields[0].focus();returnfalse;}returntrue;}//--></script></head><body><divalign=center><formaction=userRegisterSave.jspmethod=postname=FORM1onsubmit="checkform()"><tablewidth="60%"border="0"cellpadding="0"cellspacing="0"><trvalign="middle"><tdcolspan="3"align="center"><br><p><strong><fontcolor="#000099"size=6>公司刊物文章管理系统</font></strong></p></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>用户名：</font></td><td><inputtype="text"name="txtusername"size="30"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>密码:</font></td><td><inputsize=30name="txtuserPassword"type="password"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>确认密码：</font></td><td><inputsize=30name="txtuserPassword1"type="password"><fontcolor="red">*</font></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>姓名：</font></td><td><inputsize=30name="txtname"type="text"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>所在公司：</font></td><td><inputsize=30name="txtcompany"type="text"></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>所属部门：</font></td><td><inputsize=30name="txtdepart"type="text"></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>Email：</font></td><td><inputtype=textsize=30name="txtemail"><fontcolor="red">*</font></td></tr><tr><tdwidth=50%align=rightbgcolor="#DFDFDF"><fontface=Arial,Helveticacolor=navysize=3>研究主题：</font></td><td><%StringstrSqlworkgroups="";Statementstmtworkgroups=dbConn.getConnection().createStatement();strSqlworkgroups="select*fromworkgroupwheretag=0orderbyid";ResultSetrsworkgroups=stmtworkgroups.executeQuery(strSqlworkgroups);while(rsworkgroups.next()){%><inputtype="checkbox"name="txtmyfields"value=<%=rsworkgroups.getLong("ID")%>><%=rsworkgroups.getString("note")+''+rsworkgroups.getString("fieldName")%><br><%}stmtworkgroups.close();rsworkgroups.close();%></td></tr><tr><tdcolspan="2"><fontsize="3"color="#0000FF"><center>带<fontcolor="red">*</font>为必填项</center></font></td></tr><tr><tdalign=centercolspan=2><inputtype=submitvalue="提交"name="btnSubmit"> <inputtype=resetvalue="重填"name="btnReset"></td></tr></table></form></div></body></html>
解决方案四：
这样贴代码更好看，别人好看
解决方案五：
<jsp:useBeanid="dbconn".../>//定义bean名为dbconn<%...dbConn...%>//使用却为dbConn?!还有Connection不要作为全局变量