?? modif_client.java
字號:
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class MODF_CLIENT 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>");
out.print("<BODY LANG=fr-FR DIR=LTR
BACKGROUND=../servlets/Paper01.jpg>");
out.println("<head>");
String title = rb.getString("requestparams.title");
out.println("<title>" + title + "</title>");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
String[] choix=new String[8];
int i;
for(i=1;i<=7;i++)
choix[i]=request.getParameter("C"+i);
String micro=request.getParameter("micro");
choix[0]=micro;
String nom=request.getParameter("nom");
String adresse=request.getParameter("adresse");
String numclient=request.getParameter("numClient");
String numtel=request.getParameter("numtel");
String numSecu= request.getParameter("numSecu");
String numCentreSecu=
request.getParameter("numCentreSecu");
String mutuelle= request.getParameter("mutuelle");
String taux= request.getParameter("taux");
String[] VAR=new String[8];
VAR[0]=" micro='"+micro+"'";
VAR[1]=" nom='"+nom+"'";
VAR[2]=" adresse='"+adresse+"'";
VAR[3]=" numtel="+numtel;
VAR[4]=" numSecu="+numSecu;
VAR[5]=" numCentreSecu="+numCentreSecu;
VAR[6]=" mutuelle='"+mutuelle+"'";
VAR[7]=" tauxmutuelle="+taux;
int h=0;
String SQLrequete="UPDATE CLIENT SET " ;
for(i=0;i<=7;i++)
{if(choix[i]!=null)
if(h==0)
{
SQLrequete=SQLrequete+VAR[i] ;
h++;
}
else
SQLrequete=SQLrequete+","+VAR[i] ;
}
SQLrequete=SQLrequete+" WHERE numclient="+numclient;
Connection con=null ;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@capucine.univ-mrs.fr:1521:ens","lic341","panadole");
Statement smtp=null;
smtp=con.createStatement();
smtp.executeUpdate(SQLrequete );
smtp.close();
}
catch(Exception e)
{
System.err.println(e);
}
response.sendRedirect("../servlets/acceil_phar.html");
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 + -