1.javaee代码部分,创建工程,必须是Dynamic Web Project类型的工程
直接贴代码,javaee部分
package com.soft.webtoapp;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
public class HelloWorld {
JSONObject obj=null;
public String sayHello(String name){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/web08", "root", "123456");
String sql = "select * from newuser";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
List<PersonEntity> list=new ArrayList<PersonEntity>();
obj=new JSONObject();
JSONArray array=new JSONArray();
//7.遍历
while(rs.next()){
JSONObject object=new JSONObject();
object.put("uname", rs.getString("uname"));
object.put("upassword", rs.getString("upassword"));
object.put("hobby", rs.getString("hobby"));
object.put("height", rs.getString("height"));
array.add(object);
}
obj.put("list", array);
obj.put("result", "0000");
obj.put("error", "");
System.out.println(obj);
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
if (conn != null)
conn.close();
return obj.toString();
}catch(Exception e){
e.printStackTrace();
}
return obj.toString();
}
}
2.发布代码部分
1)在new 选择Other
2)选择Axis2 Service Archiver
3)选择当前工程目录下build\classes,这样才能在后面Load出方法
4)选择Skip WSDL
5)选择当前项目jar包
3.将打包的aar文件发布到tomcat服务器上
4.启动tomcat