5/7 컴보2A

package jdbcTest;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class jdbcTest {

public static void main(String[] args) {

try{

//MySql jdbc드라이버 로드

Class.forName("com.mysql.jdbc.Driver");

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sampledb","root","1234");

System.out.println("연결됨");

Statement s=conn.createStatement();

String sql="select * from student";

ResultSet rs=s.executeQuery(sql);

while(rs.next()){

System.out.println(rs.getString("id"));

System.out.println(rs.getString("name"));

System.out.println(rs.getString("address"));

System.out.println(rs.getString("dept"));

}

rs.close();//rs종료

s.close();//statement종료

}catch(Exception e){

e.printStackTrace();

}

}

}