show.java

购物车 购物车 购物车 购物车 购物车

package coreservlets;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Show extends HttpServlet {
	
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
		try{
		
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");// .microsoft.jdbc.sqlServer.SQLServerDriver");
		Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","");
		Statement st=conn.createStatement();
		st.setMaxRows(20);
		
		String user,address,pas;
		String info;//显示登陆页面的错误信息
		
		address="";
		user = request.getParameter("username");
		pas = request.getParameter("password");
	
		
		if((user==null)||(pas==null)||(user.trim().equals(""))||(pas.trim().equals("")))
		{
		address="/index.jsp";
		info="用户名或密码不能为空";
		request.setAttribute("wronginfo",info);
		}
		else
		{
		String sqlStr = "select * from customer";
		ResultSet rs=st.executeQuery(sqlStr);
		while(rs.next())
		{
			
				if(rs.getString("username").trim().equals(user)&&rs.getString("password").trim().equals(pas))
			{
			User userbean = new User(user,pas);
			request.setAttribute("userbean",userbean);
			HttpSession session = request.getSession();
			String sessionname;
			session.setAttribute("sessionname",user);	
			address="/welcome.jsp";
			break;
			}
		else address="/index.jsp";
	  	}
	  		 rs.close();
	  	}
	   st.close();    
	   conn.close();
	   	RequestDispatcher dispatcher = request.getRequestDispatcher(address);
		dispatcher.forward(request,response);
	    
	}catch(SQLException sqle){
		sqle.printStackTrace();
	}
	catch(Exception ex){
		ex.printStackTrace();
	}
}
}