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

소개글

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

본문내용

tStackTrace();
}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구축