javaweb

Java 如何使用 JDBC 连接 MySQL 数据库,下面我们看看

下载驱动包

Java 连接 MySQL 需要驱动包，官网下载地址为MySQL驱动包官网下载
还是建议大家下载以前的版本

通过build path导入

右键项目名，点击Build path—Configure Build Path…-----Propertise ，在java build path中的Libraries分页中点击Classpath选择Add JARs…，选择我们要添加的jar包导入，Apply----Apply and Close即可，如下图：

通过NAVicat新建一个数据表：

rtu表代码：

CREATE TABLE `rtu` (
`id` int(10) NOT NULL,
`zhanghao`varchar(20) NOT NULL,
`mima` varchar(20) NOT NULL,
`xingming` varchar(8) DEFAULT NULL,
`xingbie` varchar(30) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

连接数据库：

package diyc.w;

import java.beans.Statement;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/MysqlJdbc")
public class MysqlJdbc extends HttpServlet {
ResultSet rs = null;

public static void main(String args[]) {
try {
Class.forName("com.mysql.cj.jdbc.Driver"); // 加载MYSQL JDBC驱动程序

System.out.println("Success loading Mysql Driver!");
} catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try {
Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1", "root", "1234");
// 连接URL为 jdbc:mysql//服务器地址/数据库名，后面的2个参数分别是登陆用户名和密码

System.out.println("Success connect Mysql server!");

Statement stmt = (Statement) connect.createStatement();
ResultSet rs = ((java.sql.Statement) stmt).executeQuery("select * from rtu");
//rtu为你表的名称
while (rs.next()) {
System.out.println(rs.getString("name"));
}
} catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}

}

登录页面Ner.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html"; charset="UTF-8">
<title>登录页面</title>
<style type="text/css">
body{
text-align:center;
background:darkorchid;
line-height:30px;

}

</style>
</head>
<body>
<form action="dk.jsp" method="post">
用户名: <input type="text" name="zhanghao" >
<br>
密    码:<input type="password" name="mima"> <br>
<input type="submit" value="登录">
</form>
</body>
</html>

text-align:center;文本居中对齐
background:darkorchid;添加背景颜色
line-height:30px;两行之间的间距