package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.concurrent.locks.StampedLock;
/*create table users(
id int primary key auto_increment,
name varchar(40),
password varchar(40),
email varchar(60),
birthday date
);
insert into users(name,password,email,birthday) values('zs','123456','zs@sina.com','1980-12-04');
insert into users(name,password,email,birthday) values('lisi','123456','lisi@sina.com','1981-12-04');
insert into users(name,password,email,birthday) values('wangwu','123456','wangwu@sina.com','1979-12-04');
*/
//查询出所有的记录 打印到控制台上
public class JDBCDemo1 {
public static void main(String[] args) throws SQLException {
// 1、加载驱动程序并注册驱动:DriverManager
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
// 2、获取与数据库的连接:Connection
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day14", "root", "gqcmysql");//url 不同数据库不同 具体看数据库说明
// 3、得到代表SQL语句的对象 并发送 SQL给数据库:Statement
Statement stmt=conn.createStatement();
// 4、如果有查询结果、得到封装了查询结果的对象:ResultSet
ResultSet rs=stmt.executeQuery("select id,name,password,email,birthday from users");
// 5、遍历结果
while(rs.next()) {
System.out.println("----------");
System.out.println(rs.getObject("id"));
System.out.println(rs.getObject("name"));
System.out.println(rs.getObject("password"));
System.out.println(rs.getObject("email"));
System.out.println(rs.getObject("birthday"));
}
// 6、释放占用的资源
rs.close();
stmt.close();
conn.close();
}
}