login.java

哀伤的发生的发生的发生的方式打法色的,撒的发生的发生的发生的罚款ijhoiiehoiujkljlkmkjmklj

package login;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class Login extends HttpServlet{
	public void service(HttpServletRequest req,HttpServletResponse res) 
	throws ServletException,IOException{
	 req.setCharacterEncoding("gbk");//保证参数的值为汉字时能够正确显示
	 DataBaseOperation dbo=new DataBaseOperation();
	 res.setContentType("text/html;charset=gbk");
	 PrintWriter out=res.getWriter();
     String reqinfo=req.getParameter("action");
    
     if(reqinfo.equals("login")){
     	String user=req.getParameter("user").trim();
     	String pwd=req.getParameter("pwd");
     	String[] userinfo=dbo.check(user,pwd);
     	if(userinfo==null){
     		out.println("用户名或密码不正确，请重新输入");
     		//req.getRequestDispatcher("index.jsp").include(req,res);
     		out.println("<a href=javascript:history.go(-1)>返回</a>");
     	}
     	else{req.getSession().setAttribute("user1",user);
     		out.println(user+"欢迎你!");
     		res.sendRedirect("list.jsp");
     		//out.println("<a href=login?action=loginout>注销</a>");
     		//out.println("<a href=modiinfo.jsp>修改密码</a>");
     		
     		
     	}
        	
     	
       }
     else  if(reqinfo.equals("register")){
     	 
	     String username=req.getParameter("tx1");
	     if(dbo.check(username)){
	     	out.println("用户名已经存在");
      	    out.println("<a href=javascript:history.go(-1)>返回</a>");
	     	
	     }
	     else{
	     	String userpwd1=req.getParameter("pa2");
	        String userinfo=req.getParameter("ta3");
	   	 
	        String usersex=req.getParameter("ra4");
	     
	        String[] usertaste=req.getParameterValues("ck5");
	        String usertaste1="";
	        if(usertaste!=null){
	     	
	     	for(int i=0;i<usertaste.length;i++)
	     	  usertaste1=usertaste1+usertaste[i]+"  ";
	     
	     }
	     String usercon=req.getParameter("se6");
	     dbo.insert(username,userpwd1,userinfo,usersex,usertaste1,usercon);
	     
	     out.println("注册成功!");
      	out.println("<a href=javascript:history.go(-2)>返回</a>");
       	
	     }
	     
       }
     else if(reqinfo.equals("loginout")){
     	req.getSession().invalidate();
     	
     	  
     	//req.getRequestDispatcher("index.jsp").forward(req,res);
     	res.sendRedirect("index.jsp");
     
     }
      else if(reqinfo.equals("modifyinfo")){
      	String username=req.getParameter("username");
      	String pwd=req.getParameter("pa2");
      	dbo.update(username,pwd);
      	out.println("密码修改成功!");
      	out.println("<a href=javascript:history.go(-2)>返回</a>");
      }
       
    dbo.clo();
      
      
		
		
	}
}

class DataBaseOperation{
	Connection  con;
    Statement st;
    DataBaseOperation()
    {try
     {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String str="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DbQ=d:/university.mdb ";
      con=DriverManager.getConnection(str);
      st=con.createStatement(1004,1008);
     }catch(Exception e){System.out.println(e.toString());}
    }
 
 
 boolean check(String user){
 	try
  { String sql="select * from userinfo where username='"+user+"'";
    
  	ResultSet rs=st.executeQuery(sql);
  	if(rs.next())
  	  return  true;
    else
      return false;
  		 		
  	
    
  }catch(Exception e){System.out.println(e.toString());return false;}
 	
 }
 
 
 String[] check(String user,String pwd) 
 { try
  { String sql="select * from userinfo where username='"+user;
    sql+="' and userpwd='"+pwd+"'";
  	ResultSet rs=st.executeQuery(sql);
  	if(rs.next()){
  		int columncount=rs.getMetaData().getColumnCount();//获得列数
        String[] s=new String[columncount];
        for(int j=0;j<columncount;j++)
          s[j]=rs.getString(j+1);
        return s;
  	}
  	else{rs.close();
         return null;
  		 		
  	}
    
  }catch(Exception e){System.out.println(e.toString());return null;}
 }
 
  
 void insert(String user,String pwd,String intro,String sex,String favour,String cons) 
 {try
  {String sql="insert into userinfo values ('"+user+"','";
   sql+=pwd+"','";
   sql+=intro+"','";
   sql+=sex+"','";
   sql+=favour+"','";
   sql+=cons+"')";
   st.executeUpdate(sql);
 }catch(Exception e){System.out.println(e.toString());}
  
 }
 /*void update(String user,String pwd,String intro,String sex,String favour,String cons) 
 {try
  {String sql="update userinfo set userpwd='"+pwd+"',";
   sql+="intro='"+intro+"',";
   sql+="sex='"+sex+"',";
   sql+="favour='"+favour+"',";
   sql+="cons='"+cons+"' where username='";
   sql+=user+"'";
   st.executeUpdate(sql);
  }catch(Exception e){System.out.println(e.toString());}
  
 }*/
 
  void update(String user,String pwd) 
 {try
  {String sql="update userinfo set userpwd='"+pwd+"'";
   sql+="  where username='";
   sql+=user+"'";
   st.executeUpdate(sql);
  }catch(Exception e){System.out.println(e.toString());}
  
 }
 /*void del(String sql) 
 {try
  {
   st.executeUpdate(sql);
  }catch(Exception e){System.out.println(e.toString());}
 
 }*/
 void clo() 
 { try
   {st.close();
    con.close();
   }catch(Exception e){System.out.println(e.toString());}
 }
 
}