测试tomcat mysql数据库连接

<!-- context.xml -->
<Context>
    <Resource name="jdbc/MyDB"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="com.mysql.cj.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/mydatabase"
              username="myuser"
              password="mypassword"
              maxTotal="20"
              maxIdle="10"
              maxWaitMillis="-1"/>
</Context>

// Java 代码示例
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.naming.InitialContext;
import org.apache.naming.NamingException;

public class DBUtil {
    private static DataSource dataSource;

    static {
        try {
            InitialContext ctx = new InitialContext();
            dataSource = (DataSource) ctx.lookup("java:comp/env/jdbc/MyDB");
        } catch (NamingException e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }
}