⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 eve_modif2.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>");
            
        String[] choix=new String[3];
		int i;

		for(i=0;i<3;i++)
	    	choix[i]=request.getParameter("C"+i);
	    	
	    	
	    String nom=request.getParameter("nom");	
		String adresse  = request.getParameter("adresse");
	
		String jour  = request.getParameter("jour");
		String mois = request.getParameter("mois");
		String annee = request.getParameter("annee");
	
		String description= request.getParameter("description"); 
	
		String nom_aff,adresse_aff,jour_aff,mois_aff,annee_aff,description_aff;
		String sqlString_aff = "select * from evenement";
	
		String[] VAR=new String[3];
		VAR[0]=" adresse='"+adresse+"'";
		VAR[1]=" jour='"+jour+"', mois='"+mois+"', annee='"+annee+"'";
		VAR[2]=" description='"+description+"'";
	
		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 nom="+nom;	
      	
 
	
	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())
			{
				nom_aff = rs.getString(1);
				adresse_aff = rs.getString(2);
				jour_aff = rs.getString(3);
				mois_aff = rs.getString(4);
				annee_aff = rs.getString(5);
				description_aff = rs.getString(6);
			
				out.println("Nom : " +nom_aff+"<br>");
				out.println("Adresse : "+adresse_aff+"<br>");
				out.println("Date : "+jour_aff+"/"+mois_aff+"/"+annee_aff+"<br>");
				out.println("Descrption d'événement :");
				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/eve_root.html\">continuer</a>  ou <a href=\"http:"+
		"//localhost:8080/examples/servlets/evenement.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 + -