1.基本步骤
- 注册驱动
- 建立连接
- 创建执行sql语句的对象
- 执行语句
- 处理执行结果
- 释放资源
2.代码
public static void test() throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:8086/jdbc","zhipeng","123456");
java.sql.Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from T_User");
while(rs.next()){
System.out.print(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t");
}
rs.close();
st.close();
conn.close();
}