<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<html>
<title>插入</title>
<body>
<%
request.setCharacterEncoding("GBK");
String uname = request.getParameter("uname").trim();
//out.println(uname);
String pwd = request.getParameter("pwd").trim();
%>
<%
Connection con;
Statement stmt;
ResultSet rs;
String sql;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.println("找不到这个类!");
}
try
{
// sql = "select (sno,pwd) from s where (?,?) ";
// sql = "insert into s (sno,class,sname,sex,birthday,address,telephone,email) values (?,?,?,?,?,?,?,?)";
// sql = "insert into s1 (sno,sname,sex) values(?,?,?)";
// sql ="insert into s (sno,class,sname,sex,birthday,address,telephone,email) values('"+sno+"','"+cla+"','"+name+"','"+sex+"','"+ads+"','"+birth+"','"+tel+"','"+email+"')";
sql = "select * from s ";
con = DriverManager.getConnection("jdbc:microsoft:sqlServer://127.0.0.1:1433;DatabaseName=student2","sa","bertram");
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
// rs.getString(3);
// out.println(rs.getString(3));
// rs.getString(9);
// out.println(rs.getString(9));
if(uname.equals((rs.getString(3)).trim())&&pwd.equals((rs.getString(9)).trim()))
{
session.setAttribute("uname",uname);
response.sendRedirect("success.jsp");
}
else
{
response.sendRedirect("fail.jsp");//为什么这个语句会抛出异常啊!不知道为什么啊!现在所有连接数据库的用这个跳转都要抛出!哪位高人知道为啥啊!感谢指出!
}
}
%>
<%
stmt.close();
con.close();
}
catch(SQLException e)
{
out.println(e+"数据库操作异常!");
}
%>
</body>
</html>
异常错误提醒:
org.apache.jasper.JasperException: An exception occurred processing JSP page /conf.jsp at line 5350: }
51: else
52: {
53: response.sendRedirect("fail.jsp");
54: }
55: }
56:
<%@ page import="java.sql.*" %>
<html>
<title>插入</title>
<body>
<%
request.setCharacterEncoding("GBK");
String uname = request.getParameter("uname").trim();
//out.println(uname);
String pwd = request.getParameter("pwd").trim();
%>
<%
Connection con;
Statement stmt;
ResultSet rs;
String sql;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.println("找不到这个类!");
}
try
{
// sql = "select (sno,pwd) from s where (?,?) ";
// sql = "insert into s (sno,class,sname,sex,birthday,address,telephone,email) values (?,?,?,?,?,?,?,?)";
// sql = "insert into s1 (sno,sname,sex) values(?,?,?)";
// sql ="insert into s (sno,class,sname,sex,birthday,address,telephone,email) values('"+sno+"','"+cla+"','"+name+"','"+sex+"','"+ads+"','"+birth+"','"+tel+"','"+email+"')";
sql = "select * from s ";
con = DriverManager.getConnection("jdbc:microsoft:sqlServer://127.0.0.1:1433;DatabaseName=student2","sa","bertram");
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
// rs.getString(3);
// out.println(rs.getString(3));
// rs.getString(9);
// out.println(rs.getString(9));
if(uname.equals((rs.getString(3)).trim())&&pwd.equals((rs.getString(9)).trim()))
{
session.setAttribute("uname",uname);
response.sendRedirect("success.jsp");
}
else
{
response.sendRedirect("fail.jsp");//为什么这个语句会抛出异常啊!不知道为什么啊!现在所有连接数据库的用这个跳转都要抛出!哪位高人知道为啥啊!感谢指出!
}
}
%>
<%
stmt.close();
con.close();
}
catch(SQLException e)
{
out.println(e+"数据库操作异常!");
}
%>
</body>
</html>
异常错误提醒:
org.apache.jasper.JasperException: An exception occurred processing JSP page /conf.jsp at line 5350: }
51: else
52: {
53: response.sendRedirect("fail.jsp");
54: }
55: }
56:
2:换成request形式试试
前面不允许有任何html内容输出,而你的不是
2个方法
1 加上 out.clearBuffer();看看运气
2 改用js进行转向
{
out.println(e+"数据库操作异常!");
}
中的out.println(e+"数据库操作异常!"); 改为e.printStackTrace();
这样异常信息会详细一点
{
e.printStackTrace();
}