mysql的jdbc案例_通过JDBC连接MySQL的学习案例

注意先要确保电脑中安装了mysql-connector-java，由于我在linux平台下开发，故安装方法如下：

解压下载的数据包：tar -zxvf mysql-connector-java-5.1.29.tar.gz

配置JDBC：cpmysql-connector-java-5.1.29-bin.jar /usr/lib/jvm/java-1.7.0-openjdk-i386/jre/lib/ext/

即可完成！

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class ConnectMysql {

public static void main(String[] args) throws SQLException, ClassNotFoundException {

//访问Mysql的jdbc驱动

Class.forName("com.mysql.jdbc.Driver");

System.out.println("Driver loaded");

String sql=null;

ResultSet resultSet=null;

Statement statement=null;

Connection connection = DriverManager.getConnection("jdbc:mysql://"

+ "localhost/db1"

,"root","password");

System.out.println("Mysql connected successfully!");

//执行MySQL语句

sql="insert tb1 values(default,'zw','zw',24,1)";

statement = connection.createStatement();

statement.executeUpdate(sql);

sql="select * from tb1";

resultSet =     statement.executeQuery("select * from tb1");

//输出查找结果

System.out.println("tb1 data as follows:");

while(resultSet.next()) {

System.out.println(resultSet.getString(1)+"\t"+resultSet.getString(2)+"\t"+resultSet.getString(3)+"\t"

+resultSet.getString(4)+"\t"+resultSet.getString(5));

}

connection.close();

}

}