예제 #1
0
 public static ResultSet getSelect1(bookprop p) {
   ResultSet rs = null;
   try {
     Connection con = ConnectionProvider.getcon();
     Statement stmt = con.createStatement();
     rs = stmt.executeQuery("select * from appoint where did='" + p.getabc() + "'");
   } catch (Exception e) {
   }
   return rs;
 }
예제 #2
0
 public static ResultSet SelectData() {
   ResultSet rs = null;
   try {
     Connection con = ConnectionProvider.getcon();
     Statement stmt = con.createStatement();
     rs = stmt.executeQuery("select * from feedback");
   } catch (Exception e) {
   }
   return rs;
 }
예제 #3
0
 public static ResultSet getSelect() {
   ResultSet rs = null;
   try {
     Connection con = ConnectionProvider.getcon();
     Statement stmt = con.createStatement();
     rs =
         stmt.executeQuery(
             "select appointdate,appointtime,appointid from appoint where appointid in (select max(appointid) from appoint)");
   } catch (Exception e) {
   }
   return rs;
 }