20220321 복습
More information <- 자세한 구조 및 문법 (Address Management System)
1. Java Build Path -> Classpath (Add External JARs..) -> mysql-connector-java-8.0.27.jar 추가
2. Deployment Assembly -> Add -> Java Build Path Entries -> mysql-connector-java-8.0.27.jar 추가
Connection conn=null;
PreparedStatement pstmt=null;
String jdbc_driver = "com.mysql.cj.jdbc.Driver";
String jdbc_url="jdbc:mysql://127.0.0.1:3306/db53";
String id="root";
String pw="123456";
try {
Class.forName(jdbc_driver);
conn=DriverManager.getConnection(jdbc_url, id, pw);
} catch (ClassNotFoundException e) {
e.getStackTrace();
} catch (SQLException e) {
e.getStackTrace();
}
CREATE TABLE `addrbook` (
`ab_id` int(11) NOT NULL AUTO_INCREMENT,
`ab_name` varchar(15) NOT NULL,
`ab_email` varchar(50) DEFAULT NULL,
`ab_comdept` varchar(20) NOT NULL,
`ab_birth` varchar(10) NOT NULL,
`ab_tel` varchar(20) DEFAULT NULL,
`ab_memo` varchar(100) DEFAULT NULL,
PRIMARY KEY (`ab_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
show databases;
use DB;
show tables;
select * from TB;
Truncate => truncate addrbook;
Insert => insert into addrbook(field1, field2, field3) values(?,?,?)
Select => select * from addrbook where field=value
Update => update addrbook set field1=value where field2=value
Delete => delete from addrbook where field=value
ResultSet rs = pstmt.executeQuery();
pstmt.executeUpdate();
rs.next();
rs.getInt / getString ( parameterIndex, value );
rs.setInt / setString ( parameterIndex, value );
int ab_id;
String ab_name;
String ab_email;
String ab_tel;
String ab_birth;
String ab_comdept;
String ab_memo;
void connect(){
}
void disconnect(){
}
void updateDB(){
}
void deleteDB(){
}
void insertDB(){
}
void selectDB(){
}
void getDB(){
}
<% request.setCharacterEncoding("UTF-8"); %> -> 인코딩
<% pageContext.forward("ab_ctl.jsp?command=select"); %> -> 페이지 이동 및 command 값 설정
<%@ page import="java.util.*" %> -> import
<jsp:useBean id="ab" class="addrbook.AddrBean"/> -> 객체 생성
<jsp:setProperty property="*" name="abk" /> -> 객체의 변수값 설정
<form method="post" action="ab_ctl.jsp" name="form1"> -> form 이동 / hidden으로 command 값 설정 / onClick으로 스크립트 함수 실행
<input type="hidden" name="command" value="update">
<input type="submit" value="[ Update ]"> <input type="button" value="[ Delete ]" onClick="delCheck()">
</form>
<head>
<script type="text/javascript">
function delCheck(){
result = confirm('Are you sure you want to delete ?');
if(result == true)
{
document.form1.command.value="delete"; -> form1 문서의 command 값을 설정
document.form1.submit();
} else {
return;
}
}
</script>
</head>