Solution:
//saveAccount.html
<html>
<body>
<form method='post' action='saveAccount.jsp'>
<table>
<tr>
<td><b>Account No:</b></td>
<td><input type='text' name='ano'></td>
</tr>
<tr>
<td><b>Account Type:</b></td>
<td>
<select name='type'>
<option value=''>Select Type</option>
<option value='Saving'>Saving</option>
<option value='Current'>Current</option>
</select>
</td>
</tr>
<tr><td><b>Balance:</b></td><td><input type='text' name='bal'></td></tr>
<tr><td><input type='submit'></td><td><input type='reset'></td></tr>
</table>
</form>
<a href='view_accounts.jsp'>View Accounts</a>
</body>
</html>
//saveAccount.jsp
<%@page import="java.sql.*" errorPage="err.jsp"%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","");
int ano = Integer.parseInt(request.getParameter("ano"));
String type = request.getParameter("type");
float bal = Float.parseFloat(request.getParameter("bal"));
PreparedStatement ps = con.prepareStatement("insert into account values(?,?,?)");
ps.setInt(1,ano);
ps.setString(2,type);
ps.setFloat(3,bal);
ps.executeUpdate();
%>
Account created successfully.<br>
<a href='SaveAccount.html'>Add Account</a> <a href='view_accounts.jsp'>View Accounts</a>
//view_accounts.jsp
<%@page import="java.sql.*"%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","");
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from account");
%>
<table border=1>
<tr><th>Account No</th><th>Type</th><th>Balance</th></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getFloat(3)%></td>
</tr>
<%
}
%>
</table><br>
<a href='SaveAccount.html'>Home</a>
//err.jsp
<%@page isErrorPage="true"%>
Error:<%=exception%><br>
<a href='SaveAccount.html'>Home</a>
0 Comments