java test表中查询数据

转载于

http://www.cnblogs.com/dennisac/archive/2012/04/17/2454173.html

package JDBCDEMOS;


//import java.net.ConnectException;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;


//import com.mysql.jdbc.Statement;


public class JDBCDEMO1 {
    public static final String DBDRIVER = "com.mysql.jdbc.Driver";
    public static final String DBURL = "jdbc:mysql://localhost:3306/test";
    public static final String DBUSER = "root";
    public static final String DBPASS = "123123";


    public static void main(String[] args) throws Exception {
        Connection conn = null;// 数据库连接
        Statement stmt = null;
        ResultSet rs=null;
        String sql = "SELECT *FROM mytab";
        Class.forName(DBDRIVER);
        conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
        stmt = conn.createStatement();
        rs=stmt.executeQuery(sql);
        while(rs.next()){
            int id=rs.getInt("id");
            String name=rs.getString("name");
            int age=rs.getInt("age");
            System.out.print("编号: "+id+";");
            System.out.print("姓名: "+name+";");
            System.out.println("年龄: "+age+";");
            System.out.println("---------------------");
            
        }
        rs.close();
        stmt.close();
        conn.close();
    }
}