package jdbc1;
import [Link]. *;
import [Link].*;
import [Link]. *;
import [Link];
public class PROGRAM5
{
public static void main(String[] args) throws Exception
{
[Link]("Enter your choice:");
DataInputStream br=new DataInputStream([Link]);
int v_total=0;
float v_per=0;
while(true)
{
[Link]("1. New Student Entry \n 2. Calculate student result \n 3.
Display specified student’s formatted Mark sheet \n 4. Delete Student Entry \n
[Link] the Student info \n [Link]");
int x=[Link]([Link]());
if(x==1)
{
[Link]("[Link]");
Connection con=[Link]
("jdbc:mysql://localhost:3306/emp","root","root");
[Link]("Inserting records");
PreparedStatement ps=[Link]("insert into student
values(?,?,?,?,?,?,?)");
[Link]("Enter student number : ");
int v_stdno=[Link]([Link]());
[Link]("Enter student name : ");
String v_stdname=[Link]();
[Link]("Enter marks of subject 1 : ");
int v_s1=[Link]([Link]());
[Link]("Enter marks of subject 2: ");
int v_s2=[Link]([Link]());
[Link]("Enter marks of subject 3 : ");
int v_s3=[Link]([Link]());
[Link](1,v_stdno); [Link](2,v_stdname);
[Link](3,v_s1); [Link](4,v_s2);
[Link](5,v_s3); [Link](6,v_total);
[Link](7,v_per);
int count=[Link]();
[Link]("Records affected "+count);
[Link]();
}
else if(x==2)
{
[Link]("[Link]");
Connection con=[Link]
("jdbc:mysql://localhost:3306/emp","root","root");
ResultSet rs=null;
v_total=0;
int v_stdno=0;
v_per=0;
[Link]("Enter student number : ");
v_stdno=[Link]([Link]());
Statement st=[Link]();
rs=[Link]("select * from student");
while([Link]())
{
if(v_stdno==[Link](1))
v_total=[Link](3)+ [Link](4)+[Link](5);
}
v_per=v_total/3;
[Link]("The total of specified student is "+v_total);
[Link]("The percentage of specified student is "+v_per);
PreparedStatement ps=[Link](" update student set
total=?,percentage=? where std_ID=?");
[Link](1,v_total);
[Link](2,v_per);
[Link](3,v_stdno);
[Link]();
[Link]("Record is update with total and percentage");
[Link]();
}
else if(x==3)
{
[Link]("[Link]");
Connection con=[Link]
("jdbc:mysql://localhost:3306/emp","root","root");
ResultSet rs=null;
int v_stdno=0,v_sno=0,v_s1=0,v_s2=0,v_s3=0;
v_total=0;
String v_sname="";
v_per=0;
[Link]("Enter student number : ");
v_stdno=[Link]([Link]());
Statement st=[Link]();
rs=[Link]("select * from student");
while([Link]())
{
if(v_stdno==[Link](1))
{
v_sno=[Link](1);
v_sname=[Link](2);
v_s1=[Link](3);
v_s2=[Link](4);
v_s3=[Link](5);
v_total=[Link](6);
v_per=[Link](7);
[Link]("**************************************************");
[Link]("[Link]\[Link]\tSUB1\tSUB2\tSUB3\tTOTAL\tPERCENTAGE");
[Link](""+v_sno+"\t"+v_sname+"\t"+v_s1+"\t"+v_s2+"\t"+v_s3+"\t"+v_to
tal+"\t"+v_per+"");
[Link]("**************************************************");
}
}
[Link]();
}
else if(x==4)
{
[Link]("[Link]");
Connection con=[Link]
("jdbc:mysql://localhost:3306/emp","root","root");
PreparedStatement ps=[Link]("delete from student where
std_no=?");
[Link]("Enter student number :");
int v_stdno=0;
v_stdno=[Link]([Link]());
[Link](1,v_stdno);
[Link]();
[Link]("Student data deleted ");
}
else if(x==5)
{
[Link]("[Link]");
Connection con=[Link]
("jdbc:mysql://localhost:3306/emp","root","root");
[Link]("Enter student number to modify : ");
int v_stdno=[Link]([Link]());
[Link]("Enter new student number : ");
int n_stdno=[Link]([Link]());
[Link]("Enter new student name : ");
String v_stdname=[Link]();
[Link]("Enter marks of subject 1 : ");
int v_s1=[Link]([Link]());
[Link]("Enter marks of subject 2: ");
int v_s2=[Link]([Link]());
[Link]("Enter marks of subject 3 : ");
int v_s3=[Link]([Link]());
v_total=v_s1+v_s2+v_s3;
v_per=v_total/3;
PreparedStatement ps=[Link](" update student set
std_no=?,std_name=?,std_sub1=?,std_sub2=?,std_sub3=?,total=?,percentage=? where
std_no=?");
[Link](1,n_stdno);
[Link](2,v_stdname); [Link](3,v_s1);
[Link](4,v_s2);
[Link](5,v_s3);
[Link](6,v_total);
[Link](7,v_per);
[Link](8,v_stdno);
[Link]();
}
else if(x==6)
{ break; }
else
{ }
}
}
}