构建专属于自己的云图库，事件分发源码

List userList = null;

try {

conn = jdbcutils.getConn();

userList = runner.query(conn, sql, new BeanListHandler(ImageBean.class));

} catch (Exception e) {

e.printStackTrace();

} finally {

jdbcutils.tryClose(null, conn);

}

return userList;

}

public static ClassBean getCLass(String classid) {

String sql = “Select * From classinfo where id=” + classid;

QueryRunner runner = new QueryRunner();

Connection conn = null;

List userList = null;

try {

conn = jdbcutils.getConn();

userList = runner.query(conn, sql, new BeanListHandler(ClassBean.class));

} catch (Exception e) {

e.printStackTrace();

} finally {

jdbcutils.tryClose(null, conn);

}

ClassBean bean = null;

for (ClassBean item : userList) {

bean = item;

}

return bean;

}

public static void SaveWork(Map<String, String> dataMap) {

// TODO Auto-generated method stub

Connection conn = null;

PreparedStatement pstmt = null;

String classid = String.valueOf(dataMap.get(“classid”));

String filename = String.valueOf(dataMap.get(“filename”));

String filepath = String.valueOf(dataMap.get(“filepath”));

StringBuffer insertSQL = new StringBuffer();

insertSQL.append(“Insert Into image(”);

insertSQL.append(“classid,filepath,imagename”);

insertSQL.append(") values(");

insertSQL.append("?,?,? ");

insertSQL.append(")");

try {

conn = jdbcutils.getConn();

pstmt = conn.prepareStatement(insertSQL.toString());

// 为SQL语句?进行赋值的操作。

pstmt.setString(1, classid);

pstmt.setString(2, filepath);

pstmt.setString(3, filename);

// 执行SQL语句。

pstmt.executeUpdate();

} catch (Exception e) {

e.printStackTrace();

} finally {

jdbcutils.tryClose(pstmt, conn);

}

}

}

3，servlet代码（主要做数据的处理以及响应）

package servlet;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.io.PrintWriter;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.ServletContext;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.fileupload.FileItemFactory;

import org.apache.commons.fileupload.FileUploadException;

import org.apache.commons.fileupload.disk.DiskFileItem;

import org.apache.commons.fileupload.disk.DiskFileItemFactory;

import org.apache.commons.fileupload.servlet.ServletFileUpload;

import android.Bean.ClassBean;

import android.Bean.ImageBean;

import utils.WebUtil;

import utils.jdbcutils;

/**

• Servlet implementation class ClassServlet

*/

public class ClassServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doPost(request, response);

}

/**

• @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse

•  response)
  

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding(“utf-8”);

response.setCharacterEncoding(“utf-8”);

response.setContentType(“text/html;charset=UTF-8”);

String task = request.getParameter(“task”);

if (task.equals(“select”)) {

//挑选出类别

this.doSelect(request, response);</