package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class Base {
public static void main(String[] args) throws SQLException{
test();
}
static void test() throws SQLException{
//1.注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//建立连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jdbc","root","123");
//创建语句
Statement st = (Statement) conn.createStatement();
//执行语句
ResultSet rs = st.executeQuery("select * from user");
//处理结果
while(rs.next()){
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)
+ "\t" + rs.getObject(3) + "\t" + rs.getObject(4));
}
//释放资源
rs.close();
st.close();
conn.close();
}
}