ling ling

Greenhorn

+ Follow

news 1 Posts 1 Threads

since Sep 05, 2005

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by ling ling

J2ME, servlet and database help..

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 ]

19 years ago

Java Micro Edition