Java数据库编程（执行数据库查询操作）

package org.dml;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class ResultSetDemo01 {
public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
public static final String url = "jdbc:mysql://localhost:3306/mldn";
public static final String user = "root";
public static final String password = "root";
public static void main(String[] args) throws Exception{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "select id,name,password,age,sex from user";
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String password = rs.getString("password");
int age = rs.getInt("age");
String sex = rs.getString("sex");
System.out.print("编号："+id+"；");
System.out.print("姓名："+name+"；");
System.out.print("密码："+password+"；");
System.out.print("年龄："+age+"；");
System.out.println("性别："+sex+"；");
System.out.println("------------------");
}
rs.close();
stmt.close();
conn.close();
}
}