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 java.net.ConnectException;

public class JDBCDemo1 {

public void demo1(){

try {

// 1.加载驱动

// DriverManager.registerDriver(new Driver());// 会导致驱动注册两次。

Class.forName("com.mysql.jdbc.Driver"); 

// 2.获得连接

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "1qaz2wsx");

// 3.创建执行SQL语句的对象，并且执行SQL

// 3.1创建执行sql的对象

String sql = "select * from goods";

Statement stmt = conn.createStatement();

// 3.2执行sql

ResultSet resultSet = stmt.executeQuery(sql);

while(resultSet.next()){

int uid = resultSet.getInt("id");

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

//String password = resultSet.getString("prince");

String desp = resultSet.getString("desp");

System.out.println(uid+"   "+name+"      "+desp);

}

// 4.释放资源

resultSet.close();

stmt.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}