public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "000000");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from userinfo");
out.println("<html><head><title>读取数据库信息</title><head><body>");
while (rs.next()) {
out.println(rs.getString("name")+"<br/>");
}
} catch (Exception e) {
e.printStackTrace();
}
}
注意点:
1、 仔细检查连接字符串。
2、 确认有没有要操作的这个表。
3、 如果出错了,先去后台看报错信息。
①、message:java.net.connectionException:connection refused:connect-----------
确认MySQL是否启动。
②、java.lang.classnotfoundexception:om.mysql.jdbc.driver
把驱动拷贝到tomcat下的lib文件夹里。
有意者加群:108732902