[] STUDY 내용

작성일 2004-04-27
작성자 park
조회수 728
제 목 Record Select

목록으로 | 수정 | 삭제 | 정보추가[reply] | 신규입력

import  java.sql.*;

class  connectEx1  
{
    Connection  con;
    Statement    stmt;
    ResultSet    record;
    
    public  connectEx1()
    {    
        try
        {
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();  
            con  =  DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","4567");
            System.out.println("Connection  OK");
            
            //statement
            stmt  =  con.createStatement();
            
            //  resultSet
            String  sql="select  *  from  member";
            record  =  stmt.executeQuery(sql);
            
            recordView();
        }
        catch(Exception  e){System.out.println(e);}
    
    }
    
    public  void  recordView()
    {
        try
        {
            record.first();
            
            System.out.print("ID  \t");
            System.out.print("Name  \t");
            System.out.print("Address  \n");
            while(!record.isAfterLast())
            {
                System.out.print(record.getString("id")  +  "\t");
                System.out.print(record.getString("name")  +  "\t");
                System.out.print(record.getString("address")  +  "\n");
                record.next();
            }
        }
        catch(Exception  e){System.out.println(e);}
        
    }
    
    public  static  void  main(String  args[])
    {
        connectEx1  ce=new  connectEx1();
    }
    
    
}

Record Select 과(와) 관련된 추가 정보

  • Record Select [2004-04-27] [park님 재공] [조회:728]
  • 테이블의 필드명 알아내기 [2005-03-04] [studyto님 재공] [조회:1142]

    목록으로 | 수정 | 삭제 | 정보추가[reply] | 신규입력