mysql创建jdbc数据库_jdbc -- 001 -- 一般方式创建数据库连接（oracle/mysql）

void connectionOracle() throwsSQLException{

Connection conn = null; //数据库连接

PreparedStatement ps = null; //预编译语句对象

ResultSet rs = null; //结果集对象try{//注册(加载)Oracle驱动

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

// Class.forName("com.mysql.jdbc.Driver");注册(加载)mysql驱动 String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

//String url = "jdbc:mysql://127.0.0.1:3306/mybatis";

//String url = "jdbc:mysql://localhost:3306/mybatis";

String user= "scott";

String password= "tiger";

conn=DriverManager.getConnection(url, user, password);

String sql= "select ename from emp where job =‘CLERK‘";

ps=conn.prepareStatement(sql);

rs=ps.executeQuery();while(rs.next()){

System.out.println("ename is : " + rs.getString("ename"));

}

System.out.println("End@@@");

}catch(ClassNotFoundException e) {

e.printStackTrace();}finally {

try {    if (rs != null) {rs.close();}}

finally {

try {if (ps != null) {ps.close();}}

finally {if (conn != null) {conn.close();}

}

}

}

}

如果sql="select count(*) from items";

则使用时

while(rs.next()){

System.out.println(rs.getInt(1));

}

jdbc -- 001 -- 一般方式创建数据库连接(oracle/mysql)

标签：创建数据库   exec   加载   ace   out   数据库   com   strong   except

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

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