连接数据库只能使用后台语言,我是用javaweb中的servlet文件,上传到tomcat服务器中,就会生成一个url地址,在前端就能用该url地址访问数据库的内容。
package com.servlet.cqust;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
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 DatabaseAccess
*/
@WebServlet("/DatabaseAccess")
public class DatabaseAccess extends HttpServlet {
private static final long serialVersionUID = 1L;
//1、MySQL 8.0 以下版本 - JDBC驱动名(这是固定的)及数据库 URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/test";
//2、数据库的用户名与密码,需要根据自己的设置,mysql没有密码,就直接写空字符串
static final String USER = "root";
static final String PASS = "";
/**
* @see HttpServlet#HttpServlet()
*/
public DatabaseAccess() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection conn=null;
Statement stmt=null;
//3、设置响应内容类型
response.setContentType("text/html;charset=UTF-8");
PrintWriter out=response.getWriter();
String title="Servlet Mysql 测试 Teacher";
String docType = "<!DOCTYPE html>\n";
out.println(docType +
"<html>\n" +
"<head><title>" + title + "</title></head>\n" +
"<body bgcolor=\"#f0f0f0\">\n" +
"<h1 align=\"center\">" + title + "</h1>\n");
try {
//4、加载数据库驱动程序
Class.forName("com.mysql.jdbc.Driver");
//5、利用一个连接符号串,打通一个连接
conn=DriverManager.getConnection(DB_URL, USER, PASS);
//6、创建数据库操作对象
stmt = conn.createStatement();
String sql;
sql = "SELECT * FROM table_teacher";
ResultSet rs = stmt.executeQuery(sql);//执行数据库查询语句
// 7、处理执行结果
while(rs.next()){
// 7.1通过字段检索
String tname = rs.getString("tname");
String tno = rs.getString("tno");
// 7.2输出数据
out.println("老师名称: " + tname);
out.println(", 老师工号: " + tno);
out.println("<br />");
}
out.println("</body></html>");
// 7.3释放资源,关闭对象的次序与创建对象的次序正相反
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){
se2.printStackTrace();
}
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}
}
}
/**
* @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);
}
}
只要run on server
就可以通过在uni-app中的请求,访问到数据库中的内容,后期再在servlet中进行相关的逻辑操作。