ํฐ์คํ ๋ฆฌ ๋ทฐ
728x90
SMALL
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>sql ํ๊ทธ๋ฅผ ์ด์ฉํ DB์์ </title>
</head>
<body>
<h2>sql ํ๊ทธ๋ฅผ ์ด์ฉํ DB์์ </h2>
<c:catch var="msg"><!-- ์์ธ์ฒ๋ฆฌ์ฉ -->
<!-- Connection ์ค์ -->
<sql:setDataSource
driver="oracle.jdbc.OracleDriver"
password="user01"
url="jdbc:oracle:thin@211.241.228.11:1521:orcl"
user="user01"
var="con"
/>
<!-- ๋ฐ์ดํฐ์ ๋ ฅ -->
<c:set var="num" value="${param.num}"/>
<c:set var="name" value="${param.name}"/>
<sql:update dataSource="con">
insert into test values (?,?)
<sql:param value="${num }"></sql:param>
<sql:param value="${name }"></sql:param>
</sql:update>
<!-- ๋ฐ์ดํฐ์กฐํ -->
<sql:query var="rs" dataSource="con">
select * from test
</sql:query>
<!-- ๊บผ๋ด์ -->
<c:forEach items="${rs.rows}" var="row">
${row['num']}, ${row['name']}</br>
</c:forEach>
</c:catch>
</body>
</html>
pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>sql ํ๊ทธ๋ฅผ ์ด์ฉํ DB์์ </title>
</head>
<body>
<h2>sql ํ๊ทธ๋ฅผ ์ด์ฉํ DB์์ </h2>
<c:catch var="msg"><!-- ์์ธ์ฒ๋ฆฌ์ฉ -->
<!-- Connection ์ค์ -->
<sql:setDataSource
driver="oracle.jdbc.OracleDriver"
password="user01"
url="jdbc:oracle:thin@211.241.228.11:1521:orcl"
user="user01"
var="con"
/>
<!-- ๋ฐ์ดํฐ์ ๋ ฅ -->
<c:set var="num" value="${param.num}"/>
<c:set var="name" value="${param.name}"/>
<sql:update dataSource="con">
insert into test values (?,?)
<sql:param value="${num }"></sql:param>
<sql:param value="${name }"></sql:param>
</sql:update>
<!-- ๋ฐ์ดํฐ์กฐํ -->
<sql:query var="rs" dataSource="con">
select * from test
</sql:query>
<!-- ๊บผ๋ด์ -->
<c:forEach items="${rs.rows}" var="row">
${row['num']}, ${row['name']}</br>
</c:forEach>
</c:catch>
</body>
</html>
728x90
LIST
'PROGRAMMING' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| ์ด๋ฒ์ฃผ๋ง์ ๊ณต๋ถํ ๋ด์ฉ. (0) | 2010.10.22 |
|---|---|
| ๊ฒ์์ด์ฐพ๊ธฐ (0) | 2010.07.13 |
| jsp EL (0) | 2010.07.06 |
| ์ผ๋จ, ์๋๋ก์ด๋ ๊ฐ๋ฐ์ ๋ฑ๋ก (0) | 2010.07.06 |
| java dbcp (0) | 2010.06.29 |
๋๊ธ
๊ณต์ง์ฌํญ
์ต๊ทผ์ ์ฌ๋ผ์จ ๊ธ
์ต๊ทผ์ ๋ฌ๋ฆฐ ๋๊ธ
- Total
- Today
- Yesterday
๋งํฌ
TAG
- ๋ณต๊ทผ์ด๋
- ๋ฉ๋ฐฐํ
- ์์์ฌ์ด๋
- ํจ์
- ์ธํจ์ด
- JSTL
- 8๋ง์ผ
- JSP
- php
- 2ne1
- ์น์์ด์ ์
- Servlet
- asp
- EL
- ์๋ธ๋ฆฟ
- ์นด๋ฐ์จ๋ผ์ธ
- ์๋ฐ์คํฌ๋ฆฝํธ
- MySQL
- I Don't Care
- jQuery
- JS
- Ajax
- ๊ธฐํ
- ์๋ฆฌ
- ๋ด๋๋ด์ฐ
- ๊ฒฝ์ ์ฉ์ด
- JavaScript
- Java
- ๋์ค
- JSON
| ์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 |
๊ธ ๋ณด๊ดํจ
250x250