java通过jdbc连接oracle数据库

一：java 使用jdbc连接oracle。

步骤

1）下载oracle数据库驱动：

2）新建一个工程（使用eclipse or myeclipse）

3）将1）中的驱动放到2）中项目的lib文件夹下。

4）在src包下的com.util文件夹下面新建一个类

代码如下：

package com.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBHelp {

private static String URL= "jdbc:oracle:thin:@localhost:1521:orcl";

private static String USERNAME = "scott";

private static String PASSWORD = "tiger";

public static Connection getCon(){

Connection conn = null;

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

/**

* @param args

*/

public static void main(String[] args) {

System.out.println(new DBHelp().getCon());

}

public static void close(Connection con,Statement sm,ResultSet rs){

try {

if(con!=null){

con.close();

}

if(sm!=null){

sm.close();

}

if(rs != null){

rs.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

5）执行main函数，得到输出

oracle.jdbc.driver.T4CConnection@186768e

可知已经练到数据库上了

import https://www.360docs.net/doc/e613668588.html,mons.dbutils.QueryRunner;

import https://www.360docs.net/doc/e613668588.html,mons.dbutils.ResultSetHandler;

import https://www.360docs.net/doc/e613668588.html,mons.dbutils.handlers.BeanListHandler;

import com.pojo.Student;

public class StuDao {

public Connection getConn() {

Connection conn=null;

try {

Class.forName("com.mysql.jdbc.Driver");

Conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_user", "root", "root");

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return conn;

}

public int save(Student stu) {

int i=0;

Connection conn = getConn();

QueryRunner qr=new QueryRunner();

String sql="insert into student(name,dates) values(?,?)";

try {

i=qr.update(conn, sql, stu.getName(),stu.getDates());

} catch (SQLException e) {

e.printStackTrace();

}

return i;

}

public Student findById(int idx) {

Student stu=new Student();

Connection conn = getConn();

QueryRunner qr=new QueryRunner();

String sql="select * from student where id=?";

ResultSetHandler rch=new BeanListHandler(Student.class);

try {

List list= qr.query(conn, sql, rch, idx);

stu = (Student) list.get(0);

} catch (SQLException e) {

e.printStackTrace();

}

return stu;

}

public static void main(String[] args) {

String s="1991-01-01";

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");

java.util.Date dates = null;

try {

dates = sdf.parse(s);

} catch (ParseException e) {

e.printStackTrace();

}

StuDao dao = new StuDao();

Student stu=new Student();

stu.setName("admin");

stu.setDates(dates);

int i = dao.save(stu);

if (i>0) {

System.out.println("success");

}else{

System.out.println("error");

}

/* */

// java.util.Date dateU=new java.util.Date();

//

// long time = dateU.getTime();

//

// java.sql.Date date=new Date(time);

// System.out.println(date);

/*String s="2012-09-09";

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");

try {

java.util.Date date = sdf.parse(s);

System.out.println(date);

} catch (ParseException e) {

e.printStackTrace();

}*/

// java.util.Date d=new java.util.Date();

//

// SimpleDateFormat sdf=new SimpleDateFormat("MM-dd"); //

// String format = sdf.format(d);

// System.out.println(format);

}

}