jdbc

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class StudentDao {
    public static void main(String[] args) {
        Scanner scan = new Scanner(System.in);
        System.out.println("enter new name:");
        String str = scan.nextLine();
        /**
         * 加载驱动
         * 获取连接对象
         * 获取sql命令对象
         * 设置s事务手动提交
         * 创建sql命令
         * 指定sql命令
         * 关闭资源
         */
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@localhost:1521:XE";
        String user = "C##scott";
        String password = "scott";
        Connection coon=null;
        Statement stmt=null;

        try {
            Class.forName(driver);
            coon = DriverManager.getConnection(url,user,password);
            stmt = coon.createStatement();
            coon.setAutoCommit(false);
            int i = stmt.executeUpdate("update dept dname set dname='"+str+"' where dname='asdf'");
            if(i>0){
                coon.commit();
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }catch (Exception e){
            try {
                coon.rollback();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }finally {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                coon.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            scan.close();
        }
    }
}