📄 even_aff.java
字号:
import java.io.*;import java.util.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;public class even_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/bg1.gif\">"); out.println("<head>"); String title = rb.getString("requestparams.title"); String nom , adresse , jour , mois , annee , 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 evenement"; ResultSet rs = smtp.executeQuery(sqlString); while (rs.next()) { nom = rs.getString(1); adresse = rs.getString(2); jour = rs.getString(3); mois = rs.getString(4); annee = rs.getString(5); description = rs.getString(6); out.println("Nom : " +nom+"<br>"); out.println("Adresse : "+adresse+"<br>"); out.println("Date : "+jour+"/"+mois+"/"+annee+"<br>"); out.println("Descrption d'événement :"); out.println(description+"<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 + -