package com.icss.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
public class Base {
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
*/
public static void main(String[] args) throws SQLException, ClassNotFoundException {
// TODO 自动生成的方法存根
test();
}
static void test() throws SQLException, ClassNotFoundException{
//1.注册驱动三种方式
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
// System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver");//推荐方式
//2.连接数据库,jdbc:mysql:///jdbc =jdbc:mysql://localhost:3306/jdbc
Connection conn = DriverManager.getConnection("jdbc:mysql:///jdbc", "root", "root");
//3.创建语句
Statement stmt = conn.createStatement();
//4.执行语句
ResultSet rs = stmt.executeQuery("select * from user");
//5.处理结果
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
Date birthday = rs.getDate("birthday");
float money = rs.getFloat("money");
System.out.println(id+"\t"+name+"\t"+birthday+"\t"+money+"\t");
}
//6.释放资源
rs.close();
stmt.close();
conn.close();
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
public class Base {
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
*/
public static void main(String[] args) throws SQLException, ClassNotFoundException {
// TODO 自动生成的方法存根
test();
}
static void test() throws SQLException, ClassNotFoundException{
//1.注册驱动三种方式
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
// System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver");//推荐方式
//2.连接数据库,jdbc:mysql:///jdbc =jdbc:mysql://localhost:3306/jdbc
Connection conn = DriverManager.getConnection("jdbc:mysql:///jdbc", "root", "root");
//3.创建语句
Statement stmt = conn.createStatement();
//4.执行语句
ResultSet rs = stmt.executeQuery("select * from user");
//5.处理结果
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
Date birthday = rs.getDate("birthday");
float money = rs.getFloat("money");
System.out.println(id+"\t"+name+"\t"+birthday+"\t"+money+"\t");
}
//6.释放资源
rs.close();
stmt.close();
conn.close();
}
}