我重装了tomcat,重新导入了项目又再将我修改的添加进去,运行时报tomcat异常,所以应当不是环境问题
访问数据库按照MVC形式,数据显示在getData.jsp中,servlet为GetDServlet.java,
实现从数据库中取数据的类为getD.java,数据表对应的类为inemo_bean,
下面贴代码:
package Servlet;
import java.io.IOException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
//import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.Bean.inemo_bean;
/**
-
Servlet implementation class GetDataServlet
*/
@WebServlet("/GetDataServlet")
public class GetDServlet extends HttpServlet {
private static final long serialVersionUID = 1L;/**
- @see HttpServlet#HttpServlet() */ public GetDServlet() { super(); }
/**
- @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
- response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.getWriter().append("Served at: ").append(request.getContextPath()); GetD gd = new GetD(); ArrayList al = gd.getArrayList(); request.setAttribute("al", al); System.out.println("GetDataServlet.doGet()"); }
/**
- @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
- response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); System.out.println("GetDataServlet.doPost()"); }
}
package Servlet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.Bean.inemo_bean;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
import com.scut.older.db.DB;
/**
- Servlet implementation class getData
-
*/
public class GetD {private Statement st = null;
private ResultSet rs = null;
private Connection ct = null;public ArrayList getArrayList() {
ArrayList<inemo_bean> al = new ArrayList<inemo_bean>(); String sql = "select * from sensor_data_inemo"; ct = (Connection) new DB().getConn(); st = (Statement) new DB().getStatement(ct); rs = (ResultSet) new DB().getResultSet(st, sql); try { while (rs.next()) { inemo_bean ib = new inemo_bean(); ib.setId_sensor_data_iNEMO(rs.getInt("id_sensor_data_iNEMO")); ib.setDatetime(rs.getInt("datetime")); ib.setAccx(rs.getInt("accx")); ib.setAccy(rs.getInt("accy")); ib.setAccz(rs.getInt("accz")); ib.setGyrox(rs.getInt("gyrox")); ib.setGyroy(rs.getInt("gyroy")); ib.setGyroz(rs.getInt("gyroz")); ib.setMagx(rs.getInt("magx")); ib.setMagy(rs.getInt("magy")); ib.setMagz(rs.getInt("magz")); ib.setPress(rs.getInt("press")); ib.setTemp(rs.getInt("press")); ib.setAltitude(rs.getInt("altitude")); ib.setLongitude(rs.getInt("longitude")); ib.setLatitude(rs.getInt("latitude")); al.add(ib); } } catch (SQLException e) { e.printStackTrace(); System.out.println("getData.getArrayList()"); System.err.println("getdata()出错"); } finally { closeSource(); } return al;
}
private void closeSource() {
try {
if (rs != null)
rs.close();
if (st != null)
st.close();
if (ct != null)
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}public GetD() {
super();
}
}
<%@page import="com.Bean.inemo_bean"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Data from inemo
Get Data From DataBase -sensor_inemo_data
<%
ArrayList al = (ArrayList)request.getAttribute("al");
%>
id_sensor_data_iNEMO | datetime | accx | accy | accz | gyrox | gyroy | gyroz | magx | magy | magz | press | temp | altitude | longitude | latitude |
<%=inemo.getId_sensor_data_iNEMO()%> | <%=inemo.getDatetime()%> | <%=inemo.getAccx()%> | <%=inemo.getAccy()%> | <%=inemo.getAccz()%> | <%=inemo.getGyrox()%> | <%=inemo.getGyroy()%> | <%=inemo.getGyroz()%> | <%=inemo.getMagx()%> | <%=inemo.getMagy()%> | <%=inemo.getMagz()%> | <%=inemo.getPress()%> | <%=inemo.getTemp()%> | <%=inemo.getAltitude()%> | <%=inemo.getLongitude()%> | <%=inemo.getLatitude()%> |