读书人

orcla jdbc 连接的例子 谁有?小弟我

发布时间: 2011-11-22 23:46:19 作者: rapoo

orcla jdbc 连接的例子 谁有???我忘记了 急用!!!100分
数据库名tct108
用户名site_test
密码.......
速度给分 成信!!!!

[解决办法]
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:tct108", "site_test", "......");

MyDbComputerNameOrIP 替换你的oracle数据库ip地址
[解决办法]

探讨
Class.forName( "oracle.jdbc.driver.OracleDriver" );
Connection cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );

[解决办法]
Java code
public static void main(String[] args) {        Connection conn = null;        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            conn = DriverManager.getConnection(                    "jdbc:oracle:thin:@localhost:1521:tct108", "site_test",                    "...");        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        } finally {            if (conn != null)                try {                    conn.close();                } catch (SQLException e) {                    e.printStackTrace();                }        }    }
[解决办法]
Java code
public class dbmanger {      private String driver="oracle.jdbc.driver.OracleDriver";      private String user="site_test ";      private String password="";      private String url="jdbc:oraclethin:@MyDbComputerNameOrIP/tct108";      private Connection con=null;      public dbmanger() {        try {            Class.forName(driver);        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        try {            con=DriverManager.getConnection(url, user, password);        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }      }      public Connection getConnection() {          if(con==null) {              try {                con=DriverManager.getConnection(url,user,password);            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }          }          return con;      }      public void close(){          if(con!=null) {              try {                con.close();            } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }          }      }}
[解决办法]

[解决办法]
把本地硬盘里的图片存储到oracle数据库里blob的实现
[解决办法]
上面朋友的做法都可以的

呵呵,建议楼主对基本的数据库连接方法要熟练使用
[解决办法]
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:tct108", "site_test",
"...");
} catch (ClassNotFoundException e) {
e.printStackTrace();


} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

读书人网 >Java Web开发

热点推荐