J2ME开发MIDLet与JAVAEE之Servlet交互详解

《J2ME开发MIDLet与JAVAEE之Servlet交互详解》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、MIDLet与JAVAEE之Servlet交互详解一、总体介绍通过J2ME的MIDP访问JAVAEE下的Servlet，解决相互之间的参数传递，Servelt访问Access数据库并返回结果集，可以扩展到任何关系数据库。二、环境搭建1、eclipseme.feature_1.7.9_site.zip2、WTK2.5.23、Eclipse3.3三、创建服务端Servletpackagesalary;importjava.io.BufferedOutputStream;importjava.io.DataOutputStream;i

2、mportjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet

3、.http.HttpServletResponse;publicclassServletSalaryextendsHttpServlet{publicvoidinit()throwsServletException{}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//设置返回的类型response.setContentType("text/html;charset=

4、gb2312");DataOutputStreamout=newDataOutputStream(newBufferedOutputStream(response.getOutputStream()));//获取手机传来的查询参数salaryidStringsalaryid=request.getParameter("salaryid");Connectionconnection=null;Statementstatement=null;ResultSetrs=null;try{Class.forName("sun.jdbc.o

5、dbc.JdbcOdbcDriver");Stringdbpath=Thread.currentThread().getContextClassLoader().getResource("AIMS.mdb").getPath();System.out.println("dbpath:"+dbpath.substring(1));Stringurl="jdbc:odbc:Driver={MicroSoftAccessDriver(*.mdb)};DBQ="+dbpath.substring(1);connection=Driver

6、Manager.getConnection(url,"admin","admin");//创建statement对象statement=connection.createStatement();//查询Stringsql="select*fromt_xswcwherexh='"+salaryid+"'";System.out.println("sql:"+sql);Stringok="fail";rs=statement.executeQuery(sql);if(rs.next()){ok="find";out.writeUTF

7、(ok);out.writeUTF("------------------------");out.writeUTF("产品序号:"+rs.getString("xh"));out.writeUTF("系统编号:"+rs.getString("xtbh"));out.writeUTF("客户名称:"+rs.getString("khmc"));out.writeUTF("产品名称:"+rs.getString("cpmc"));out.writeUTF("------------------------");//获取查询结果}e

8、lse{//若客户端输入的salaryid参数在表user中不存在，则提示用户查询失败out.writeUTF(ok);Stringerrormessage="编号："+salaryid+"不存在";out.writeUTF(errormessage);}out