cmd 코드 활용하여 jsp 테이블 만들기

소개글

cmd 코드 활용하여 jsp 테이블 만들기에 대한 보고서 자료입니다.

본문내용

intStackTrace();
}finally{
if(rs != null) try{rs.close();}catch(SQLException sqle){}
if(pstmt != null) try{pstmt.close();}catch(SQLException sqle){}
if(conn != null) try{conn.close();}catch(SQLException sqle){}
}
%>
<%@ page language=\"java\" contentType=\"text/html; charset=EUC-KR\"
pageEncoding=\"EUC-KR\"%>
<%@ page import=\"java.sql.*\"%>

park 테이블의레코드표시

<%
Connection conn=null
PreparedStatement pstmt=null
ResultSet rs=null
try{
String jdbcUrl=\"jdbc:mysql://localhost:3306/parkjun\"
String dbId=\"jspid\"
String dbPass=\"jsppass\"
Class.forName(\"com.mysql.jdbc.Driver\");
conn=DriverManager.getConnection(jdbcUrl,dbId ,dbPass );
String sql= \"select * from park\"
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
int sum1=0;
while(rs.next()){
String name= rs.getString(\"name\");
String price= rs.getString(\"price\");
String nom= rs.getString(\"nom\");
String point= rs.getString(\"point\");
String total= rs.getString(\"total\");
int p=Integer.parseInt(total);
sum1=sum1+p;
p=0;
%>







<%}%>

상품명	가격	수량	적립금	합계
<%=name%>	<%=price%>	<%=nom%>	<%=point%>	<%=total%>

<%
out.println(\"총상품금액:\"+sum1+\"입니다.\");
}catch(Exception e){
e.printStackTrace();
}finally{
if(rs != null) try{rs.close();}catch(SQLException sqle){}
if(pstmt != null) try{pstmt.close();}catch(SQLException sqle){}
if(conn != null) try{conn.close();}catch(SQLException sqle){}
}
%>

키워드

cmd,   jsp,   table구축