eclipse上,服务器tomcat9.0,mysql用户名密码登录正常,按网上教程呢,权限给了%
报错:
代码:
package com.DBTool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
import com.mysql.jdbc.Driver;
public class DBUtil {
private static String url="jdbc:mysql://localhost:3306/stuffinf";
private static String driverClass="com.mysql.jdbc.Driver";
private static String username="root";
private static String password="123456";
private static Connection conn;
//装载驱动
static{
try{
//加载驱动程序
Class.forName(driverClass);
System.out.println("加载驱动");
}
catch(ClassNotFoundException e){
System.out.println("无法加载驱动");
e.printStackTrace();
}
}
//获取数据库连接
public static Connection getConnection(){
try{
conn = DriverManager.getConnection(url,username,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
}
catch(SQLException e){
e.printStackTrace();
System.out.println("连接失败");
}
return conn;
}
//建立数据库连接
public static void main(String[] args){
Connection con=DBUtil.getConnection();
if(conn==null){
System.out.println("数据库连接失败!");
}
else
{
System.out.println("数据库连接成功!");
}
}
//关闭数据库连接
public static void Close(){
if(conn!=null){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
}
报错:
代码:
package com.DBTool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
import com.mysql.jdbc.Driver;
public class DBUtil {
private static String url="jdbc:mysql://localhost:3306/stuffinf";
private static String driverClass="com.mysql.jdbc.Driver";
private static String username="root";
private static String password="123456";
private static Connection conn;
//装载驱动
static{
try{
//加载驱动程序
Class.forName(driverClass);
System.out.println("加载驱动");
}
catch(ClassNotFoundException e){
System.out.println("无法加载驱动");
e.printStackTrace();
}
}
//获取数据库连接
public static Connection getConnection(){
try{
conn = DriverManager.getConnection(url,username,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
}
catch(SQLException e){
e.printStackTrace();
System.out.println("连接失败");
}
return conn;
}
//建立数据库连接
public static void main(String[] args){
Connection con=DBUtil.getConnection();
if(conn==null){
System.out.println("数据库连接失败!");
}
else
{
System.out.println("数据库连接成功!");
}
}
//关闭数据库连接
public static void Close(){
if(conn!=null){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货