JDBC 基础

package info.dyndns.oszc.Introduce;import java.sql.*;public class Base {public static void main(String[] args) throws Exception {new Base().test();}public void test() throws Exception {//1、注册驱动,查mysql说明文档DriverManager.registerDriver(new com.mysql.jdbc.Driver());//2、建立连接Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/books","××××","××××");//3、创建语句Statement st = conn.createStatement();//4、执行语句ResultSet rs = st.executeQuery("select * from authors");//5、处理结果while (rs.next()){System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"t");}//6、释放资源rs.close();st.close();conn.close();}}