package xwfb;
import java.sql.*;
public class commentDB
{
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE";
String DBUser = "jerry";
String DBPsw = "123456";
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
private Connection initDB()
{
try
{
Class.forName(DBDriver);
return DriverManager.getConnection(DBUrl,DBUser,DBPsw);
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
public int addComment(commentTable ctable)
{
try
{
conn = this.initDB();
String sql = "select MAX(id) from XWFB_COMMENT where news_id = ?";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.setString(1,ctable.getNewsid());
rs = stmt.executeQuery();
int d = 0;
if(rs.next())
{
d = rs.getInt(1) + 1;
}
sql = "insert into XWFB_COMMENT(id,news_id,author,comment_author,comment_content,comment_date) values(?,?,?,?,?,?)";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.setInt(1,d);
stmt.setString(2,ctable.getNewsid());
stmt.setString(3,ctable.getAuthor());
stmt.setString(4,ctable.getCommentauthor());
stmt.setString(5,ctable.getCommentcontent());
stmt.setString(6,ctable.getCommentdate());
stmt.executeUpdate();
return 1;
}
catch(Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
rs.close();
conn.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
/*
public int editNews(newsTable ntable)
{
try
{
conn = this.initDB();
String sql = "update XWFB_NEWS set title=?,content =?,editor=?,editor_time=?,where id =?";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.setString(1,ntable.getTitle());
stmt.setString(2,ntable.getContent());
stmt.setString(3,ntable.getEditor());
stmt.setString(4,ntable.getEditortime());
stmt.setString(5,ntable.getId());
stmt.executeUpdate();
return 1;
}
catch(Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
conn.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
*/
public int deleteNews(String [] id, String newsid)
{
try
{
for(int i=0; i<id.length; i++)
{
String sql = "delete from XWFB_COMMENT where news_id = "+newsid+" and news_id ="+id[i];
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.executeUpdate();
}
return 1;
}
catch(Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
conn.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
}
jsp+oracle新闻发布系统源码
4星 · 超过85%的资源 需积分: 0 95 浏览量
2008-07-21
09:26:50
上传
评论 1
收藏 40KB RAR 举报 
jsp+oracle新闻发布系统源码.rar （40个子文件） 
jsp+oracle新闻发布系统源码 
login.jsp 1KB delete_news.jsp 3KB css style.css 3KB user_deal.jsp 1KB WEB-INF web.xml 382B classes newsDB.java 3KB newsTable.java 1KB commentTable.java 1KB commentDB.java 3KB xwfb connectDB.class 2KB commentDB.class 3KB commentTable.class 1KB newsDB.class 3KB newsTable.class 1KB connectDB.java 1KB index.jsp 3KB modify_news.jsp 3KB admin.jsp 3KB image 
login.gif 1KB Thumbs.db 12KB reg.gif 1KB search serach_list.jsp 2KB search.jsp 861B comment_modify.jsp 562B comment_deal.jsp 0B register.jsp 2KB top_index.jsp 2KB add.jsp 1KB modify.jsp 2KB error.jsp 331B update.jsp 2KB deal.jsp 2KB 数据库 xwfb_table.sql 6KB comment_admin.jsp 2KB
index.html 822B comment_add.jsp 984B logout.jsp 269B left_index.jsp 2KB delete.jsp 738B detail.jsp 4KB
评论3