Write a java program to create a student table with field’s rno, name and per. Insert values in the table. Display all the details of the student on screen. (Use PreparedStatement Interface)

import java.io.*;
import java.sql.*;
public class CreateStudentTable
{           static Connection cn;
            static Statement st;
            static PreparedStatement ps;
            static ResultSet rs;
            public static void main(String args[])
            {         try{
                                    int rno,per;
                                    String name;
                                    BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
                                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                    cn=DriverManager.getConnection("jdbc:odbc:dsn","","");
                                    String str="create table Stud(rno number,name varchar(20),per number)";
                                    ps=cn.prepareStatement(str);
                                    ps.executeUpdate();
                                    System.out.println("\nStudent Table Created");
                                    System.out.println("\n Howmany Records you want to insert?");
                                    int n=Integer.parseInt(br.readLine());
                                    System.out.println("\nEnter "+n+" Records \n");
                                    for(int i=0;i<n;i++)
                                    {
                                                System.out.println("\nEnter ");
                                                rno=Integer.parseInt(br.readLine());
                                                System.out.println("Enter Student name");
                                                name=br.readLine();
                                                System.out.println("Enter per");
                                                per=Integer.parseInt(br.readLine());
                                                ps=cn.prepareStatement("insert into Stud values(?,?,?)");
                                                ps.setInt(1,rno);
                                                ps.setString(2,name);
                                                ps.setInt(3,per);
                                                ps.executeUpdate();
                                    }
                                    System.out.println("\nAll Records are: \n");
                                    st=cn.createStatement();
                                    rs=st.executeQuery("select * from Stud");
                                    System.out.println("RollNo \t Name \t Perc.");
                                    while(rs.next())
                                    {
                                    System.out.println(rs.getInt("rno")+"\t"+rs.getString("name")+"\t"+rs.getInt("per"));                                 }
                                    cn.close();       
                        }catch(Exception e){
                                                            System.out.println(e);
                                                        }
            }
}

Comments

Popular posts from this blog

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

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.

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)