📄 trans_log_aff.java
字号:
import java.io.*;import java.util.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;public class trans_log_aff 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=\"../images/bg2.GIF\">"); out.println("<head>"); String title = rb.getString("requestparams.title"); out.println("<title>" + title + "</title>"); out.println("</head>"); out.println("<body bgcolor=\"white\">"); String num , depart , dest , jour , mois , annee , type , duree , description; 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 { Statement smtp=null; smtp=con.createStatement(); String sqlString = "select * from trans_log"; ResultSet rs = smtp.executeQuery(sqlString); while (rs.next()) { num = rs.getString(1); depart = rs.getString(2); dest = rs.getString(3); jour = rs.getString(4); mois = rs.getString(5); annee = rs.getString(6); type = rs.getString(7); duree = rs.getString(8); description = 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("</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 + -