培训第四天-----jdbc连接oracle

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了培训第四天-----jdbc连接oracle，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2967字，纯文字阅读大概需要5分钟。

内容图文

com.zjw.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class mydbbase { private Connection conn; private String oracleUrl="jdbc:oracle:thin:@localhost:1521:orcl"; //private String mysqlUrl="jdbc:mysql://localhost:3306//mysql"; private String username = "u1"; private String password = "Admin123"; public mydbbase(){ try { Class.forName("oracle.jdbc.driver.OracleDriver"); DriverManager.setLoginTimeout(0); conn = DriverManager.getConnection(oracleUrl,username,password); Statement stmt = conn.createStatement(); String sql = "insert into tableone(id,name,sex,age) values(1,‘jiewei‘,‘男‘,‘23‘) "; stmt.executeUpdate(sql); conn.commit(); stmt.close(); conn.close(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { mydbbase mb = new mydbbase(); } }

• 查询数据库中tableone的数据

package com.zjw.db;

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

public class mydbbase {

    private  Connection conn;
    private  String oracleUrl="jdbc:oracle:thin:@localhost:1521:orcl";
    //private String mysqlUrl="jdbc:mysql://localhost:3306//mysql";
    private  String username = "u1";
    private  String password = "Admin123";
    public mydbbase(){
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            DriverManager.setLoginTimeout(0);
            conn = DriverManager.getConnection(oracleUrl,username,password);
            
            Statement stmt =  conn.createStatement();
            //插入语句
            //String sql = "insert into tableone(id,name,sex,age) values(1,‘jiewei‘,‘男‘,‘23‘) ";
            //String sql = "delete from tableone where id=1";
            //stmt.executeUpdate(sql);
            //查询语句
            String sqlSelect = "select * from tableone";
            ResultSet rs = stmt.executeQuery(sqlSelect);
            while(rs.next()){
                System.out.print(rs.getInt("id")+" ");
                System.out.print(rs.getString("name")+" ");
                System.out.print(rs.getString("sex")+" ");
                System.out.print(rs.getString("age")+" ");
            }
            conn.commit();
            stmt.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public static void main(String[] args) {
        mydbbase mb = new mydbbase();
    }

}

• 用 preparedStatement来进行增删改查

  //用preparedStatement来进行增删改查
      public static boolean auth(String name,String password){
          conn = getConnection();
          try {
              PreparedStatement pstmt = conn.prepareStatement("select * from tableone " + "where name=? and password = ?");
              pstmt.setString(1, name);
              pstmt.setString(2, password);
              ResultSet rs = pstmt.executeQuery();
              if(rs.next()){
                  return true;
              }
          } catch (SQLException e) {
              // TODO Auto-generated catch block
              e.printStackTrace();
          }
          return false;
      }

   

培训第四天-----jdbc连接oracle

标签：

本文系统来源：http://www.cnblogs.com/endingzero/p/5691267.html

内容总结

以上是互联网集市为您收集整理的培训第四天-----jdbc连接oracle全部内容，希望文章能够帮你解决培训第四天-----jdbc连接oracle所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---