Guest User

jdbc

a guest
Oct 16th, 2016
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.80 KB | None | 0 0
  1. /**
  2. * Created by vyas on 10/16/16.
  3. */
  4. import java.sql.Connection;
  5. import java.util.Scanner;
  6. import java.sql.DriverManager;
  7. import java.sql.ResultSet;
  8. import java.sql.Statement;
  9. public class Attendance {
  10.  
  11. public static void main(String[] args) {
  12.  
  13. Connection con= null;
  14. Statement stat = null;
  15. Scanner in = new Scanner(System.in);
  16. String sql=null;
  17. String username,password;
  18. System.out.println("\n\n\t\t\t\tWelcome To Attendance Manager ( Faculty Side )");
  19. // System.out.println("\n\n\t\t\tEnter UserName for the Oracle Server! ");
  20. // username=in.next();
  21. // System.out.println("Enter Password for the Oracle Database ");
  22. // password=in.next();
  23. username="cse14059";
  24. password="cseamrita";
  25. String path1="oracle.jdbc.driver.OracleDriver";
  26. String path2="jdbc:oracle:thin:";
  27. int choice;
  28. path2=path2.concat(username);
  29. path2=path2.concat("/");
  30. path2=path2.concat(password);
  31. path2=path2.concat("@oracle.amritanet.edu:1521/amrita2016.amritanet.edu");
  32. try{
  33. Class.forName(path1);
  34. con=DriverManager.getConnection(path2);
  35. stat=con.createStatement();
  36. sql="create table attendance(name varchar2(20),total integer,attended integer)";
  37. //sql="drop table attendance";
  38. stat.execute(sql);
  39. System.out.println("\n\n\t\tMenu : \n\n\t\t1) Add Subject \n\t\t Show Attendance in All Subjects!\n\t\t 3) Update Attendance !\n\t\t3) Show All Subjects With Attendance Below 75% \n\t\t 4) Remove Subject");
  40. System.out.println("\n\n\t\tEnter a Valid Option to Continue ! : - ( 1 / 2 )");
  41. choice=in.nextInt();
  42.  
  43. String rollno,status,val;
  44. String subject;
  45. int total,attended;
  46. switch(choice){
  47. case 1: System.out.println("Enter Subject Name");
  48. subject=in.next();
  49. sql="insert into attendance values('";
  50. sql=sql.concat(subject);
  51. sql=sql.concat("',0,0)");
  52. System.out.println(sql);
  53. stat.execute(sql);
  54. break;
  55. case 2: ResultSet res =null;
  56. sql="select * from attendance";
  57. res = stat.executeQuery(sql);
  58. boolean records = res.next();
  59. if(!records){
  60. System.out.println("No data found");
  61. }
  62. else
  63. {
  64. do{
  65. subject=res.getString(1);
  66. total=res.getInt(2);
  67. attended=res.getInt(3);
  68. }while(res.next());
  69. }
  70. break;
  71. case 3: System.out.println("Enter Subject Name to update attendance followed by status ( p / a )");
  72. subject=in.next();
  73. status=in.next();
  74. if(status=="p")
  75. val="1";
  76. else val="0";
  77. sql="update attendance set totalclass=totalclass+1 and attended=attended+";
  78. sql=sql.concat(val);
  79. sql=sql.concat(" where subject=");
  80. sql=sql.concat(subject);
  81. sql=sql.concat("\"");
  82.  
  83. stat.execute(sql);
  84.  
  85. break;
  86.  
  87.  
  88. }
  89.  
  90. }catch(Exception e){
  91. e.printStackTrace();
  92. }
  93. finally{
  94. try{
  95. stat.close();
  96. con.close();
  97. }catch(Exception e){e.printStackTrace();}
  98. }
  99. }}
Add Comment
Please, Sign In to add comment