public static List<to_users.u> get_user_data() {
List<to_users.u> datas = new ArrayList();
String s0 = "select user_name,user_level,user_code from " + MyDB.getNames() + ".users ";
try {
Connection conn = PoolConnection.connect();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(s0);
while (rs.next()) {
String username = rs.getString(1);
String user_level = rs.getString(2);
String name = rs.getString(3);
System.out.println(username);
to_users.u to = new to_users.u(username, user_level, name);
datas.add(to);
}
} catch (Exception e) {
throw new RuntimeException(e);
} finally {
PoolConnection.close();
}
return datas;
}
public static String check_if_inv_exists(String number) {
// String date=S5_select_
String stat = "";
try {
Connection conn = PoolConnection.connect();
String s0 = "";
} catch (Exception e) {
throw new RuntimeException(e);
} finally {
PoolConnection.close();
}
return stat;
}
public static List<String> get_cashiers() {
List<String> datas = new ArrayList();
try {
Connection conn = PoolConnection.connect();
String s0 = "select user_name from " + MyDB.getNames() + ".users where user_level=0";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(s0);
while (rs.next()) {
String num = rs.getString(1);
datas.add(num);
}
return datas;
} catch (Exception e) {
throw new RuntimeException(e);
} finally {
PoolConnection.close();
}
}
public static void get_user_data2(String user_name) {
// String s0 =
// "call pb_pos_restaurant.select_user_details2( "
// + " :a_user_name "
// + " ); ";
// s0=SqlStringUtil.parse(s0)
// .setString("a_user_name", user_name)
// .ok();
String s1 =
"select "
+ "p.user_code"
+ ",p.user_name"
+ ",p.password"
+ ",p.user_level from "
+ MyDB.getNames()
+ ".users p where user_name='"
+ user_name
+ "'";
try {
Connection conn = PoolConnection.connect();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(s1);
while (rs.next()) {
password = rs.getString(3);
userlevel = rs.getInt(4);
}
} catch (Exception e) {
throw new RuntimeException(e);
} finally {
PoolConnection.close();
}
}