菜鸟跪求，通过servlet访问jdbc把数据库内容显示在网页上，为什么我的网页上什么也没显示，下面是代码，为
importjava.io.IOException;importjava.io.PrintWriter;importjava.sql.Connection;importj...
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DeptList extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html,charset=gb2312");
request.setCharacterEncoding("gb2312");
PrintWriter out=response.getWriter();
Connection con=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/bank","root","123");
st=con.createStatement();
rs=st.executeQuery("select * from Dept");
out.println("<html>"+"<head><title>部门表信息</title></head>"+"<body>");
out.println("<h1>EmployList:</h1><br><br>");
while(rs.next())
{
out.println("部门编号:");
out.print(rs.getString(1)+"\t");
out.println("部门地址:");
out.print(rs.getString(2)+"\t");
out.println("部门人数:");
out.print(rs.getString(3)+"\t");
out.println("部门名称");
out.print(rs.getString(4)+"\t");
out.println("部门id");
out.print(rs.getString(5)+"\t");
out.println("<br>");
}
out.print("</body></html>");
out.close();
rs.close();
st.close();
con.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
原来忘了加mysql数据驱动程序在tomcat服务器中，失误 展开
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DeptList extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html,charset=gb2312");
request.setCharacterEncoding("gb2312");
PrintWriter out=response.getWriter();
Connection con=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/bank","root","123");
st=con.createStatement();
rs=st.executeQuery("select * from Dept");
out.println("<html>"+"<head><title>部门表信息</title></head>"+"<body>");
out.println("<h1>EmployList:</h1><br><br>");
while(rs.next())
{
out.println("部门编号:");
out.print(rs.getString(1)+"\t");
out.println("部门地址:");
out.print(rs.getString(2)+"\t");
out.println("部门人数:");
out.print(rs.getString(3)+"\t");
out.println("部门名称");
out.print(rs.getString(4)+"\t");
out.println("部门id");
out.print(rs.getString(5)+"\t");
out.println("<br>");
}
out.print("</body></html>");
out.close();
rs.close();
st.close();
con.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
原来忘了加mysql数据驱动程序在tomcat服务器中，失误 展开
展开全部
输出缓存输出一下，out.flush()
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
写DAO。。。把这些都写进DAO
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
看报错信息
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
有这样写的么，在servlet里面来jdbc，自己写着玩还可以
追问
本人菜鸟，请赐教，该如何添加在servlet中加jdbc
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
