?? trans_log_aff2.java
字號(hào):
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); }} ?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -