1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| package Rest;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class cnx {
public void Requete1() throws SQLException, IOException {
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1/gelthatem";
String user="root";
String pass="";
Connection cnx = DriverManager.getConnection(url,user,pass);
Statement st= cnx.createStatement();
String req= "select nom , prenom from patient where sexe = F ";
ResultSet result = st.executeQuery(req);
FileWriter fw3 = new FileWriter("C:\\Users\\DELL\\Documents\\NetBeansProjects\\Sw\\web\\index.jsp");
PrintWriter pw3 = new PrintWriter(fw3);
while(result.next())
{
pw3.println("<h1>");
pw3.println(result);
pw3.println("</h1>");
}
pw3.flush();
fw3.flush();
pw3.close();
fw3.close();
cnx.close();
} catch (ClassNotFoundException ex) {
Logger.getLogger(gelthatem.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(gelthatem.class.getName()).log(Level.SEVERE, null, ex);
}
}
} |
Partager