jdbc. 데이터 입력 - INSERT INTO 예시

package pracitce;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.util.Scanner;

 

public class BoardWriteMainPractice1 {

public static void main(String[] args) {

Connection con = null;

PreparedStatement pstmt = null;

 

String driver = "oracle.jdbc.OracleDriver";

String url = "jdbc:oracle:thin:@localhost:1521/xe";

String uid = "java";

String upw = "java";

 

boardVO vo = new boardVO();

 

Scanner scanner = new Scanner(System.in);

 

System.out.println("제목 : ");

String title = scanner.nextLine();

System.out.println("내용 : ");

String content = scanner.nextLine();

System.out.println("작성자 : ");

String writer = scanner.nextLine();

System.out.println("비밀번호 : ");

String pw = scanner.nextLine();

 

 

 

try {

Class.forName(driver);

 

con = DriverManager.getConnection(url, uid, upw);

 

String sql = "insert into board(no,title,content,writer,pw)"

+ " values(board_seq.nextval, ? ,?, ? ,?)";

 

pstmt = con.prepareStatement(sql);

 

pstmt.setString(1, title);

pstmt.setString(2, content);

pstmt.setString(3, writer);

pstmt.setString(4, pw);

 

int result = pstmt.executeUpdate();

 

if(result == 0 ) {

System.out.println("오류인데용");

 

}else {

System.out.println("데이터 입력 성공");

}

 

} catch (Exception e) {

e.printStackTrace();

}finally {

try {

if(pstmt != null)pstmt.close();

if(con != null)con.close();

} catch (Exception e) {

e.printStackTrace();

}

}

scanner.close();

}

}