hi
i am new to jsp, i need to create a jsp page that has list All,
Add, Delete, Update button, the page should display all the records from the database when list All button is clicked and adds new record when add button is clicked and so on,
is there any way using struts here?
can any one help me plz..
i have already created a jsp page .it retrieves all record from the DB.
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*, javax.sql.*, javax.naming.*,javax.naming.NamingException"%>
<html>
<head>
<title></title>
</head>
<body>
<%
DataSource ds = null;
Connection conn = null;
ResultSet result = null;
Statement stmt = null;
ResultSetMetaData rsmd = null;
try{
Context context = new InitialContext();
if(context==null)
{throw new RuntimeException("no jndi");}
Context envCtx = (Context) context.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("testjndi");
// ds = getTestjndi();
if (ds != null) {
conn = ds.getConnection();
stmt = conn.createStatement();
result = stmt.executeQuery("select * from \"ADMIN\".\"patient\" where p_age=5");
}
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
int columns=0;
try {
rsmd = result.getMetaData();
columns = rsmd.getColumnCount();
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
%>
<table width="90%" border="1">
<tr>
<% // write out the header cells containing the column labels
try {
for (int i=1; i<=columns; i++) {
out.write("<th>" + rsmd.getColumnLabel(i) + "</th>");
}
%>
</tr>
<% // now write out one row for each entry in the database table
while (result.next()) {
out.write("<tr>");
for (int i=1; i<=columns; i++) {
out.write("<td>" + result.getString(i) + "</td>");
}
out.write("</tr>");
}
// close the connection, resultset, and the statement
result.close();
stmt.close();
conn.close();
} // end of the try block
catch (SQLException e) {
System.out.println("Error " + e);
}
// ensure everything is closed
finally {
try {
if (stmt != null)
stmt.close();
} catch (SQLException e) {}
try {
if (conn != null)
conn.close();
} catch (SQLException e) {}
}
%>
</table>
</body>
</html>