package com.jk.jdbc;

import java.sql.*;
//import java.sql.Connection;
public class Myjdbcpra_wangkj {

	
	public static void main(String[] args) {
		String userName = "wangkj";
		String passwd = "xinxin";
		String driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@10.22.78.99:1521:XE";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		//由于要做insert 操作,所以不定義結果集
		try{
			//注冊driver
			Class.forName(driver);
			//獲得連接
			 conn = DriverManager.getConnection(url,userName,passwd);
			 //3
			 String sql = "insert into test values(?,?)";
			 pstmt = conn.prepareStatement(sql);
			 //4執行sql語句
			 
			 pstmt.setInt(2,100);
			 pstmt.setString(1,"Hello");
			 int result = pstmt.executeUpdate();
			 System.out.println(result);//處理結果
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(pstmt != null) pstmt.close();
				if(conn != null) conn.close();
				
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		
		}

}