📄 modif_eve.java
字号:
import java.io.*;import java.util.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;public class modif_eve 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>"); String title = rb.getString("requestparams.title"); out.println("<title>"+title+"</title>"); 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[] 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; Connection con=null ; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@capucine:1521:ens","lic329","oracle"); Statement smtp=null; smtp=con.createStatement(); smtp.executeUpdate(SQLrequete ); out.println("<p><h1>La Modification est fait</h1></p><br><br><br>"); 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_modif.html\">continuer</a> ou <a href=\"http://localhost:8080/examples/"+ "servlets/eve_root.html\">faire une autre operation </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 + -