(1)我们先利用Navicat Premium软件连接数据库mysql,设计好由英文单词构成的一张表。
(2)接下来我们在E:\apache-tomcat-8.0.52\webapps\ROOT文件夹下创建.jsp文件,这里我们将其取名为findword.jsp。具体的代码内容如下:
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<%
try {
Class.forName("com.mysql.jdbc.Driver"); //驱动程序名
String url = "jdbc:mysql://localhost:3306/wu"; //数据库名
String username = "root"; //数据库用户名
String password = "root"; //用户名密码
Connection conn = DriverManager.getConnection(url, username, password);
if(conn != null){
out.print("数据库连接成功!");
out.print("<br />");
Statement stmt = null;
ResultSet rs = null;
String sql = "SELECT english,cixing,chinese FROM word where english like 'a%';"; //找出以a开头的英文单词
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
out.print("查询结果:");
out.print("<br />");
out.println("english"+" "+"cixing "+" "+"chinese");
out.print("<br />");
while (rs.next()) {
out.println(rs.getString("english")+" "+rs.getString("cixing")+" "+rs.getString("chinese"));
out.print("<br />");
}
}else{
out.print("连接失败!");
}
}catch (Exception e) {
//e.printStackTrace();
out.print("数据库连接异常!");
}
%>
(3)接下来我们先启动Tomcat服务器,然后启动MySQL数据库。