MySql:eclipse连接

来源：互联网发布：Python中eval() 编辑：程序博客网时间：2024/06/06 00:55

1、在官网下载jar包，下载下来的是一个安装文件，正常点击安装就可以

2、打开Eclipse，创建一个项目，操作：右键点击my--->build Path--->add external Archiver...选择jdbc驱动，点击确定。

3、测试连接代码

<span style="color:#3333ff;">import java.sql.*;public class TestMySql {public static void main(String[] args) {Connection conn = null;Statement stmt = null;ResultSet rs = null;try {Class.forName("com.mysql.jdbc.Driver");//创建实例conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test_db","root",密码);stmt = conn.createStatement();rs = stmt.executeQuery("select * from dept");while (rs.next()) {//System.err.println(rs.getInt("id")+rs.getString("name")+rs.getInt("deptnum"));System.err.println(rs.getInt(1)+rs.getString(2)+rs.getInt(3));}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException ex) {// handle any errorsSystem.out.println("SQLException: " + ex.getMessage());System.out.println("SQLState: " + ex.getSQLState());System.out.println("VendorError: " + ex.getErrorCode());} finally {try {if(rs != null) {rs.close();rs = null;}if(stmt != null) {stmt.close();stmt = null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}</span>

0 0