运行时直接跳到 catch(Exception e)里的 数据库连接错误 <%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page session="true"%>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("GB2312");%>
<html> <body bgcolor="#ccccff">
<%
ResultSet rs=null;
String strSql=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到!");
}
try{
Connection conn=DriverManager.getConnection("jdbc:odbc:testlzw", "system", "lzw123"); Statement stmt=conn.createStatement();
String s_username=request.getParameter("username");
strSql="select * from userTable where user_name="+"'"+s_username+"'";
rs=stmt.executeQuery(strSql);
if(rs.next()){
%>
<h2>对不起,你注册的账号已经存在</h2></centre><br><br>
<center><a href="Regist.jsp""Regist.jsp\">重新注册</a><br><br><a href="index.jsp">进入登录页面</a><br></center><br>
<%
}else{
String s_password=request.getParameter("password");
String s_email=request.getParameter("email");
String s_sex=request.getParameter("sex");
String s_age=request.getParameter("age");
strSql = "insert into userTable (user_name,user_password,user_sex,user_email,user_age) values('"+s_username+"','"+s_password+"','"+s_sex+"','"+s_email+"','"+s_age+"')";
int temp = stmt.executeUpdate(strSql);
if(temp>0){
%>
<center><h2 color=red>恭喜你注册成功!</h2></center><br><br>
<center><a href="index.jsp""index.jsp\"> 进入登录页面 </a></center>
<%
}else {
%>
<center><h2 color=red>对不起,注册失败!</h2></center><br><br>
<center><a href="Regist.jsp""Regist.jsp\">返回</a></center>
<%
}
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
%>
<h2 align=center>数据库连接错误</h2>
<%
}
%> </body>
</html>
<%@ page session="true"%>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("GB2312");%>
<html> <body bgcolor="#ccccff">
<%
ResultSet rs=null;
String strSql=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到!");
}
try{
Connection conn=DriverManager.getConnection("jdbc:odbc:testlzw", "system", "lzw123"); Statement stmt=conn.createStatement();
String s_username=request.getParameter("username");
strSql="select * from userTable where user_name="+"'"+s_username+"'";
rs=stmt.executeQuery(strSql);
if(rs.next()){
%>
<h2>对不起,你注册的账号已经存在</h2></centre><br><br>
<center><a href="Regist.jsp""Regist.jsp\">重新注册</a><br><br><a href="index.jsp">进入登录页面</a><br></center><br>
<%
}else{
String s_password=request.getParameter("password");
String s_email=request.getParameter("email");
String s_sex=request.getParameter("sex");
String s_age=request.getParameter("age");
strSql = "insert into userTable (user_name,user_password,user_sex,user_email,user_age) values('"+s_username+"','"+s_password+"','"+s_sex+"','"+s_email+"','"+s_age+"')";
int temp = stmt.executeUpdate(strSql);
if(temp>0){
%>
<center><h2 color=red>恭喜你注册成功!</h2></center><br><br>
<center><a href="index.jsp""index.jsp\"> 进入登录页面 </a></center>
<%
}else {
%>
<center><h2 color=red>对不起,注册失败!</h2></center><br><br>
<center><a href="Regist.jsp""Regist.jsp\">返回</a></center>
<%
}
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
%>
<h2 align=center>数据库连接错误</h2>
<%
}
%> </body>
</html>
解决方案 »
- hibernary 一个新手问题
- struts2中属性驱动和模型驱动
- Tomcat无法启动
- 权限管理! 小弟就这么多分了。
- [有效性验证]STRUTS可否直接用JS文件而不用validator
- java如何将html转化成xml
- Spring MVC 拦截器,打死不跳转
- Struts中标签的value问题!
- 我想看到所有的具体的异常都有哪些,应该怎么看,比如:Primary Key Dulpicate Exception...,我在看java的API时,只能看到那几大类异常,
- jsp 调用ejb
- win7下 ip和域名在hosts下绑定不生效问题。。。
- myeclipse9 怎么新建一个 tomcat 工程
异常范围太大了, 把控制台的异常信息贴出来
if(conn==null){
%>
<h2 align=center>conn是空的</h2>
<%
}
Statement stmt=conn.createStatement();
%>
<h2 align=center>如果没有输出我,就是上一句出异常拉</h2>
<%
if(conn==null){
%>
<h2 align=center>conn是空的</h2>
<%
}
Statement stmt=conn.createStatement();