sky.java

来自「个人办公平台,用JAVA开发的TOMCAT的服务器」· Java 代码 · 共 141 行

package com.icss.control;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.icss.common.ConnectionFactory;
public class Sky extends HttpServlet {
	public void doPost(HttpServletRequest req,HttpServletResponse res){
		
		try {
			req.setCharacterEncoding("GBK");
		} catch (Exception e1) {
			
			e1.printStackTrace();
		}
		System.out.println("++++++333++++++");
	
	String bb=req.getParameter("hidden");
	
	if(bb.equals("hidden1")){
		String aa;	
		Find fi=new Find();
		User user=new User();
		System.out.println("+++++++");
	if(req.getParameter("text1")!=null){		
		String id=req.getParameter("text1");		
		System.out.println("++++++"+id);
		 aa="select * from o_myinfo1 where  empid='"+id+"'";
		 
		user=(User)fi.find(aa);
		 }
    else if(req.getParameter("text2")!=null){
	 String name=req.getParameter("text2");    
	aa="select * from o_myinfo1 where name='"+name+"'";
	user=(User)fi.find(aa);    }    
       req.setAttribute("bb",user);
       try {
		System.out.println("===*****===");
		req.getRequestDispatcher("/view.jsp").forward(req,res);
	} catch (ServletException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (IOException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}				
   }
   else if(bb.equals("update")){
   HttpSession hd=req.getSession();
   String str=(String)hd.getAttribute("yan");
   String empid=(String)hd.getAttribute("wen");
	System.out.println("nih==++=()()()===");
	//String empid=req.getParameter("text1");
	System.out.println(empid);
	String password=req.getParameter("text2");
	System.out.println(password);
	String name=req.getParameter("text3");
	System.out.println(name);
	
	String sex=req.getParameter("sex");
		int u;
	
		if(sex.equals("女")){
			u=1;
		}
		else{u=0;}
		
	
    String position=req.getParameter("text4");
	System.out.println(position);
	int i;
	String  bloodtype=req.getParameter("option1");
	if(bloodtype.equals("A")){
	i=1;
	}else if(bloodtype.equals("B")){
		i=2;
	}else if(bloodtype.equals("AB")){
		i=4;
	}else {i=3;
	}	
	System.out.println(bloodtype);
	String  stature=req.getParameter("text6");
	System.out.println(stature);
	String  weight=req.getParameter("text7");
	System.out.println(weight);
	//String  department=req.getParameter("text8");
	//System.out.println(department);
	String  tel=req.getParameter("text9");
	System.out.println(tel);
	String  motto=req.getParameter("text10");
	System.out.println(motto);
	String  interest=req.getParameter("text11");
	System.out.println(interest);
	String open=req.getParameter("open");
	int x;
	if(open.equals("公开")){
		x=0;
	}
	else {x=1;}
	
String qq="update o_myinfo1 set name='"+name+"', password='"+password+"', sex='"+u+"', position='"+position+"', bloodtype='"+i+"', stature='"+stature+"',  weight='"+weight+"', department='"+str+"' ,tel='"+tel+"', motto='"+motto+"', interest='"+interest+"',open='"+x+"' where empid='"+empid+"'";
      ConnectionFactory co=new ConnectionFactory();
      Connection conn=co.getConnection();
	  Statement st=null;
	  ResultSet rs = null; 	 
      try {	
	    st=conn.createStatement();
		st.executeUpdate(qq);	
		System.out.println("nih==++=====");
		try {
			req.getRequestDispatcher("success.jsp").forward(req,res);
		} catch (ServletException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		} catch (IOException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
      
   }
	}

   
   
	public static void main(String[] args) {
	}
}