package com.javakc.book.one;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import
javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import
javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.javakc.dao.entity.Dept;
import
com.javakc.gaoming.jdbc.utils.Jdbc;
@WebServlet("/bb.do")
public class BbServlet extends
HttpServlet {
private
static final long serialVersionUID = 1L;
protected
void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
this.doPost(request,
response);
}
protected
void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
List
depts = new ArrayList<>();
try
(Connection conn = Jdbc.getConnection("aaa", "aaa");
PreparedStatement
stmt = conn.prepareStatement("select * from dept");
ResultSet
rs = stmt.executeQuery();) {
while
(rs.next()) {
Dept
dept = new Dept();
dept.setDeptno(rs.getBigDecimal("deptno"));
dept.setDname(rs.getString("dname"));
dept.setLoc(rs.getString("loc"));
depts.add(dept);
}
}
catch (SQLException e) {
e.printStackTrace();
}
for
(Dept dept : depts) {
response.getWriter().write(dept
+ "
");
}
}
}
|