package mac;
|
import databases.DBConnector;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
public class Dell_mac {
|
// ²éѯËùÓй«Ë¾
|
public static List<Mac> getAllCompanies() throws SQLException {
|
List<Mac> macs = new ArrayList<>();
|
ResultSet rs = DBConnector.queryTableData("tb_mac");
|
while (rs.next()) {
|
Mac Mac = new Mac();
|
Mac.setId(rs.getInt("id"));
|
Mac.setMac(rs.getString("mac"));
|
Mac.setPassmac(rs.getString("passmac"));
|
Mac.setUseday(rs.getString("useday"));
|
Mac.setAddtime(rs.getString("addtime"));
|
macs.add(Mac);
|
}
|
return macs;
|
}
|
|
//»ñÈ¡¼¤»îÂë
|
public static String getjihuoma() {
|
String pasmac="0";
|
try {
|
pasmac=getAllCompanies().get(0).getMac();
|
} catch (SQLException e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ catch ¿é
|
e.printStackTrace();
|
}
|
return pasmac;
|
}
|
|
//»ñȡע²áÂë
|
public static String getpassmac() {
|
String pasmac="0";
|
try {
|
pasmac=getAllCompanies().get(0).getPassmac();
|
} catch (SQLException e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ catch ¿é
|
e.printStackTrace();
|
}
|
return pasmac;
|
}
|
|
//»ñȡʹÓÃÈÕÆÚ
|
public static String getuseday() {
|
String useday="0";
|
try {
|
useday=getAllCompanies().get(0).getUseday();
|
} catch (SQLException e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ catch ¿é
|
e.printStackTrace();
|
}
|
return useday;
|
}
|
}
|