preparedSatement, createStatement 작성법 차이

 

preparedStatedment 작성

String sql="SELECT * FROM NOTICE_VIEW WHERE NUM BETWEEN ? AND ?";
	
Class.forName(driver);
Connection con = DriverManager.getConnection(url,uid,pwd);
PreparedStatement st = con.prepareStatement(sql); //SQL준비
st.setInt(1, start); //1번 ? 지정
st.setInt(2, end); //2번 ? 지정
ResultSet rs = st.executeQuery(); //쿼리실행

createStatement작성

String sql="SELECT COUNT(ID)  FROM NOTICE";
			
Class.forName(driver);
Connection con = DriverManager.getConnection(url,uid,pwd);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);​