Algorithms

benjamin yap wrote:

So i would like my staff to define their own sms format. So which is the best way i can do that?

try {
    ArrayList<String> array = new ArrayList<String>();
    String firstword = null;
    ResultSet rs1 = null;
    ResultSet rs2 = null;
    int id = 0;
    String sql1 = "SELECT * from userapp";
    String sql3 = null;

    rs1 = db.SelectDB(sql1);
    while (rs1.next()) {
        array.add(rs1.getString("keyword"));
    }

    for (String i : array) {
        sql3 = "SELECT * FROM SMSSERVER_IN WHERE TEXT LIKE '" + i + "%'";
        ResultSet rs3 = db.SelectDB(sql3);
        //out.print(i);
        while (rs3.next()) {
            out.print(i);
            String sql4 = "Insert into app_" + i + "(originator,text)values(" + rs3.getString("originator") + ",'" + rs3.getString("text") + "')";
            db.InsertDB(sql4);
        }
        String sql5 = "DELETE FROM SMSSERVER_IN WHERE TEXT LIKE'" + i + "%'";
        db.DeleteDB(sql5);
    }
} catch (Exception ex) {
}

benjamin yap wrote:

Also, u mention building a regular expression, how can i create an interface that allows the user who define the format to have their own expression? What kind of form or fields should i display in order to build it.

ran9 wrote:

the modem does its own thing upon connecting and doesn't give me control over the received data.

Roger Wright wrote:

Can you be more specific about what "its own thing" might be? Is it doing things that other modems don't?