JDBC 演示

来源：互联网发布：青岛特来电公司知乎编辑：程序博客网时间：2024/05/21 12:48
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、加载驱动程序并注册驱动：DriverManagerDriverManager.registerDriver(new com.mysql.jdbc.Driver());//2、获取与数据库的连接：ConnectionConnection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day14", "root", "gqcmysql");//url 不同数据库不同 具体看数据库说明//3、得到代表SQL语句的对象 并发送 SQL给数据库:StatementStatement stmt=conn.createStatement();//4、如果有查询结果、得到封装了查询结果的对象:ResultSetResultSet 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();}}
阅读全文
0 0