6.在用jdbc与数据库建立连接后,在包里面创建一个servlet类
7.通过servlet类来建立java与网页的连接,从而连接数据库
package web7;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class kk
*/
@WebServlet("/kk")
//在浏览器输入http://localhost:8080/web5/kk 可进入WebServlet后台
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public UserServlet() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//request是后台服务的请求,response是后台服务的回应
//获取参数名为id的参数
String id=request.getParameter("id");
int myid=0;
if(id==null||id.equals("")){
myid=1;
}else{
//转型
myid=Integer.parseInt(id);
}
//获取id=myid的User对象
User user=DBUser.getUserById(myid);
//请求在前端设置属性user,前者是前端的user属性,后者是user对象
request.setAttribute("user",user);
//请求前台接受request,response后跳转到mypage.jsp页面
request.getRequestDispatcher("/mypage.jsp").forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
8.用MySQL创建一个数据库(这里用navicat软件进行操作)
上面的例子演示创建一个stu的数据库,然后相似的自己来创建一个introduce的数据库
笔者通过上面步骤创建成功introduce数据库并
9.建立连接后网页就可以访问数据库里面的信息
(这是mypage.jsp文件)
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1px solid black">
<tr><td>id:</td><td>${user.id }</td></tr>
<tr><td>username:</td><td>${user.username}</td></tr>
<tr><td>pic:</td><td>${user.pic }</td></tr>
<tr><td>introduce:</td><td>${user.introduce }</td></tr>
<tr><td>detail_intro:</td><td>${user.detail_intro }</td></tr>
<tr><td>href_url:</td><td>${user.href_url }</td></tr>
<tr><td>intro1:</td><td>${user.intro1 }</td></tr>
<tr><td>photo1:</td><td>${user.photo1 }</td></tr>
<tr><td>intro2:</td><td>${user.intro2 }</td></tr>
<tr><td>photo2:</td><td>${user.photo2 }</td></tr>
<tr><td>intro3:</td><td>${user.intro3 }</td></tr>
<tr><td>photo3:</td><td>${user.photo3 }</td></tr>
</table>
</body>
</html>
在浏览器上打开servlet
这样就可以实现数据从数据库传递到网页上来展示了!