how to display data of database on html page using jsp

Harshita Kansra

12y2.9kJSP

how to display data of database on html page using jsp using netbeans

i have tried something but stuck

<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%>

<%@page import="java.sql.*" %>

JSP Page

String n=request.getParameter("button");

if(n.equals("SHOW TABLE"))

{

try{

Connection con = DriverManager.getConnection("jdbc:odbc:t");

String id = request.getParameter("id");

String sql = "Select * from [table1] where id = '" + id + "'";;

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery( sql );

}catch(Exception e) {}

}

ID	Name
<%= rs.getString(1) %>	<%= rs.getString(2) %>

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak12y ago
http://www.c-sharpcorner.com/uploadfile/satyapriyanayak/display-data-from-database-through-jsp-and-jdbc/default.aspx
http://www.c-sharpcorner.com/UploadFile/0d4935/display-table-data-throw-jsp/