基于Maven创建Javeweb。
ServIet/JSP实现网页。
在java web程序中使用JDBC访问数据库构建html。
我可以为您提供以下步骤来基于Maven创建Java web程序并使用Servlet/JSP访问数据库:
下面是一个使用JDBC访问MySQL数据库并生成HTML表格的示例代码,供您参考:
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class MainServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private static final String DB_URL = "jdbc:mysql://localhost:3306/test1";
private static final String DB_USERNAME = "root";
private static final String DB_PASSWORD = "";
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM books");
ResultSet rs = pstmt.executeQuery();
StringBuilder html = new StringBuilder("<html><body><table>");
html.append("<tr><th>ID</th><th>Title</th><th>Author</th></tr>");
while (rs.next()) {
int id = rs.getInt("id");
String title = rs.getString("title");
String author = rs.getString("author");
html.append("<tr><td>").append(id).append("</td><td>").append(title).append("</td><td>")
.append(author).append("</td></tr>");
}
html.append("</table></body></html>");
response.getWriter().write(html.toString());
rs.close();
pstmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
这个Servlet通过JDBC从MySQL数据库中检索书籍数据,然后生成HTML表格并将其写入HTTP响应。您可以使用类似的方式来访问和生成其他类型的数据。