jdbc经典马士兵（写法）

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestDML {public static void main(String[] args) {Statement stmt = null;Connection conn = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");//new oracle.jdbc.driver.OracleDriver();conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");stmt = conn.createStatement();String sql = "insert into dept2 values (98, 'GAME', 'BJ')";stmt.executeUpdate(sql);} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if(stmt != null) {stmt.close();stmt = null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}

import java.sql.*;public class TestJDBC { public static void main(String[] args) { ResultSet rs = null; Statement stmt = null; Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); //new oracle.jdbc.driver.OracleDriver(); conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger"); stmt = conn.createStatement(); rs = stmt.executeQuery("select * from dept"); while(rs.next()) { System.out.println(rs.getString("deptno")); System.out.println(rs.getInt("deptno")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if(rs != null) { rs.close(); rs = null; } if(stmt != null) { stmt.close(); stmt = null; } if(conn != null) { conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } }}
 
 
 
 
 
import java.sql.*;
public class TestPrepStmt {
 public static void main(String[] args) {  if(args.length != 3) {   System.out.println("Parameter Error! Please Input Again!");   System.exit(-1);  }    int deptno = 0;    try {   deptno = Integer.parseInt(args[0]);  } catch (NumberFormatException e) {   System.out.println("Parameter Error! Deptno should be Number Format!");   System.exit(-1);  }    String dname = args[1];  String loc = args[2];    PreparedStatement pstmt = null;  Connection conn = null;  try {   Class.forName("oracle.jdbc.driver.OracleDriver");   //new oracle.jdbc.driver.OracleDriver();   conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");   pstmt = conn.prepareStatement("insert into dept2 values (?, ?, ?)");   pstmt.setInt(1, deptno);   pstmt.setString(2, dname);   pstmt.setString(3, loc);   pstmt.executeUpdate();  } catch (ClassNotFoundException e) {   e.printStackTrace();  } catch (SQLException e) {   e.printStackTrace();  } finally {   try {    if(pstmt != null) {     pstmt.close();     pstmt = null;    }    if(conn != null) {     conn.close();     conn = null;    }   } catch (SQLException e) {    e.printStackTrace();   }  } }
}
 
 
import java.sql.*;public class TestTransaction {
 public static void main(String[] args) {    Connection conn = null;  Statement stmt = null;    try {   Class.forName("oracle.jdbc.driver.OracleDriver");   conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SXT", "scott", "tiger");      conn.setAutoCommit(false);   stmt = conn.createStatement();   stmt.addBatch("insert into dept2 values (51, '500', 'haha')");   stmt.addBatch("insert into dept2 values (52, '500', 'haha')");   stmt.addBatch("insert into dept2 values (53, '500', 'haha')");   stmt.executeBatch();   conn.commit();   conn.setAutoCommit(true);  } catch (ClassNotFoundException e) {   e.printStackTrace();  } catch(SQLException e) {      e.printStackTrace();      try {    if(conn != null)    {     conn.rollback();     conn.setAutoCommit(true);    }   } catch (SQLException e1) {    e1.printStackTrace();   }  }finally {   try {    if(stmt != null)     stmt.close();    if(conn != null)     conn.close();   } catch (SQLException e) {    e.printStackTrace();   }  }  
 }
}
 
 
 
 

 
	
				
	
					   
jdbc经典马士兵（写法）
	  	   
JDBC-马士兵教程
	  	   
马士兵的经典名言！！！
	  	   
多线程：生产者与消费者经典问题（马士兵）
	  	   
JDBC知识 - 马士兵视频教程笔记
	  	   
马士兵老师经典J2SE中的经典语录
	  	   
士兵突击经典句子
	  	   
经典写法
	  	   
马士兵视频中的生产者与消费者的经典问题
	  	   
nyoj  116  士兵杀敌（二）<经典树状数组-插点问线>
	  	   
nyoj 123  士兵杀敌（四）<经典树状数组---插线求点>
	  	   
常用数据库JDBC连接写法（整理）
	  	   
常用数据库JDBC连接写法（整理）
	  	   
spring(马士兵文档）
	  	   
struts2文档（马士兵）
	  	   
hibernate文档（马士兵）
	  	   
Struts2 笔记（马士兵）
	  	   
JDBC Driver写法!
	     		  
	  	   
EPOLL例子
	  	   
Python模块学习 ---- subprocess 创建子进程
	  	   
中国黑客机密档案
	  	   
从Linux内核中获取真随机数
	  	   
删除指定文件夹下所有.php文件，如果子文件夹是空文件夹，也删除。
	  	   
jdbc经典马士兵（写法）
	  	   
Hdu 1711 - Number Sequence
	  	   
用多线程复制文件
	  	   
find命令详解
	  	   
sun的rpc
	  	   
论文读书笔记-Action unit classification using active appearance models and conditional random fields
	  	   
[linux]exit()与_exit()区别
	  	   
linux基础编程：IO模型：阻塞/非阻塞/IO复用 同步/异步 Select/Epoll/AIO
	  	   
免费PMP在线考试系统