gui-playground/src/panther/db/MySQLManager.java

   1 package panther.db;
   2
   3 import java.util.ArrayList;
   4 import java.sql.*;
   5
   6 public class MySQLManager
   7 {
   8         private static final String     DB_SCHEMA       = "team3";
   9         private static final String DB_URL      = "jdbc:mysql://robocomp.dyndns.org/" + DB_SCHEMA;
  10         private static final String DB_USER     = "team3";
  11         private static final String DB_PASS     = "team3";
  12
  13         private static Connection conn;
  14
  15         static {
  16                 conn = null;
  17
  18                 try {
  19                         conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
  20                         System.out.println("Database connected");
  21                 }
  22                 catch (SQLException se) {
  23                         se.printStackTrace();
  24                 }
  25         }
  26
  27         public MySQLManager()
  28         {
  29         }
  30
  31         public static ArrayList<Student> get_students()
  32         {
  33                 ArrayList<Student> students = null;
  34
  35                 try {
  36                         students = new ArrayList<Student>();
  37
  38                         Statement st = conn.createStatement();
  39                         st.executeQuery("select * from student order by LName;");
  40
  41                         ResultSet rs = st.getResultSet();
  42
  43                         while (rs.next()) {
  44                                 students.add(new Student(rs));
  45                         }
  46                 }
  47                 catch (SQLException se) {
  48                         students = null;
  49                         se.printStackTrace();
  50                 }
  51
  52                 return students;
  53         }
  54
  55         public static RepetoireList get_student_repetoire(int sid)
  56         {
  57                 RepetoireList rlist = null;
  58
  59                 try {
  60                         Statement st = conn.createStatement();
  61                         st.executeQuery("select * from repetoire where Student_idStudent=" +
  62                                         sid + ";");
  63
  64                         ResultSet rs = st.getResultSet();
  65
  66                         rlist = new RepetoireList(rs);
  67                 }
  68                 catch (SQLException se) {
  69                         se.printStackTrace();
  70                 }
  71
  72                 return rlist;
  73         }
  74 }