📄 trans_log.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 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 depart_aff,dest_aff,jour_aff,mois_aff,annee_aff,type_aff,duree_aff,description_aff; String sqlString_aff = "select * from trans_log"; 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); } if(I_V.equals("Inserer")) { String sqlString_Ins = "insert into trans_log values("+"'"+depart+"','"+dest+"','"+jour+ "','"+mois+"','"+annee+"','"+type+"','"+duree+"','"+description+"')"; try { smtp=con.createStatement(); smtp.executeUpdate(sqlString_Ins); } catch(SQLException e) { System.err.println(e); } out.println("<p><h1>L'insertion est fait</h1></p><br><br><br>"); try { ResultSet rs = smtp.executeQuery(sqlString_aff); while (rs.next()) { depart_aff = rs.getString(1); dest_aff = rs.getString(2); jour_aff = rs.getString(3); mois_aff = rs.getString(4); annee_aff = rs.getString(5); type_aff = rs.getString(6); duree_aff = rs.getString(7); description_aff = rs.getString(8); 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_root.html\">"+ "continuer</a> ou <a href=\"http://localhost:8080/examples/servlets/trans_log.html\">"+ "s'arrêter</a> ?"); } else { if (I_V.equals("Suppression")) { String sqlString_Sup = "delete from trans_log where depart = '"+depart+"' "; try { smtp=con.createStatement(); smtp.executeUpdate(sqlString_Sup); } catch(SQLException e) { System.err.println(e); } out.println("<p><h1>La Suppression est fait</h1></p><br><br><br>"); try { ResultSet rs = smtp.executeQuery(sqlString_aff); while (rs.next()) { depart_aff = rs.getString(1); dest_aff = rs.getString(2); jour_aff = rs.getString(3); mois_aff = rs.getString(4); annee_aff = rs.getString(5); type_aff = rs.getString(6); duree_aff = rs.getString(7); description_aff = rs.getString(8); 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_root.html\">continuer</a> ou <a href=\"http:"+ "//localhost:8080/examples/servlets/trans_log.html\">"+ "s'arrêter</a> ?"); } else { if(I_V.equals("Vider")) { try { String sqlString_Vide = null; smtp=con.createStatement(); sqlString_Vide = "delete from trans_log"; smtp.executeUpdate(sqlString_Vide); } catch(SQLException e) { System.err.println(e); } out.println("<p><h2>La table de MOYEN DE TRANSPORT ET DE LOGEMENT est maintenant"+ " vidé.</h2></p>"); out.println("<p><h2>Vous voulez <a href=\"http://localhost:8080/examples/servlets/"+ "trans_log_root.html\">continuer</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 + -