package com.imooc.jdbc.demo1;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.junit.Test;

import com.mysql.jdbc.Driver;

public class JDBCDemo1 {

@Test

public void demo1() {

try {

//加载驱动

DriverManager.registerDriver(new Driver());

//获得连接

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_test", "root", "1234");

//创建执行SQL语句的对象

String sql = "select *from test";

Statement stmt = conn.createStatement();

//执行SQL

ResultSet result = stmt.executeQuery(sql);

while(result.next()) {

int id = result.getInt("id");

String name = result.getString("name");

String room  =result.getString("room");

String salary = result.getString("salary");

System.out.println(id+" "+name+"  "+room+"  "+salary);

}

//释放资源

result.close();

stmt.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}