mysql的设置，eclipse毗连mysql数据库以及eclipse导入其它包（保姆级教程） - qidao123.com技术社区-IT企服评测·应用市场

package controller;
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 xmf
*/
@WebServlet("/xmf")
public class xmf extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public xmf() {
super();
// 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
response.getWriter().append("Served at: ").append(request.getContextPath());
}
/**
* @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);
}
}

复制代码

import java.sql.*;
public class 自己创建的名字 {
// 数据库连接信息
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/mobiledatabase（自己数据库的名字）?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
static final String USER = "自己的帐号";
static final String PASS = "自己的密码";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
// 注册 JDBC 驱动
Class.forName(JDBC_DRIVER);
// 打开连接
System.out.println("连接数据库...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
// 执行查询
System.out.println("实例化 Statement 对象...");
stmt = conn.createStatement();
String sql = "SELECT * FROM 自己数据表的名字";这里并不是一成不变的，根据自己的内容进行改变
String sq2 = "SELECT * FROM 自己数据表的名字";
ResultSet rs = stmt.executeQuery(sql);
// 展开结果集数据库
while (rs.next()) { 里面的内容根据自己数据库中的内容需要进行改变
// 通过字段检索
String mobileVersion = rs.getString("mobile_version");
String mobileName = rs.getString("mobile_name");
String mobileMade = rs.getString("mobile_made");
int mobilePrice = rs.getInt("mobile_price");
String mobileMess = rs.getString("mobile_mess");
String mobilePic = rs.getString("mobile_pic");
int id = rs.getInt("id");
// 输出数据
System.out.print("mobile_version: " + mobileVersion);
System.out.print(", mobile_name: " + mobileName);
System.out.print(", mobile_made: " + mobileMade);
System.out.print(", mobile_price: " + mobilePrice);
System.out.print(", mobile_mess: " + mobileMess);
System.out.print(", mobile_pic: " + mobilePic);
System.out.println(", id: " + id);
}
// 完成后关闭
rs.close();
stmt.close();
conn.close();
} catch (SQLException se) {
// 处理 JDBC 错误
se.printStackTrace();
} catch (Exception e) {
// 处理 Class.forName 错误
e.printStackTrace();
} finally {
// 关闭资源
try {
if (stmt != null) stmt.close();
} catch (SQLException se2) {
} // 什么都不做
try {
if (conn != null) conn.close();
} catch (SQLException se) {
se.printStackTrace();
}
}
System.out.println("Goodbye!");
}
}

复制代码