package first;
import java.sql.*;
import javax.sql.*;public class Jdbctest { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try {
//new oracle.jdbc.driver.OracleDriver();
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String dbUsername = "scott";
String dbPassword = "Oracle11g";
conn = DriverManager.getConnection(url,dbUsername,dbPassword);
stmt = conn.createStatement();
String sql = "select ename from employees "+"where deptno = 10";
rs = stmt.executeQuery(sql);
while(rs.next()){
String ename = rs.getString("ename");
//String loc = rs.getString("loc");
System.out.println(ename);
}
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e){
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
stmt.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
conn.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
}
}}
数据库JDBCSQL
import java.sql.*;
import javax.sql.*;public class Jdbctest { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try {
//new oracle.jdbc.driver.OracleDriver();
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String dbUsername = "scott";
String dbPassword = "Oracle11g";
conn = DriverManager.getConnection(url,dbUsername,dbPassword);
stmt = conn.createStatement();
String sql = "select ename from employees "+"where deptno = 10";
rs = stmt.executeQuery(sql);
while(rs.next()){
String ename = rs.getString("ename");
//String loc = rs.getString("loc");
System.out.println(ename);
}
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e){
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
stmt.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
try {
conn.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
}
}}
数据库JDBCSQL
解决方案 »
- java中的对应于VS中ctrl+j的快捷键!
- 如何使用log4j把日志记录到一个动态的根据时间生成的一个文件名的文件中!
- 这个for循环怎么这样用
- installanyshere怎么打包WEB程序?
- 问个问题,怎么能用正则表达式从java程序中提取多段注释?
- 请问一个JAVA反射的问题,现在我知道一个需要建立对象的类名字(String),如何动态建立这个类的对象?
- 关于字符'u0c20'?
- 我一个笨问题,希望大家指教
- J2SE下怎样访问计算机端口?
- destroy()和stop()的区别!!!
- 在线急求,log4j报错
- 【for 初学者】System.out.print和println的确别
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class practice { /**
* oracle有个架包你导入了没有
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection cnn=null;
PreparedStatement prs=null;
ResultSet rs=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";//orcl自己注意下
String username="lmw";//你自己的
String userpwd="s123";//同上
cnn=DriverManager.getConnection(url,username,userpwd);
String sql="select * from zhanghao";
prs=cnn.prepareStatement(sql);
rs=prs.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(prs!=null){
try {
prs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(cnn!=null){
try {
cnn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} }}
http://www.07q.net/read/1707.html只需要把驱动改了就行了
String sql = "select ename from employees "+"where deptno = 10";
rs = stmt.executeQuery(sql);
2.数据库监听开了么?
只是服务开启监听没开也是办不到的
数据库监听? 这个没听说过啊 我学jdbc的时候用的是Mysql数据库 当时没哪步操作需要开数据库监听啊?
数据库监听? 这个没听说过啊 我学jdbc的时候用的是Mysql数据库 当时没哪步操作需要开数据库监听啊?
java连接Oracle时需要开启监听,右键我的电脑-->管理-->服务-->OracleOraDb11g_home1TNSListener开起了么,还有你的表中有满足条件的信息么where deptno = 10