package com.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.jupiter.api.Test;

import com.mysql.jdbc.Driver;

public class JDBCdemo1 {

@Test

/**

* JDBC的入门程序

*/

public void demo1() {

// 1.加载驱动

try {

DriverManager.registerDriver(new Driver());

// 2.获得连接

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

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

// 3.1创建执行SQL的对象

String sql = "select*from user1";

Statement stmt = conn.createStatement();

// 3.2执行SQL

ResultSet resultSet = stmt.executeQuery(sql);

while(resultSet.next()) {

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

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

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

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

System.out.println(uid+"   "+username+"  "+password+"  "+name);

}

// 4.释放资源

resultSet.close();

stmt.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}