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);
}
}
}
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
Post a Comment