eclipse平台连接mysql数据库,Eclipse连接MySQL数据库

右键项目，选中Build Path，选中configure build path，把lib目录下的jar包加入路径。

程序代码：

package com.test;

import java.sql.*;//引入包

public class MysqlConnTest {

public MysqlConnTest() {

status = -1;

setConnection( null);

try {

Class. forName( "com.mysql.jdbc.Driver"); //加载驱动

setConnection(DriverManager. getConnection( "jdbc:mysql://localhost:3306/test", "root", "123456")); //建立连接

} catch (Exception e) {

e.printStackTrace();

}

status = 1;

}

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

MysqlConnTest instance = new MysqlConnTest();

if ( instance.getStatus() == 1) {

//状态准备好了

instance.TestWrite();

instance.TestRead();

instance.getConnection().close();

}

}

//测试写程序

public void TestWrite() throws SQLException{

PreparedStatement statement = getConnection().prepareStatement("insert into test(name) values ('hello')");

statement.executeUpdate();

}

//测试读程序

public void TestRead() throws SQLException{

PreparedStatement statement = getConnection().prepareStatement("select * from test" );

ResultSet result = statement.executeQuery();

while( result.next()){

System. out.println( "id = " + result.getInt(1) +",name = " + result .getString(2));

}

result.close();

}

private int status;

private Connection connection;

public int getStatus(){

return status;

}

public void setStatus( int status){

this. status = status;

}

public Connection getConnection() {

return connection;

}

public void setConnection(Connection connection) {

this. connection = connection;

}

}

SQL文件：

CREATE DATABASE IF NOT EXISTS `test`;

USE `test`;

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(45) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

运行结果：

THE END

Eclipse连接MySQL数据库

标签：java   mysql

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://blog.csdn.net/some_times/article/details/46315739