package com.py;
import java.io.*;
import javax.servlet.http.*;
public class Java1 extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)
{
try{
res.setContentType("text/html;charset=gbk");
PrintWriter pw=res.getWriter();
String a="1";
if(a=="1")
{
System.out.println("1");
}
else
{
System.out.println("2");
}
pw.println("<html>");
pw.println("<body>");
pw.println("<form action=java2 method=post>");
pw.println("账号:<input type=text name=adm><br/>");
pw.println("密码:<input type=password name=passwd><br/>");
pw.println("<input type=submit value=提交>");
pw.println("</body>");
pw.println("</html>");
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
this.doPost(req,res);
}
}
页面2
package com.py;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;
public class Java2 extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)
{
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
System.out.println("2");
try{
res.setContentType("text/html;charset=gbk");
String a=req.getParameter("adm");
String b=req.getParameter("passwd");
System.out.println(a);
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=py","sa","123");
sm=ct.createStatement();
rs=sm.executeQuery("select top 1'from users where username='"+a+"'and password='"+b+"''");
if(rs.next())
{
HttpSession hs=req.getSession(true);
hs.setAttribute("ses","ok");
System.out.println("2");
res.sendRedirect("java3?zhanghao="+a+"&mima="+b);
}
else
{
System.out.println("3");
res.sendRedirect("java1");
}
System.out.println("4");
}
catch(Exception ex)
{
ex.getStackTrace();
}
finally
{
try
{
if(rs!=null)
{
rs.close();
}
if(sm!=null)
{
sm.close();
}
if(ct!=null)
{
ct.close();
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
this.doPost(req,res);
}
}
页面3
package com.py;
import java.io.*;
import javax.servlet.http.*;
public class Java3 extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)
{
try{
res.setContentType("text/html;charset=gbk");
HttpSession hs=req.getSession(true);
String a=req.getParameter("zhanghao");
String b=req.getParameter("mima");
String c=(String)hs.getAttribute("ses");
PrintWriter pw=res.getWriter();
System.out.println("1");
if(c=="ok")
{
System.out.println("else");
pw.println("<img src=imgs/1.jpg><br/>");
pw.println("欢迎账号:"+a+"密码:"+b+"<br/>");
pw.println("<A href=java1>返回重新登陆</A>");
}
else
{
System.out.println("if");
res.sendRedirect("java1");
}
System.out.println("4");
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
this.doPost(req,res);
}
}
XML部署代码
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns=" http://java.sun.com/xml/ns/j2ee"
xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=" http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_5.xsd"
version="2.5">
<servlet>
<servlet-name>java1</servlet-name>
<servlet-class>com.py.Java1</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>java1</servlet-name>
<url-pattern>/java1</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>java2</servlet-name>
<servlet-class>com.py.Java2</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>java2</servlet-name>
<url-pattern>/java2</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>java3</servlet-name>
<servlet-class>com.py.Java3</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>java3</servlet-name>
<url-pattern>/java3</url-pattern>
</servlet-mapping>
</web-app>
我想访问的事py数据库中的表TABLE1
里面就一个用户 账号admin 密码123
个人觉得要么是页面2,要么就是sql数据库出了问题
后台没关