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

MIDLet与JAVAEE之Servlet交互详解 一、总体介绍 通过J2ME的MIDP访问JAVAEE下的Servlet，解决相互之间的参数传递，Servelt访问Access数据库并返回结果集，可以扩展到任何关系数据库。 二、环境搭建 1、eclipseme.feature_1.7.9_site.zip 2、WTK 2.5.2 3、Eclipse3.3 三、创建服务端Servlet package salary; import java.io.BufferedOutputStream; import java.io.DataOutputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class ServletSalary extends HttpServlet { public void init() throws ServletException { } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 设置返回的类型 response.setContentType(text/html; charset=gb2312); DataOutputStream out = new DataOutputStream(new BufferedOutputStream(response.getOutputStream())); // 获取手机传来的查询参数salaryid String salaryid = request.getParameter(salaryid); Connection connection = null; Statement statement = null; ResultSet rs = null; try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String dbpath = Thread.currentThread().getContextClassLoader().getResource(AIMS.mdb).getPath(); System.out.println(dbpath: + dbpath.substring(1)); String url = jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ= + dbpath.substring(1); connection = DriverManager.getConnection(url, admin, admin); // 创建statement对象 statement = connection.createStatement(); // 查询 String sql = select * from t_xswc where xh = + salaryid + ; System.out.println(sql: + sql); String ok = fail; rs = statement.executeQuery(sql); if (rs.next()) { ok = find; out.writeUTF(ok); out.writeUTF(------------------------); out.writeUTF(产品序号: + rs.getString(xh)); out.writeUTF(系统编号: + rs.getString(xtbh)); out.writeUTF(客户名称: + rs.getString(khmc)); out.writeUTF(产