67,512
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
public class NewsDao {
public void getNewsList() {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try {
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//获得连接
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:webDemo","system","manager");
//获得Statement对象
String sql="select*from news_detail";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
//处理结果集
while(rs.next()){
int id=rs.getInt("id");
String title=rs.getString("title");
String summary=rs.getString("summary");
String content=rs.getString("content");
String author=rs.getString("author");
Timestamp time=rs.getTimestamp("createdate");
System.out.println(id+"\t"+title+"\t"+summary+"\t"+content+"\t"+author+"\t"+time);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String args[]){
NewsDao nd=new NewsDao();
nd.getNewsList();
}
}
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:webDemo
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.pb.news.dao.NewsDao.getNewsList(NewsDao.java:20)
at com.pb.news.dao.NewsDao.main(NewsDao.java:57)
Exception in thread "main" java.lang.NullPointerException
at com.pb.news.dao.NewsDao.getNewsList(NewsDao.java:44)
at com.pb.news.dao.NewsDao.main(NewsDao.java:57)
java.sql.SQLException: ORA-28000: the account is locked
OracleOraDb10g_home2TNSListener 启动的
OracleServiceSHOP 启动的
reate table NEWS_DETAIL(
id number(10,0) NOT NULL PRIMARY KEY, --id
categoryId number(10,0) NOT NULL, --新闻类别id
title varchar2(100) NOT NULL,--新闻标题
summary varchar2(255) NULL, --新闻摘要
content CLOB NULL, --新闻内容
picpath varchar2(255) NULL, --新闻图片路径
author varchar2(50) NULL,--发表者
createdate date NULL, --创建时间
modifydate date NULL, --修改时间
Foreign key(categoryId) references NEWS_CATEGORY(id)
);
String sql="SELECT * FROM news_detail";
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
at com.pb.news.dao.NewsDao.getNewsList(NewsDao.java:24)
at com.pb.news.dao.NewsDao.main(NewsDao.java:57)
Exception in thread "main" java.lang.NullPointerException
at com.pb.news.dao.NewsDao.getNewsList(NewsDao.java:44)
at com.pb.news.dao.NewsDao.main(NewsDao.java:57)