JAVA连接MySQL

 预先在MYEclipse的安装途径下\MyEclipse 8.5\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\lib放入驱动文件

mysql-connector-java-5.1.22.tar.gz

import java.sql.*;

public class Main {
	final static String connURL = "jdbc:mysql://127.0.0.1/test";
	final static String user = "root";
	final static String password = "123456";
	static Connection conn = null;
	static Statement statement = null;
	static ResultSet res = null;

	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn = DriverManager.getConnection(connURL, user, password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			if (!conn.isClosed()) {
				System.out.println("连接成功");
			} else {
				System.out.println("连接失败");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			statement = conn.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String sql = "SELECT * FROM test";
		try {
			res = statement.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("SQL语句有误");
			return;
			// e.printStackTrace();
		}
		try {
			for (int i = 1; i != res.getMetaData().getColumnCount() + 1; ++i) {
				System.out.print(res.getMetaData().getColumnName(i) + " ");
			}
			System.out.println();
			while (res.next()) {
				for (int i = 1; i != res.getMetaData().getColumnCount() + 1; ++i) {
					System.out.print(res.getString(i) + " ");
				}
				System.out.println();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

 

 

转载于:https://www.cnblogs.com/blue1244/archive/2013/02/18/2916256.html