简单的JDBC例子

//1.注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//2.建立连接
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "123456");
//3.创建语句
Statement st=conn.createStatement();
//4.执行SQL语句
ResultSet resultSet=st.executeQuery("select * from TEST;");
//5.处理结果
while(resultSet.next())
{
System.out.println(resultSet.getObject(1)+"-------"+resultSet.getObject(2)+"----"+resultSet.getObject(3));
}
//6.释放资源
resultSet.close();
st.close();
conn.close();