Java连接MySQL方法

来源：互联网发布：硬盘录像机数据恢复编辑：程序博客网时间：2024/05/21 10:10

首先，MySQL肯定是要安装的，然后呢，下载一个关键驱动：mysql-connector-java-5.1.20-bin.jar;

注意要在程序里面，把这个库引用进来：

import java.sql.*;public class Main {/** * @author ZJC * Java连接MySQL示例 *///mysql配置时的用户名static String userName = "root";//mysql配置时的密码static String Password = "643872dx";private static String driverName = "com.mysql.jdbc.Driver";//url指向要访问的数据库名mydbstatic private String url = "jdbc:mysql://127.0.0.1:3306/mydb";static Connection dbConn;public static void main(String[] args) {// TODO Auto-generated method stubSystem.out.println("dwfewf");Connection temp = OpenDB();}static Connection OpenDB(){try{//加载驱动程序Class.forName(driverName);dbConn = DriverManager.getConnection(url,userName,Password);if(!dbConn.isClosed())System.out.println("success!");// statement用来执行SQL语句Statement statement = dbConn.createStatement();// 要执行的SQL语句ResultSet rs = statement.executeQuery("select * from mydb");System.out.println("dqd");while(rs.next()){System.out.println(rs.getString("id"));}System.out.println("dhwed");//数据库切换rs = statement.executeQuery("use test_navi");rs = statement.executeQuery("select * from test_navi");while(rs.next()){System.out.println(rs.getString("attack"));}}catch(Exception e){System.out.print(e);}return dbConn;}}

运行结果：

0 0