J2ME, servlet and database help..

[ling ling]

I have been told to create a J2ME and the J2ME allow user to key in their passwords, update, delete information,add new information and register in the database.. and must be able to retrieve information from database to J2ME.



HealthcareSystem.java(this is my J2ME file)

import javax.microedition.midlet.*;//defines Mobile Information Device Profile applications and the interactions between the application and the environment in which the application runs.
import javax.microedition.lcdui.*;//implementation of user interfaces for MIDP applications.
import javax.microedition.io.*;//MID Profile includes networking support based on the GenericConnection framework from the Connected Limited Device Configuration
import java.io.*;//Provides for system input and output through data streams
import java.lang.String.*;
import java.util.*;
 
public class HealthcareSystem extends MIDlet implements CommandListener
{
private Display display;
private Command exitCommand, backCommand, okCommand, doneCommand, nextCommand, signinCommand, registerCommand;
private Command updateCommand, newPatientCommand;
private Form form, form2, form3, form3_S, form3_F, form4, form5, form6, form7, form8;
TextField strItem, pwd, regName, regGender, regUsername, regPass, regConPass, newName, newDate, newTime, newPlace;
TextField newRemark, editDate, editTime, editPlace, editRemark;
StringBuffer sb= null;
String display_Username="";
 
int currentForm= 1;
 
public HealthcareSystem()
{
display= Display.getDisplay(this);
 
exitCommand= new Command("Exit",Command.EXIT,1);
backCommand= new Command("Back",Command.BACK,1);
okCommand= new Command("Submit",Command.OK,1);
doneCommand= new Command("Done",Command.OK,1);
nextCommand= new Command("Next",Command.OK,1);
signinCommand= new Command("Sign in",Command.OK,1);
registerCommand= new Command("Register",Command.OK,1);
newPatientCommand= new Command("New Patient",Command.OK,1);
updateCommand= new Command("Update",Command.OK,1);
 
}
 
public void startApp()
{
 
String url = "http://localhost:8080/J2ME/servlet/information";
try{
sb = getViaHttpConnection(url);
//display_Username = sb.toString();
System.out.println(sb.toString() + "sb String");
} catch (IOException ioe) {
System.out.println(ioe.getMessage());
}
 
//*****************  form1   *********************************************************
 
form = new Form("");
 
//StringItem displaytext= new StringItem(null,"\n Nanyang Polytechnic @ 2005");
form.setTicker(new Ticker(" Welcome to Healthcare Information Management System!!!"));
//form.append(displaytext);
form.append("Development of a Healthcare Information Management System");
form.addCommand(signinCommand);
form.addCommand(registerCommand);
form.setCommandListener(this);
 
display.setCurrent(form);
 
 
//*****************  form2   *********************************************************
 
form2 = new Form("User Login Page");
 
strItem= new TextField("  LoginID   ","",10,TextField.ANY);
pwd= new TextField("Password","",10,TextField.PASSWORD);
 
form2.append(strItem);
form2.append(pwd);
form2.addCommand(okCommand);
form2.addCommand(backCommand);
form2.setCommandListener(this);
 
 
//*****************  form6   *********************************************************
 
form6 = new Form("Login Incorrect");
 
StringItem displaytext2 = new StringItem(null,"Please try again.");
 
form6.append(displaytext2);
form6.addCommand(backCommand);
form6.setCommandListener(this);
 
//****************  form3   ***********************************************************
 
form3 = new Form("Registration");
 
regName= new TextField("Name","",40,TextField.ANY);
regGender= new TextField("Date Of Birth","",30,TextField.ANY);
regUsername= new TextField("Username","",10,TextField.ANY);
regPass= new TextField("Password","",10,TextField.PASSWORD);
regConPass= new TextField("Confirm Password","",10,TextField.PASSWORD);
 
StringItem displaytext4 = new StringItem(null, "  ***  Welcome  ***");
StringItem displaytext3 = new StringItem(null, "   ******  End  ******");
 
form3.append(displaytext4);
form3.append(regName);
form3.append(regGender);
form3.append(regUsername);
form3.append(regPass);
form3.append(regConPass);
form3.append(displaytext3);
form3.addCommand(okCommand);
form3.addCommand(backCommand);
form3.setCommandListener(this);
 
//*****************  form3_S   *********************************************************
 
form3_S = new Form("Register Success");
 
StringItem displaytext3_S = new StringItem(null,"Thank You for your Register.");
 
form3_S.append(displaytext3_S);
form3_S.addCommand(nextCommand);
form3_S.setCommandListener(this);
 
//*****************  form3_F   *********************************************************
 
form3_F = new Form("Fail to Register");
 
StringItem displaytext3_F = new StringItem(null,"Please try again.");
 
form3_F.append(displaytext3_F);
form3_F.addCommand(backCommand);
form3_F.setCommandListener(this);
 
//***************  form4   ************************************************************
 
form4 = new Form("Exist patient info,");
 
 
form4.addCommand(newPatientCommand);
form4.addCommand(exitCommand);
form4.setCommandListener(this);
 
 
 
//***************  form5   ************************************************************
 
form5 = new Form("New Patient Information");
 
newName= new TextField("Enter Name","",40,TextField.ANY);
newDate= new TextField("Enter Date","",20,TextField.ANY);
newTime= new TextField("Enter Time","",20,TextField.ANY);
newPlace= new TextField("Enter Place","",40,TextField.ANY);
newRemark= new TextField("Important information to take note","",300,TextField.ANY);
 
form5.append(newName);
form5.append(newDate);
form5.append(newTime);
form5.append(newPlace);
form5.append(newRemark);
form5.addCommand(okCommand);
form5.addCommand(backCommand);
form5.setCommandListener(this);
 
//***************  form7   ************************************************************
 
form7 = new Form("xxx");
 
//System.out.println("Date of the next appointment: ");
//System.out.println("Time of the next appointment: ");
//System.out.println("Location for the next appointment: ");
//System.out.println("Important information to take note of: ");
 
form7.addCommand(updateCommand);
form7.addCommand(backCommand);
form7.setCommandListener(this);
 
//***************  form8   ************************************************************
 
form8 = new Form("Update xxx");
 
editDate= new TextField("Edit Date","",20,TextField.ANY);
editTime= new TextField("Edit Time","",20,TextField.ANY);
editPlace= new TextField("Edit Place","",40,TextField.ANY);
editRemark= new TextField("Edit important information to take note","",300,TextField.ANY);
 
form8.append(editDate);
form8.append(editTime);
form8.append(editPlace);
form8.append(editRemark);
form8.addCommand(okCommand);
form8.addCommand(backCommand);
form8.setCommandListener(this);
 
}
 
public void destroyApp(boolean unconditional){}
 
public void pauseApp(){}
 
public void commandAction(Command c,Displayable db)
{
 
processStringBuffer();
 
if(form.isShown()==true){
if(c==signinCommand)
{
 
display.setCurrent(form2);
}
else if(c==registerCommand)
{
display.setCurrent(form3);
}
}
 
if(form2.isShown()==true){
if(c==okCommand){
if(pwd.getString().equals("a") && strItem.getString().equals("a"))
{
processStringBuffer();
 
display.setCurrent(form4);
}
else{
display.setCurrent(form6);
}
}
}
 
if(form3.isShown()==true){
if(c==okCommand)
{System.out.println(" form3 ok");
if(regName.getString().equals("bb"))
{
display.setCurrent(form3_S);
}
else
{
display.setCurrent(form3_F);
}
}
else if(c==backCommand)
{
display.setCurrent(form);
}
}
 
if(form3_S.isShown()==true){
if(c==nextCommand)
{
display.setCurrent(form4);
}
}
 
if(form3_F.isShown()==true){
if(c==backCommand)
{
display.setCurrent(form3);
}
 
}
 
if(form4.isShown()==true){
if(c==newPatientCommand)
{
display.setCurrent(form5);
}
else{
 
destroyApp(true);
notifyDestroyed();
}
 
 
}
 
if(form5.isShown()==true){
if(c==okCommand)
{
display.setCurrent(form7);
}
else{
 
display.setCurrent(form4);
}
}
 
if(form6.isShown()==true){
 
display.setCurrent(form2);
 
}
 
if(form7.isShown()==true){
if(c==updateCommand)
{
display.setCurrent(form8);
}
else{
 
display.setCurrent(form4);
}
 
}
 
if(form8.isShown()==true){
if(c==okCommand)
{
display.setCurrent(form7);
}
else{
 
display.setCurrent(form7);
}
 
}
 
 
 
/*
if(c==backCommand)
{
display.setCurrent(form2);
display.setCurrent(form);
display.setCurrent(form);
}
if(c==okCommand)
{
if(currentForm==2){
if(pwd.getString().equals("a") && strItem.getString().equals("a"))
{
display.setCurrent(form4);
}
else{
display.setCurrent(form6);
}
}
 
 
}
 
*/
 
 
if(c==exitCommand)
{
destroyApp(true);
notifyDestroyed();
}
 
 
 
/*if(pwd.getString().equals("123") && strItem.getString().equals("sheng") )
{
if(c==okCommand)
{
display.setCurrent(new ColorCal());
}
 
else
}
else if(c==backCommand)
{
display.setCurrent(form);
}
 
else
{
display.setCurrent(form2);
}*/
}
 
 
private StringBuffer getViaHttpConnection(String url) throws IOException{
StringBuffer sbuf = new StringBuffer();
HttpConnection c = null;
InputStream is = null;
try {
  c = (HttpConnection)Connector.open(url);
  is = c.openInputStream();
 
  int len = (int)c.getLength();
  if (len > 0) {//check to see if len is bigger than "0"
      int ch;//initial ch
      for (int i = 0 ; i < len ; i++){//using for loop
        if ((ch = is.read()) != -1)//check to see if ch is not equal to -1
          sbuf.append((char)ch);//print ch
      }
  } else {
      int ch;
      while ((ch = is.read()) != -1) {
        sbuf.append((char)ch);
      }
  }
} finally {
   if (is != null)//check if not equal to null
      is.close();
   if (c != null)
      c.close();
   return sbuf;
}
}
/*******************************************/
 
    public String encodeURL(String name) {
 
  StringBuffer encodedUrl = new StringBuffer(); // Encoded URL
        int len = name.length();
        // Encode each URL character
        for(int i = 0; i < len; i++) {
            char x = name.charAt(i); // Get next character
 
            if ((x >= '0' && x <= '9') ||(x >= 'a' && x <= 'z') ||(x >= 'A' && x <= 'Z')||(x == ':' && x == '.'))
             encodedUrl.append(x);
 
            else {
                    encodedUrl.append("%20");//manual spacing for URL
            }
        }
        //name = encodedUrl.toString(); // Return encoded URL
        return encodedUrl.toString();
 
}
 
 
/*******************************************/
 
private void processStringBuffer(){
  for (int j=0, n=display_Username.length(); j < n; j++) {
  System.out.print("processStringBuffer");
   /// display_Username.delete(0);
  }
  String tmp = "";
  int l = sb.length();
  for (int i=0; i<l; i++){//for loop
    if (sb.charAt(i)==';'){
      display_Username+=tmp;
       System.out.print("display_Username" + display_Username);
      tmp="";
    }
    else {
      tmp=tmp+sb.charAt(i);
    }
    form4.setTicker(new Ticker(" Welcome,"+display_Username+"!!!"));
   }
 }
}
 
 
 
 
 
 
InformationServlet.java(this is my servlet file)
 
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
 
/**
 * My test servlet
 *
 * @author Liz Warner
 */
 
public class InformationServlet extends HttpServlet {
 
 
    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
 
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
 
        String DBUrl = "jdbc:mysql:///user_info";
        Connection conn = null;
        Statement stmt = null;
        String str = null;
 
        try
        {
            try
            {
               //create a new instance of the mysql driver
               Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            }
            catch (Exception Ex)
            {
                out.println("Unable to Load Driver: " + Ex.toString() + "<br>");
            }
// get a new connection object
            conn = DriverManager.getConnection(DBUrl);
            // get a new statement object
            stmt = conn.createStatement();
            // and execute a simple query
            ResultSet rs = stmt.executeQuery("SELECT * from u_detail");
 
            while (rs.next())
            {
                // iterate through the result set and print
                // the query results to the page
                str += (rs.getString("u_name")+";");
            }
 out.println(str);
        }
        catch (SQLException sqlEx)
        {
                out.println("Caught SQL Exception: " + sqlEx.toString() + "<br>");
        }
 
        // now close the statement and connection if they exist
        if (stmt != null)
        {
            try
             {
                 stmt.close();
             }
            catch (SQLException sqlEx)
            {
                out.println("Could not close: " + sqlEx.toString() + "<br>");
            }
        }
        if (conn != null)
        {
                try
                {
                        conn.close();
                }
                catch (SQLException sqlEx)
                {
                        out.println("Could not close: " + sqlEx.toString() + "<br>");
                }
        }
        out.println("</body>");
        out.println("</html>");
    }
}

As for my database, my database is user_info.mdb
Inside it have 2 tables(p_detail, u_detail)

table 1: p_detail
with: id, p_name, p_date, p_time, p_place and p_remark

table 2: u_detail
with: id, u_name, gender, username, pwd

I'm not very sure whether i post in the right topic.. but i hope someone can really help me..
[ September 06, 2005: Message edited by: Mark Spritzler ]

[Mark Spritzler]

We have a "CODE" tag, that can be created by clicking the CODE button,
which is located under the "Add Reply" button, along with URL, BOLD, etc. buttons

This tag will enable you to keep your formatting for your code, like indentation, and makes your code readable.
The way your code is posted makes it difficult to read, and therefore, more difficult for us to help you.

Thanks

Mark

[Mark Spritzler]

First, I am going to move this to the J2ME forum. Not that this forum wouldn't be able to help, but I feel J2ME is a better forum for this post.

Second. What is your question?

Mark