package com.atguigu.api.statement;
import com.mysql.jdbc.Driver;
import java.sql.*;
public class StatementQueryPart {
public static void main(String[] args) throws SQLException {
try{
//1.注册驱动
/*
驱动版本:8+com.mysql.cj.jdbc.Driver
5+com.mysql.jdbc.Driver
*/
DriverManager.registerDriver(new Driver());
//创建连接
/*
参数1:url
jdbc:数据库厂商名://ip地址:port/数据库名
jdbc:mysql://127.0.0.1:3306/test
*/
//java.sql下的接口=实现类
Connection connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","123456");
//3.创建statement(发送sql语句的小车)
Statement statement=connection.createStatement();
//4.发送sql语句,并且获得返回结果
String sql="select * from users;";
ResultSet resultSet=statement.executeQuery(sql);
//5.结果解析
while(resultSet.next())
{
int id=resultSet.getInt("user_id");
String name= resultSet.getNString("user_name");
String password=resultSet.getNString("user_password");
int age=resultSet.getInt("age");
String sex=resultSet.getNString("sex");
System.out.println(id+"---"+name+"---"+password+"---"+age+"---"+sex+"---");
}
//6.关闭资源
resultSet.close();
statement.close();
connection.close();
}catch (Exception e)
{
System.out.println(e.toString());
}
if(System.out.printf("A")==null) {
System.out.print("A");
}
else {
System.out.print("B");
}
}
}
JDBC工具类
package com.it.util;
import java.sql.*;
public class DBUtil {
public static Connection getConn(){ //返回链接对象
Connection conn=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
} catch (Exception e) {
System.out.println(e.toString());
}
return conn;
}
public static void closes(Connection conn, Statement stm, ResultSet rs){//关闭资源
try {if(conn!=null){
conn.close();}
if(stm!=null){
stm.close();}
if(rs!=null){
rs.close();}
} catch (Exception e) {
System.out.println(e.toString());
}
}
}