html mysql servlet_html文件调用servlet连接mysql数据库实例

import java.sql.*;import java.io.*;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;

@WebServlet("/FindFootOrPk")public class FindFootOrPk extendsHttpServlet {private static final long serialVersionUID = 1L;//JDBC驱动名和数据库URL

static final String JDBC_DRIVER="com.mysql.jdbc.Driver";static final String DB_URL="jdbc:mysql://localhost:3306/dudu";//dudu数据库名称//数据库用户名和密码

static final String USER="root";static final String PASS="123456";/***@seeHttpServlet#HttpServlet()*/

publicFindFootOrPk() {super();

}/***@seeHttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {

Connection conn=null;

Statement stmt=null;//设置响应内容类型

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

PrintWriter out=response.getWriter();

String title="前后端打通,连接数据库,我的世界来啦!";//String name=request.getParameter("pk");//String link=request.getParameter("link");

String docType= "\n";

out.println(docType+

"\n" +

"

" + title + "\n" +

"

\n" +

"

" + title + "

\n");try{//注册 JDBC 驱动器

Class.forName("com.mysql.jdbc.Driver");//打开一个连接

conn =DriverManager.getConnection(DB_URL,USER,PASS);

out.println("数据库连接成功！");//执行 SQL 查询

stmt = conn.createStatement();// String sql; //foot_ball 数据库表名称

sql = "SELECT*FROM foot_ball"; //sql语句,一定要保证正确.最好测试一下,要不html不显示.

ResultSet rs = stmt.executeQuery(sql); //sql语句执行的结果//展开结果集数据库

while(rs.next()){//通过字段检索

int id = rs.getInt("id");

String tream= rs.getString("tream");

String url= rs.getString("url");//输出数据

out.println("ID: " +id);

out.println(", 球队: " +tream);

out.println(", 站点 URL: " +url);

out.println("
");

}

out.println("");//完成后关闭

rs.close();

stmt.close();

conn.close();

}catch(SQLException se) {//处理 JDBC 错误

se.printStackTrace();

}catch(Exception e) {//处理 Class.forName 错误

e.printStackTrace();

}finally{//最后是用于关闭资源的块

try{if(stmt!=null)

stmt.close();

}catch(SQLException se2){

}try{if(conn!=null)

conn.close();

}catch(SQLException se){

se.printStackTrace();

}

}

}/***@seeHttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {

doGet(request, response);

}

}