myeclipse连接到mysql主机_myeclipse连接mysql

package junit;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Date;

public class main {

public static void main(String[] args) {

//声明Connection对象

Connection con;

//驱动程序名

String driver = “com.mysql.jdbc.Driver”;

//URL指向要访问的数据库名mydata

String url = “jdbc:mysql://localhost:3306/itcast0306elec”;

//MySQL配置时的用户名

String user = “root”;

//MySQL配置时的密码

String password = “lishan”;

//遍历查询结果集

try {

//加载驱动程序

Class.forName(driver);

//1.getConnection()方法，连接MySQL数据库！！

con = DriverManager.getConnection(url,user,password);

if(!con.isClosed())

System.out.println(“Succeeded connecting to the Database!”);

//2.创建statement类对象，用来执行SQL语句！！

Statement statement = con.createStatement();

//要执行的SQL语句

String sql = “select * from Elec_Text”;

//3.ResultSet类，用来存放获取的结果集！！

ResultSet rs = statement.executeQuery(sql);

System.out.println(“—————–“);

System.out.println(“执行结果如下所示:”);

System.out.println(“—————–“);

System.out.println(“—————–“);

String job = null;

String id = null;

Date dt = null;

String textrm = null;

while(rs.next()){

//获取stuname这列数据

job = rs.getString(“textID”);

//获取stuid这列数据

id = rs.getString(“textName”);

dt = rs.getDate(“textDate”);

textrm = rs.getString(“textRemark”);

//输出结果

System.out.println(id + “\t” + job+”\t”+dt+”\t”+textrm);

}

rs.close();

con.close();

} catch(ClassNotFoundException e) {

//数据库驱动类异常处理

System.out.println(“Sorry,can`t find the Driver!”);

e.printStackTrace();

} catch(SQLException e) {

//数据库连接失败异常处理

e.printStackTrace();

}catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}finally{            System.out.println(“数据库数据成功获取！！”);

}

}

}