📄 modif_trans_log.java

📁 以Servlet以及JDBC实现的网站实例
💻 JAVA
字号:

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



public class trans_log extends HttpServlet {
    
    
    ResourceBundle rb = ResourceBundle.getBundle("LocalStrings");
    
    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException  
    {
        response.setContentType("text/html");
	
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<body background=\"file:/home/xu/servlet/jsdk2.1/examples/images/bg3.gif\">");
        out.println("<head>");
        out.println("</head>");
        out.println("<body bgcolor=\"white\">");
	
        String title = rb.getString("requestparams.title");
        
        
        String[] choix=new String[6];
		int i;

		for(i=0;i<6;i++)
	    	choix[i]=request.getParameter("C"+i);
	    		
        
        String num = request.getParameter("num");
      	
        String depart = request.getParameter("depart");
	
		String dest  = request.getParameter("dest");
	
		String jour  = request.getParameter("jour");
		String mois = request.getParameter("mois");
		String annee = request.getParameter("annee");
	
		String type = request.getParameter("type_trans");
		String duree = request.getParameter("duree");
	
		String description= request.getParameter("descri");	
	
		String I_V = request.getParameter("I_V");
	
		String num_aff,depart_aff,dest_aff,jour_aff,mois_aff,annee_aff,type_aff,duree_aff,description_aff;		
	
		String sqlString_aff = "select * from trans_log";
		
		
		String[] VAR=new String[6];
		VAR[0]=" depart='"+depart+"'";
		VAR[1]=" dest='"+dest+"'";
		VAR[2]=" jour='"+jour+"', mois='"+mois+"', annee='"+annee+"'";
		VAR[3]=" type_trans='"+type_trans+"'";
		VAR[4]=" duree='"+duree+"'";
		VAR[5]=" description='"+descri+"'";
		
		
		int h=0;
		String	SQLrequete="UPDATE EVENEMENT SET " ;
		for(i=0;i<=3;i++)
	    	{if(choix[i]!=null)
				if(h==0)
				{
		    		SQLrequete=SQLrequete+VAR[i] ;
		    		h++;
				}
				else
		    	SQLrequete=SQLrequete+","+VAR[i] ;
	    	}
		SQLrequete=SQLrequete+" WHERE num="+num;
	
		Statement smtp=null;
	
		Connection con=null ;
		try{
	    		Class.forName("oracle.jdbc.driver.OracleDriver");
	    		con=DriverManager.getConnection("jdbc:oracle:thin:@capucine:1521:ens","lic329","oracle");
	       }
		catch(Exception e)
	    {
			System.err.println(e);
	    }
	     
		try{
	    		smtp=con.createStatement();
	    		smtp.executeUpdate(SQLrequete ); 
  	   	   }
  		catch(Exception e) 
  		{
			System.err.println(e);
	    }
       	
	    out.println("<p><h1>La Modification est fait</h1></p><br><br><br>");
	
		try{
			ResultSet rs = smtp.executeQuery(sqlString_aff);
				
			while (rs.next())
			{
				num_aff = rs.getString(1);
				depart_aff = rs.getString(2);
				dest_aff = rs.getString(3);
				jour_aff = rs.getString(4);
				mois_aff = rs.getString(5);
				annee_aff = rs.getString(6);
				type_aff = rs.getString(7);
				duree_aff = rs.getString(8);
				description_aff = rs.getString(9);
			
				out.println("Numero de moyen        : " +num_aff+"<br>");
				out.println("Au Départ de          : " +depart_aff+"<br>");
				out.println("A Destination de       : "+dest_aff+"<br>");
			  	out.println("Date                   : "+jour_aff+"/"+mois_aff+"/"+annee_aff+"<br>");
				out.println("Type de transport      : "+type_aff+"<br>");
				out.println("Durée                 : " +duree+" heures<br>");
			 	out.println("Descrption de Logement : <br>");
				out.println(description_aff+"<br><br>");
			}
		}
		catch(SQLException e)
		{      
			System.err.println(e);
		}
		
				         		            
				            
		out.println("<p><h2>Vous voulez <a href=\"http://localhost:8080/examples/servlets/"+
				    "trans_log_modif.html\">continuer</a>  ou <a href=\"http://localhost:8080/examples/servlets/"+
				    "trans_log_root.html\">faire une autre operation</a>  ou <a href=\"http://localhost:8080"+
					"/examples/servlets/trans_log.html\">s'arrêter</a> ?");
			}					
		}
				
	}	
	
	out.println("</body>");
	out.println("</html>");				
		
    }
    
 


        
    public void doPost(HttpServletRequest request,
		       HttpServletResponse response)
	throws IOException, ServletException
    {
	doGet(request, response);	
    }
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -