idea配置Tomcat并测试数据库连接

先New一个Project

把mysql的jar包导入到Tomcat的lib目录下

创建数据库

create databases cs;
use cs;
create table bmxx(
	bmbh char(8),
	bmmc char(4)
);
insert bmxx into valuse ("1001","业务");
insert bmxx into valuse ("1002","技术");
insert bmxx into valuse ("1003","售后");
insert bmxx into valuse ("1004","管理");

index.jsp测试数据库连接代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>


    
    



<%

    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/cs?";
    String user = "root";
    String password="686483";
    Connection conn = null;
    try{
        conn = DriverManager.getConnection(url,user,password);
        System.out.println("ok!!");
        Statement stmt = conn.createStatement();
        String command = "select * from bmxx";
        ResultSet rs = stmt.executeQuery(command);
        while (rs.next()){
            System.out.print(rs.getInt(1)+" ");
            System.out.println(rs.getString(2));
        }
    }catch(Exception e){
        e.printStackTrace();
    }
%>

pom.xml的依赖项

    4.0.0

    com.example
    demo1
    1.0-SNAPSHOT
    demo1
    war

    
        1.8
        1.8
        5.7.1
    

    
        
            mysql
            mysql-connector-java
            8.0.25 
        
        
            javax.servlet
            javax.servlet-api
            4.0.1
            provided
        
        
            org.junit.jupiter
            junit-jupiter-api
            ${junit.version}
            test
        
        
            org.junit.jupiter
            junit-jupiter-engine
            ${junit.version}
            test
        
    

    
        
            
                org.apache.maven.plugins
                maven-war-plugin
                3.3.1
            
        
    

运行结果