my program of j2me
import java.io.*; import java.util.*; import javax.microedition.midlet.*; import javax.microedition.lcdui.*; import javax.microedition.io.*;
public class Demo extends MIDlet implements CommandListener { private String username; private String url = "http://localhost:8082/mobileDemo/DBConnection"; private Display display; private Command exit = new Command("EXIT", Command.EXIT, 1);; private Command login = new Command("Login", Command.SCREEN, 1); // private TextField tb; private Form menu; private TextField tb1; private TextField tb2; DBConn db;
public Demo() throws Exception {
display = Display.getDisplay(this);
}
public void startApp() {
displayMenu();
}
public void displayMenu() {
menu = new Form("Login Form");
tb1 = new TextField("Please input Mobile No: ","",30,TextField.ANY);
tb2 = new TextField("Please input password: ","",30,TextField.PASSWORD);
//menu.append(tb);
menu.append(tb1);
menu.append(tb2);
menu.addCommand(exit);
menu.addCommand(login);
menu.setCommandListener(this);
display.setCurrent(menu);
}
public void pauseApp() {}
public void destroyApp(boolean unconditional) {}
public void commandAction(Command command, Displayable screen) {
if (command == exit) {
destroyApp(false);
notifyDestroyed();
} else if (command == login) {
db = new DBConn(this);
db.start();
db.connectDb(tb1.getString(),tb2.getString());
}
}
public class DBConn implements Runnable {
Demo midlet;
private Display display;
// String db;
String user;
String pwd;
public DBConn(Demo midlet) {
this.midlet = midlet;
display = Display.getDisplay(midlet);
}
public void start() {
Thread t = new Thread(this);
t.start();
}
public void run() {
StringBuffer sb = new StringBuffer();
try {
HttpConnection c = (HttpConnection) Connector.open(url);
c.setRequestProperty("User-Agent","Profile/MIDP-1.0, Configuration/CLDC-1.0");
c.setRequestProperty("Content-Language","en-US");
c.setRequestMethod(HttpConnection.POST);
DataOutputStream os = (DataOutputStream)c.openDataOutputStream();
os.writeUTF(user.trim());
os.writeUTF(pwd.trim());
os.flush();
os.close();
// Get the response from the servlet page.
DataInputStream is =(DataInputStream)c.openDataInputStream();
//is = c.openInputStream();
int ch;
sb = new StringBuffer();
while ((ch = is.read()) != -1) {
sb.append((char)ch);
}
showAlert(sb.toString());
is.close();
c.close();
} catch (Exception e) {
showAlert(e.getMessage());
}
}
/* This method takes input from user like db,user and pwd and pass to servlet */
public void connectDb(String user,String pwd) {
this.user = user;
this.pwd = pwd;
}
/* Display Error On screen*/
private void showAlert(String err) {
Alert a = new Alert("");
a.setString(err);
a.setTimeout(Alert.FOREVER);
display.setCurrent(a);
}
};
}
servlet program is: import java.io.*; import java.util.*; import javax.sql.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*;
public class DBConnection extends HttpServlet {
public void init() { }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
DataInputStream in = new DataInputStream((InputStream)request.getInputStream());
String user = in.readUTF();
String pwd = in.readUTF();
response.setContentType("text/plain");
PrintWriter out = response.getWriter();
String userid=connect(user.toLowerCase().trim(), pwd.toLowerCase().trim());
if (userid == null)
{
response.sendError(response.SC_BAD_REQUEST, "Unable to locate user.");
return;
}
out.println(userid);
out.close();
in.close();
out.flush();
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
private String connect(String user,String pwd){
String db="mobileapp";
String username="root";
String password="vertrigo";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/"+db,username,password);
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM emp where username='user' and password='pwd'");
// displaying records
if(rs.next()){
return rs.getString(2);
}
else { return null; }
} catch (Exception e) {
return e.toString(); }
}
}
and xml of servlet is :
please help me its urgent for me