Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.io.*;
- import java.util.*;
- import javax.servlet.*;
- import javax.servlet.http.*;
- public class readData extends HttpServlet {
- public void doGet(HttpServletRequest request,
- HttpServletResponse response) throws IOException{
- String url = "jdbc:mysql://localhost:3306/j2ee_learn";
- Connection con;
- String query = "select SUPPLIERS.SUP_NAME, COFFEES.COF_NAME " +
- "from COFFEES, SUPPLIERS " +
- "where SUPPLIERS.SUP_ID = COFFEES.SUP_ID";
- Statement stmt;
- response.setContentType("text/html");
- PrintWriter out = response.getWriter();
- out.println("<html>");
- out.println("<head>");
- out.println("<body bgcolor=\"white\">");
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch(java.lang.ClassNotFoundException e) {
- System.err.print("ClassNotFoundException: ");
- System.err.println(e.getMessage());
- }
- try {
- con = DriverManager.getConnection(url,"root", "");
- stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- ResultSetMetaData rsmd = rs.getMetaData();
- int numberOfColumns = rsmd.getColumnCount();
- int rowCount = 1;
- while (rs.next()) {
- //System.out.println("Row " + rowCount + ": ");
- for (int i = 1; i <= numberOfColumns; i++) {
- // System.out.print(" Column " + i + ": ");
- //System.out.println(rs.getString(i));
- out.println("<p>My own message</p>");
- out.println("<p>" + rs.getString(i) + "</p>");
- }
- rowCount++;
- }
- stmt.close();
- con.close();
- } catch(SQLException ex) {
- System.err.print("SQLException: ");
- System.err.println(ex.getMessage());
- }
- out.println("</body>");
- out.println("</html>");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement