CmRvewpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O01lbnUmYW1wO3F1b3Q7KTsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDstLS0tLS0tLS0tLS0tJmFtcDtxdW90Oyk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7MS4gQWRkIHN0dWRlbnQmYW1wO3F1b3Q7KTsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDsyLiBEZWxldGUgc3R1ZGVudCZhbXA7cXVvdDspOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90OzMuIFVwYWRhdGUgc3R1ZGV0JmFtcDtxdW90Oyk7CgpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90OzQuIFNlYXJjaCBzdHVkZW50JmFtcDtxdW90Oyk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7NS4gRXhpdCZhbXA7cXVvdDspOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90Oy0tLS0tLS0tLS0tLS0tLSZhbXA7cXVvdDspOwoKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtFbnRlciB5b3VyIGNob2ljZSZhbXA7cXVvdDspOwpjaG9pY2U9aW4ubmV4dEludCgpOwoKc3dpdGNoKGNob2ljZSkKewpjYXNlIDE6CgpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90Oy0tLS1FbnRlciBzdHVkZW50IGRldGFpbHMtLS0tJmFtcDtxdW90Oyk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7UmVnIG5vIDomYW1wO3F1b3Q7KTsKcmVnbm89aW4ubmV4dEludCgpOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O25hbWUmYW1wO3F1b3Q7KTsKc25hbWU9aW4ubmV4dCgpOwoKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtET0JbeXl5eS1kZC1tbV0mYW1wO3F1b3Q7KTsKZG9iPURhdGUudmFsdWVPZihpbi5uZXh0KCkpOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O0FkZHJlc3MgOiZhbXA7cXVvdDspOwpzYWRkPWluLm5leHQoKTsKClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7Q2xhc3MgOiZhbXA7cXVvdDspOwpzY2xhc3M9aW4ubmV4dCgpCjsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtDb3Vyc2UgOiZhbXA7cXVvdDspOwpzY291cnNlPWluLm5leHQoKTsKCnNxbD0mYW1wO3F1b3Q7SU5TRVJUIElOVE8gTEFLU0hNSS5TVERUQUJMRSAoU1RSRUdOTywgU1ROQU1FLCBTVERPQiwgU1RBRERSRVNTLCBTVENMQVNTLCBTVENPVVJTRSlWQUxVRVMKKCZhbXA7cXVvdDsrcmVnbm8rJmFtcDtxdW90OywgJmFtcDsjMzk7JmFtcDtxdW90OytzbmFtZSsmYW1wO3F1b3Q7JmFtcDsjMzk7LCAmYW1wOyMzOTsmYW1wO3F1b3Q7K2RvYi50b1N0cmluZygpKyZhbXA7cXVvdDsmYW1wOyMzOTssICZhbXA7IzM5OyZhbXA7cXVvdDsrc2FkZCsmYW1wO3F1b3Q7JmFtcDsjMzk7LCAmYW1wOyMzOTsmYW1wO3F1b3Q7K3NjbGFzcysmYW1wO3F1b3Q7JmFtcDsjMzk7LCAmYW1wOyMzOTsmYW1wO3F1b3Q7K3Njb3Vyc2UrJmFtcDtxdW90OyZhbXA7IzM5OykmYW1wO3F1b3Q7OwppbnQgcmVzdWx0PXN0bXQuZXhlY3V0ZVVwZGF0ZShzcWwpOwppZihyZXN1bHQ9PTEpCgp7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7U3R1ZGVudCBkZXRhaWxzIGFyZSBzYXZlZCAmYW1wO3F1b3Q7KTsKfWVsc2V7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7RXJyb3Igd2hpbGUgc2F2aW5nIHN0dWRlbnQgZGV0YWlscyAmYW1wO3F1b3Q7KTsKfQoKYnJlYWs7CgpjYXNlIDI6ClN5c3RlbS5vdXQucHJpbnQoJmFtcDtxdW90O0VudGVyIFN0dWRlbnQgUmVnbm86JmFtcDtxdW90Oyk7CnJlZ25vPWluLm5leHRJbnQoKTsKc3FsPSZhbXA7cXVvdDtTRUxFQ1QgQ09VTlQoKikgRlJPTSBMQUtTSE1JLlNURFRBQkxFIFdIRVJFIFNUUkVHTk89JmFtcDtxdW90OytyZWdubzsKcnM9c3RtdC5leGVjdXRlUXVlcnkoc3FsKTsKcnMubmV4dCgpOwppZihycy5nZXRJbnQoMSk9PTEpCnsKc3FsPSZhbXA7cXVvdDtERUxFVEUgRlJPTSBMQUtTSE1JLlNURFRBQkxFIFdIRVJFIFNUUkVHTk89JmFtcDtxdW90OytyZWdubzsKaW50IHJlcz1zdG10LmV4ZWN1dGVVcGRhdGUoc3FsKTsKCmlmKHJlcz09MSkKewpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O1N0dWRlbnQgcmVjb3JkIGlzIGRlbGV0ZWQmYW1wO3F1b3Q7KTsKCn1lbHNlewpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O3JlY29yZCBub3QgZGVsZXRlZCZhbXA7cXVvdDspOwp9Cgp9ZWxzZQp7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7U3R1ZGVudCByZWNvcmQgbm90IGZvdW5kJmFtcDtxdW90Oyk7Cn0KCmJyZWFrOwpjYXNlIDM6ClN5c3RlbS5vdXQucHJpbnQoJmFtcDtxdW90O0VudGVyIFN0dWRlbnQgUmVnbm86JmFtcDtxdW90Oyk7CnJlZ25vPWluLm5leHRJbnQoKTsKc3FsPSZhbXA7cXVvdDtTRUxFQ1QgQ09VTlQoKikgRlJPTSBMQUtTSE1JLlNURFRBQkxFIFdIRVJFIFNUUkVHTk89JmFtcDtxdW90OytyZWdubzsKcnM9c3RtdC5leGVjdXRlUXVlcnkoc3FsKTsKcnMubmV4dCgpOwppZihycy5nZXRJbnQoMSk9PTEpCnsKc3FsPSZhbXA7cXVvdDtTRUxFQ1QgU1RBRERSRVNTIEZST00gTEFLU0hNSS5TVERUQUJMRSBXSEVSRSBTVFJFR05PPSZhbXA7cXVvdDsrcmVnbm87CnJzPXN0bXQuZXhlY3V0ZVF1ZXJ5KHNxbCk7Cgpycy5uZXh0KCk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7b2xkIGFkZHJlc3M6JmFtcDtxdW90Oytycy5nZXRTdHJpbmcoMSkpOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O0VudGVyIG5ldyBhZGRyZXNzOiZhbXA7cXVvdDspOwpTdHJpbmcgYWRkPWluLm5leHRMaW5lKCk7CnNxbD0mYW1wO3F1b3Q7VVBEQVRFIExBS1NITUkuU1REVEFCTEUgU0VUIFNUQUREUkVTUz0mYW1wOyMzOTtuZXcgQWRkcmVzcyZhbXA7IzM5OyBXSEVSRSBTVFJFR05PPSZhbXA7cXVvdDsrcmVnbm87CmlmKHN0bXQuZXhlY3V0ZVVwZGF0ZShzcWwpPT0xKQp7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7QWRkcmVzcyB1cGRhdGVkJmFtcDtxdW90Oyk7Cn1lbHNlewpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O0Vycm9yIHdoaWxlIHVwZGF0aW5nIGFkZHJlc3MmYW1wO3F1b3Q7KTsKfQoKfWVsc2UKewpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O1N0dWRlbnQgcmVjb3JkIG5vdCBmb3VuZCZhbXA7cXVvdDspOwp9CgpicmVhazsKCmNhc2UgNDoKU3lzdGVtLm91dC5wcmludCgmYW1wO3F1b3Q7RW50ZXIgU3R1ZGVudCBSZWdubzomYW1wO3F1b3Q7KTsKcmVnbm89aW4ubmV4dEludCgpOwpzcWw9JmFtcDtxdW90O1NFTEVDVCAqIEZST00gTEFLU0hNSS5TVERUQUJMRSBXSEVSRSBTVFJFR05PPSZhbXA7cXVvdDsrcmVnbm87CnJzPXN0bXQuZXhlY3V0ZVF1ZXJ5KHNxbCk7CmlmKHJzIT1udWxsKQp7CnJzLm5leHQoKTsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtTdHVkZW50IGRldGFpbHMgYXJlJmFtcDtxdW90Oyk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7LS0tLS0tLS0tLS0tLS0tLS0tLS0mYW1wO3F1b3Q7KTsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtTdHVkZW50IGRldGFpbHMgYXJlJmFtcDtxdW90Oyk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7UmVnIG5vJmFtcDtxdW90Oytycy5nZXRJbnQoMSkpOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O05hbWUmYW1wO3F1b3Q7K3JzLmdldFN0cmluZygyKSk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7RG9iJmFtcDtxdW90Oytycy5nZXRTdHJpbmcoMykpOwpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O0FkZHJlc3MmYW1wO3F1b3Q7K3JzLmdldFN0cmluZyg0KSk7ClN5c3RlbS5vdXQucHJpbnRsbigmYW1wO3F1b3Q7Q2xhc3MmYW1wO3F1b3Q7K3JzLmdldFN0cmluZyg1KSk7CgpTeXN0ZW0ub3V0LnByaW50bG4oJmFtcDtxdW90O0NvdXJzZSZhbXA7cXVvdDsrcnMuZ2V0U3RyaW5nKDYpKTsKfQpicmVhazsKCmNhc2UgNToKc3RtdC5jbG9zZSgpOwpjb24uY2xvc2UoKTsKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtUaGFuayB1JmFtcDtxdW90Oyk7CnJldHVybjsKZGVmYXVsdDoKU3lzdGVtLm91dC5wcmludGxuKCZhbXA7cXVvdDtXcm9uZyBjaG9pY2UgXG4gVHJ5IEFnYWluJmFtcDtxdW90Oyk7Cn0KfXdoaWxlKHRydWUpOwp9IGNhdGNoIChDbGFzc05vdEZvdW5kRXhjZXB0aW9uIGV4KSB7CkxvZ2dlci5nZXRMb2dnZXIoU3R1ZGVudEluZm9NZ3QuY2xhc3MuZ2V0TmFtZSgpKS5sb2coTGV2ZWwuU0VWRVJFLCBudWxsLCBleCk7Cn0gY2F0Y2ggKFNRTEV4Y2VwdGlvbiBleCkgewpMb2dnZXIuZ2V0TG9nZ2VyKFN0dWRlbnRJbmZvTWd0LmNsYXNzLmdldE5hbWUoKSkubG9nKExldmVsLlNFVkVSRSwgbnVsbCwgZXgpOwp9Cn0KCn0=
do{
System.out.println("Menu");
System.out.println("-------------");
System.out.println("1. Add student");
System.out.println("2. Delete student");
System.out.println("3. Upadate studet");
System.out.println("4. Search student");
System.out.println("5. Exit");
System.out.println("---------------");
System.out.println("Enter your choice");
choice=in.nextInt();
switch(choice)
{
case 1:
System.out.println("----Enter student details----");
System.out.println("Reg no :");
regno=in.nextInt();
System.out.println("name");
sname=in.next();
System.out.println("DOB[yyyy-dd-mm]");
dob=Date.valueOf(in.next());
System.out.println("Address :");
sadd=in.next();
System.out.println("Class :");
sclass=in.next()
;
System.out.println("Course :");
scourse=in.next();
sql="INSERT INTO LAKSHMI.STDTABLE (STREGNO, STNAME, STDOB, STADDRESS, STCLASS, STCOURSE)VALUES
("+regno+", '"+sname+"', '"+dob.toString()+"', '"+sadd+"', '"+sclass+"', '"+scourse+"')";
int result=stmt.executeUpdate(sql);
if(result==1)
{
System.out.println("Student details are saved ");
}else{
System.out.println("Error while saving student details ");
}
break;
case 2:
System.out.print("Enter Student Regno:");
regno=in.nextInt();
sql="SELECT COUNT(*) FROM LAKSHMI.STDTABLE WHERE STREGNO="+regno;
rs=stmt.executeQuery(sql);
rs.next();
if(rs.getInt(1)==1)
{
sql="DELETE FROM LAKSHMI.STDTABLE WHERE STREGNO="+regno;
int res=stmt.executeUpdate(sql);
if(res==1)
{
System.out.println("Student record is deleted");
}else{
System.out.println("record not deleted");
}
}else
{
System.out.println("Student record not found");
}
break;
case 3:
System.out.print("Enter Student Regno:");
regno=in.nextInt();
sql="SELECT COUNT(*) FROM LAKSHMI.STDTABLE WHERE STREGNO="+regno;
rs=stmt.executeQuery(sql);
rs.next();
if(rs.getInt(1)==1)
{
sql="SELECT STADDRESS FROM LAKSHMI.STDTABLE WHERE STREGNO="+regno;
rs=stmt.executeQuery(sql);
rs.next();
System.out.println("old address:"+rs.getString(1));
System.out.println("Enter new address:");
String add=in.nextLine();
sql="UPDATE LAKSHMI.STDTABLE SET STADDRESS='new Address' WHERE STREGNO="+regno;
if(stmt.executeUpdate(sql)==1)
{
System.out.println("Address updated");
}else{
System.out.println("Error while updating address");
}
}else
{
System.out.println("Student record not found");
}
break;
case 4:
System.out.print("Enter Student Regno:");
regno=in.nextInt();
sql="SELECT * FROM LAKSHMI.STDTABLE WHERE STREGNO="+regno;
rs=stmt.executeQuery(sql);
if(rs!=null)
{
rs.next();
System.out.println("Student details are");
System.out.println("--------------------");
System.out.println("Student details are");
System.out.println("Reg no"+rs.getInt(1));
System.out.println("Name"+rs.getString(2));
System.out.println("Dob"+rs.getString(3));
System.out.println("Address"+rs.getString(4));
System.out.println("Class"+rs.getString(5));
System.out.println("Course"+rs.getString(6));
}
break;
case 5:
stmt.close();
con.close();
System.out.println("Thank u");
return;
default:
System.out.println("Wrong choice \n Try Again");
}
}while(true);
} catch (ClassNotFoundException ex) {
Logger.getLogger(StudentInfoMgt.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(StudentInfoMgt.class.getName()).log(Level.SEVERE, null, ex);
}
}
}