Vorrei invece di vedere i record in out.println,vederli all' interno di una casella di testo(divisi ovviamente per campo).Come devo modificare?codice:<%@ page language="java" import="java.sql.*" contentType="text/html;charset=KSC5601" %> <h1>Esempio di scrip in JSP che si connette ad un database MySQL</h1> <form name="form1" method="post" action=""> <label for="textfield"></label> <input name="textfield" type="text" id="textfield"> </form> <% String host = "127.0.0.1"; String DB = "db_name"; String user = "root"; String password = ""; String query = "SELECT * FROM username"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); String url="jdbc:mysql://" + host + "/" + DB + "?user=" + user + "&password=" + password; Connection Conn=DriverManager.getConnection(url); Statement stmt = Conn.createStatement(); ResultSet rs = stmt.executeQuery(query); out.println("<table>"); while (rs.next()) { out.println("<tr>"); out.println("<td>" + rs.getString(1) + "</td>"); out.println("<td>" + rs.getString(2) + "</td>"); out.println("<td>" + rs.getString(3) + "</td>"); out.println("</tr>"); } out.println("</table>"); stmt.close(); Conn.close(); } catch (SQLException e) { out.println(" ERRORE "); out.println(" "); out.println(" ERRORE - Codice : " + e.getErrorCode()); out.println(" "); out.println(" ERRORE - Messaggio : " + e.getMessage()); out.println(" "); } %>
Grazie in anticipo