建库之前要先打开cmd,用管理员形式打开,
解决mysql不是内部或外部命令:
https://jingyan.baidu.com/article/f7ff0bfc169a2a2e27bb1365.html
解决Mysql 的Access denied for user'root'@'localhost' (using password: NO)问题: (忘记密码问题)
https://blog.youkuaiyun.com/fores_t/article/details/92085383
建立连接—库—表
与mysql连接
1、index.jsp
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="gb2312">
<title>Insert title here</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/book?user=root&password=root&characterEncoding=gb2312");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from student");
rs.last();
%>
本表共有
<%out.print(rs.getRow()); %>条记录
<table border=1>
<tr><td>id</td><td>name</td><td>price</td></tr>
<%rs.first();
while(rs.next()){
%>
<tr>
<td><%=rs.getString("id") %></td>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("price") %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
12行中的book代表库,user和password是建立连接时填写的
14行中的student代表库的表
要记得把jar包import进来
jar包是放在lib下的