package com.jk.jdbc;

import java.sql.*;

public class MyJdbcPra_tang {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		//初始化四個變量
		String userName = "tangqb";
		String passwd = "tangqb";
		String driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@10.22.78.99:1521:XE";
		//定義jdbc操作的變量
		Connection conn = null;
		PreparedStatement pstmt = null;
		//由于要做insert操作，所以不定義結(jié)果集ResultSet
		try{
		//1注冊driver
			Class.forName(driver);
		//2獲得鏈接
			conn = DriverManager.getConnection(url,userName,passwd);
		//3獲得Statement
			String sql = "insert into test values(?,?)";
			pstmt = conn.prepareStatement(sql);
		//4執(zhí)行sql語句
			pstmt.setInt(2, 100);
			pstmt.setString(1, "hello");
			pstmt.executeUpdate();
			//executeUpdate()表示數(shù)據(jù)庫響應(yīng)記錄的條數(shù)
			//5處理結(jié)果集
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				if(pstmt != null) pstmt.close();
				if(conn != null) conn.close();
 			}catch(Exception e){
 				e.printStackTrace();
 			}
		}
	}

}