java – 使用mysql的jdbc连接
发布时间:2020-12-15 02:24:51 所属栏目:Java 来源:网络整理
导读:import java.sql.*; public class MysqlConnect{ public static void main(String[] args) { System.out.println("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "sint"; String driver
import java.sql.*; public class MysqlConnect{ public static void main(String[] args) { System.out.println("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "sint"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "najeer"; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url+dbName,userName,password); System.out.println("Connected to the database"); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { e.printStackTrace(); } } } 所有 c:/>java MysqlConnect.java C:&;java -cp .;locallibmysql-connector-java-5.1.15-bin.jar MysqlConnect MySQL Connect示例. Exception in thread "main" java.lang.NoClassDefFoundError: java/sql/SQLClientInf oException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.mysql.jdbc.ConnectionImpl.<clinit>(ConnectionImpl.java:270) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :305) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at MysqlConnect.main(MysqlConnect.java:15) 发生此类型错误 解决方法
如果你可以在类路径中包含rt.jar,那么异常就会消失.
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |