A voir également:
- Connexion servlet à une base de données acces
- Gmail connexion - Guide
- Acces rapide - Guide
- Formules excel de base - Guide
- Facebook connexion - Guide
- Je n'ai plus acces a ma boite mail gmail - Guide
2 réponses
voici une exemple de servlet:
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Base_acces_servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>Stage Ingénieur </title></head>");
out.println("<body>");
out.println("<h1> Bonjour </h1>");
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
String user = "system";
String passwd = "system";
String url = "jdbc:oracle:thin:@localhost:1521:XE";
Connection conn = DriverManager.getConnection(url,user,passwd);
Statement state = conn.createStatement();
//insérreru une ligne dans la base Orders
int a=0,b=0,c=0;
state.execute("INSERT INTO Orders(Customer_ID, Order_ID, Amount) VALUES("+a+","+b+","+c+")");
} catch (Exception e) {}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doGet(request,response);
}
}
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Base_acces_servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>Stage Ingénieur </title></head>");
out.println("<body>");
out.println("<h1> Bonjour </h1>");
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
String user = "system";
String passwd = "system";
String url = "jdbc:oracle:thin:@localhost:1521:XE";
Connection conn = DriverManager.getConnection(url,user,passwd);
Statement state = conn.createStatement();
//insérreru une ligne dans la base Orders
int a=0,b=0,c=0;
state.execute("INSERT INTO Orders(Customer_ID, Order_ID, Amount) VALUES("+a+","+b+","+c+")");
} catch (Exception e) {}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doGet(request,response);
}
}