QuestionAsk Questions?
lakshmi
to upload a table from DB to the same html page
1 Answer(s) 2 years and 4 months ago
Posted in : JSP-Interview Questions
1 Answer(s) 2 years and 4 months ago
Posted in : JSP-Interview Questions
how to make this booklist table to be opened in the same html page itself using a third frame?
View Answers
February 9, 2011 at 2:48 PM
JSP Retrieve data from database table
<%@page import="java.sql.*"%>
<table border=1>
<tr><th>Name</th><th>Address</th></tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data");
while(rs.next()){
%>
<tr><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
rs.close();
st.close();
con.close();
}
catch(Exception e){}
%>
</table>
Related Pages:
