package com.hadoop.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @Note:鏈接數(shù)據(jù)庫時(shí)需要"添加構(gòu)建路徑",添加jar包：為jdbc驅(qū)動(dòng)----"mysql-connector-java-5.1.31-bin.jar"
 * 	注意數(shù)據(jù)庫名字為testdb(寫在url里),表名字為student(寫在sql里的selete * from student里)
 *
 */
public class MyJdbcDemo {
	public static void main(String[] args) {
	String driver = "com.mysql.jdbc.Driver"; //驅(qū)動(dòng)Driver
	String url = "jdbc:mysql://localhost:3306/testdb"; //url,數(shù)據(jù)庫名字為testdb
	String user = "root"; //username------注意用戶名一定是root!!! 用戶名只能默認(rèn)是root
	String password = "mysql"; //pwd-----密碼可以為mysql,反正自己設(shè)置的
	
	try {
	Class.forName(driver); //加載驅(qū)動(dòng)
	Connection conn = DriverManager.getConnection(url, user, password); //建立連接
	if(!conn.isClosed()){
	System.out.println("Succeed connecting to the database!");
	}
	Statement statement = conn.createStatement(); //執(zhí)行SQL的statement
	String sql = "select * from student"; //sql語句,表名稱為student
	ResultSet result = statement.executeQuery(sql); //結(jié)果集result
	System.out.println("執(zhí)行結(jié)果:");
	System.out.println("sno"+"\t"+"sname"+"\t"+"sex"+"\t"+"bdate"+"\t"+"height");	
	while(result.next()){	
	System.out.print(result.getString("sno") + "\t");
	System.out.print(result.getString("sname") + "\t"); //選擇sname這列數(shù)據(jù)
	System.out.print(result.getString("sex") + "\t");
	System.out.print(result.getString("bdate") + "\t");
	System.out.println(result.getString("height"));
	}
	result.close();
	conn.close();
	
	} catch (ClassNotFoundException e) {
	System.out.println("cannot find the driver!");
	} catch (SQLException e) {
	e.printStackTrace();
	System.out.println("SQLException!");
	}	
	
	}

}