Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.db;
- import java.sql.*;
- public class JdbcOracleInsert{
- public static void main(String args[]) {
- String url = "jdbc:oracle:thin:@localhost:1521:xe";
- String user = "scott";
- String passwd = "tiger";
- String q = "insert into addressBook values(?,?,?,?,?)";
- Connection conn;
- PreparedStatement pstat; //
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver"); //1.jdbc 드라이버 등록
- conn = DriverManager.getConnection (url, user, passwd); // 2.connection 객체 얻어내기
- pstat = conn.prepareStatement(q); // 3. statement객체 얻어내기
- pstat.setString(1, args[0]);//3-1. ?에 값을 세팅하는 작업
- pstat.setString(2, args[1]); // 뒤에 pair에 id와 같은 변수명 입력해도 괜찮음
- pstat.setString(3, args[2]);
- pstat.setString(4, args[3]);
- pstat.setString(5, args[4]);
- // String q = "insert into addressBook values(999,'harry','010-2345-6999','tokyo','sony')";//4.쿼리 실행
- int i = pstat.executeUpdate(); //5. 결과처리
- //
- // while(rs.next()==true) { //6.결과처리
- // String id = rs.getString(1);
- // String name = rs.getString(2);
- // String phone = rs.getString(3);
- // String address = rs.getString(4);
- // String company = rs.getString(5);
- //
- // System.out.println(id+"--"+name+"--"+phone+"--"+address+"--"+company);
- // }
- System.out.println(i+"개의 레코드 추가");
- pstat.close();
- conn.close();
- } catch ( Exception e ) {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment