JDBC原始版

package testJDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class test {

	public static void main(String[] args) {
		
		
		try {
			// 1.通过反射技术，将数据库驱动 加载到内存中
			String name = "oracle.jdbc.OracleDriver";
			Class.forName(name);
			String url = "jdbc:oracle:thin:@localhost:1521:xe";
			String user = "czy2";
			String pass = "123";
			// 2,使用驱动管理类，得到连接对像
			Connection conn = DriverManager.getConnection(url,user,pass);
			// 3 通过连接对像，得到处理器对像，处理器对像用来发送insert update delete select等sql语句
			Statement stmt = conn.createStatement();
			
			// 4用处理器处理sql语句 executeUpdate方法用来发送insert update
			//添加语句						//这里的emp.nextval是序列，自动增长id
			/*String sql = "insert into s_emp(id,first_name,last_name) values(emp.nextval,'Tom','T')";
			int i = stmt.executeUpdate(sql);
			if(i>0){
				System.out.println("增加成功");
			}else{
				System.out.println("增加失败");
			}*/
			
			//删除语句
			/*String sql = "delete s_emp where id = 1";
			int i = stmt.executeUpdate(sql);
			if(i > 0){
				System.out.println("删除成功");
			}else{
				System.out.println("删除失败");
			}*/
			
			//修改语句
			String sql = "update s_emp set first_name = 'Jack' where id = 2";
			int i = stmt.executeUpdate(sql);
			if(i>0){
				System.out.println("修改成功");
			}else{
				System.out.println("修改失败");
			}
			
			//查询语句
			/*String sql = "select * from s_emp";
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				System.out.println(rs.getString("first_name")+rs.getString("last_name"));
			}*/
			

			// 关闭处理器对像和连接对像
			if(stmt!=null){
				stmt.close();
			}
			if(conn!=null){
				conn.close();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}