在myEclipse中用JDBC连接MySQL数据库，用Java文件怎么写？

Question

如题所述

Answer 1

首先导入驱动jar包，程序是\x0d\x0apackage test;\x0d\x0a\x0d\x0aimport java.sql.Connection;\x0d\x0aimport java.sql.DriverManager;\x0d\x0aimport java.sql.SQLException;\x0d\x0a\x0d\x0apublic class connectionMySql {\x0d\x0aprivate static Connection connection;\x0d\x0astatic{\x0d\x0aString driver="com.mysql.jdbc.Driver";\x0d\x0aString url="jdbc:mysql://localhost:3306/purview";\x0d\x0atry {\x0d\x0aClass.forName(driver);\x0d\x0a} catch (ClassNotFoundException e) {\x0d\x0a// TODO Auto-generated catch block\x0d\x0aSystem.out.print("加载驱动失败");\x0d\x0ae.printStackTrace();\x0d\x0a}\x0d\x0atry {\x0d\x0aconnection=DriverManager.getConnection(url, "root", "root");\x0d\x0a} catch (SQLException e) {\x0d\x0a// TODO Auto-generated catch block\x0d\x0ae.printStackTrace();\x0d\x0a}\x0d\x0a\x0d\x0a}\x0d\x0apublic static Connection getConnection() {\x0d\x0areturn connection;\x0d\x0a}\x0d\x0apublic static void main(String [] args) {\x0d\x0aConnection con=connectionMySql.getConnection();\x0d\x0aif(!con.equals("")){\x0d\x0aSystem.out.print("数据库连接成功，连接id是:"+con);\x0d\x0a\x0d\x0a}\x0d\x0a}\x0d\x0a\x0d\x0a}