Write a JSP program to accept the details of Account (ANo, Type, Bal) and store it into database and display it in tabular form. (Use PreparedStatement interface)

By
SaveAccount.html

<html>
<body>
<form method=get action="saveAccount.jsp">
Enter Account No. : <input type=text name=ano><br><br>
Enter Account Type:<input type=text name=type><br><br>
Enter Balance : <input type=text name=bal><br><br>
<input type=submit value="Save">
</form>
</body>
</html>

saveAccount.jsp

<html>
<body>
<%@ page import="java.sql.*;" %>
<%! int ano,bal;
       String type;  %>
<%
      ano=Integer.parseInt(request.getParameter("ano"));
      type=request.getParameter("type");
      bal=Integer.parseInt(request.getParameter("bal"));
      try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection cn=DriverManager.getConnection("jdbc:odbc:acnt","","");
            PreparedStatement s=cn.prepareStatement("insert into Account values(?,?,?)");
            s.setInt(1,ano);
            s.setString(2,type);
            s.setInt(3,bal);
            s.executeUpdate();
            out.println("Record is saved");
            Statement st=cn.createStatement();
            ResultSet rs=st.executeQuery("select * from Account");
%>
<table border="1" width="40%">
<%      while(rs.next())
            {
%>
<tr> <td><%= rs.getInt("ano") %></td>
            <td><%= rs.getString("type") %></td>
            <td><%= rs.getInt("bal") %></td>
</tr>
<%
            }
            cn.close();
          }catch(Exception e)
            {      
                   out.println(e);      
            }
%>
</body>
</html>

Comments

Post a Comment

Popular posts from this blog

Write a java program to create Teacher table(TNo.TName, Sal, Desg) and insert a record in it.

By
import java.io.*; import java.sql.*; public class CreateTeacherTable {            static Connection cn;             static Statement st;             public static void main(String args[])             {                    try                  {                                 int tno,sal;                         String tname,desg;                         BufferedReader br=new BufferedReader(new InputStreamReader(System.in));                         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    ...
Read more

Create a JSP page to accept a number from an user and display it in words: Example: 123 – One Two Three. The output should be in red color.

By
NumberWord.html <html> <body> <form method=get action="NumberWord.jsp"> Enter Any Number : <input type=text name=num><br><br> <input type=submit value="Display"> </form> <body> </html> NumberWord.jsp <html> <body> <font color=red> <%! int i,n;        String s1; %> <%   s1=request.getParameter("num");          n=s1.length();          i=0;          do          {            char ch=s1.charAt(i);            switch(ch)             {                 case '0': out.println("Zero...
Read more

Write a multithreading program in java to display all the vowels from a given String.(Use Thread Class)

By
import java.lang.*; import java.util.*; class Vowels extends Thread {             String s1;             Vowels(String s)             {           s1=s;                         start();             }             public void run()             {                         System.out.println("Vowels are  ");                         for(int i=0;i<s1.length();i++)                         {                                     char ch=s1.charAt(i); ...
Read more