NewsByL新闻信息管理系统
- T5_996951了解作者
- 1.2MB文件大小
- rar文件格式
- 0收藏次数
- VIP专享资源类型
- 0下载次数
- 2022-06-14 21:15上传日期
小型的新闻信息管理系统，可以用于学习jsp+servlet+jstl.里面有附带数据库。
NewsByL.rar
内容介绍
package impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import db.DBConn;
import pojo.MyNew;
public class NewsImpl {
/*更新*/
public static void updateNews(MyNew myNew){
Connection conn=null;
PreparedStatement pre=null;
DBConn conns=new DBConn();
conn=conns.getConnection();
try {
pre=conn.prepareStatement("UPDATE news SET newsInfo=? ,newsWeb=? WHERE id=?");
pre.setString(1, myNew.getNewsInfo());
pre.setString(2, myNew.getNewsWeb());
pre.setInt(3, myNew.getId());
pre.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/*删除*/
/**
* @param sid
*/
public static void deleteNews(int sid){
Connection conn=null;
PreparedStatement pre=null;
DBConn conns=new DBConn();
conn=conns.getConnection();
try {
pre=conn.prepareStatement("DELETE FROM news WHERE id=?");
pre.setInt(1, sid);
pre.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/*查找*/
public static ArrayList<MyNew> queryNews(String newsInfo){
ArrayList<MyNew> myNews=new ArrayList<MyNew>();
Connection conn=null;
PreparedStatement pre=null;
ResultSet rs=null;
DBConn conns=new DBConn();
conn=conns.getConnection();
try {
pre=conn.prepareStatement("SELECT * FROM news WHERE newsInfo LIKE ? order by NewsTime desc");
pre.setString(1, "%"+newsInfo+"%");
rs=pre.executeQuery();
MyNew myNew;
while(rs.next()){
myNew=new MyNew();
myNew.setId(rs.getInt("id"));
myNew.setNewsInfo(rs.getString("newsInfo"));
myNew.setNewsTime(rs.getString("newsTime"));
myNew.setNewsWeb(rs.getString("newsWeb"));
myNews.add(myNew);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return myNews;
}
public static ArrayList<MyNew> allNews(){
ArrayList<MyNew> myNews=new ArrayList<MyNew>();
Connection conn=null;
PreparedStatement pre=null;
ResultSet rs=null;
DBConn conns=new DBConn();
conn=conns.getConnection();
try {
pre=conn.prepareStatement("SELECT * FROM news order by NewsTime desc");
rs=pre.executeQuery();
MyNew myNew;
while(rs.next()){
myNew=new MyNew();
myNew.setId(rs.getInt("id"));
myNew.setNewsInfo(rs.getString("newsInfo"));
myNew.setNewsTime(rs.getString("newsTime"));
myNew.setNewsWeb(rs.getString("newsWeb"));
myNews.add(myNew);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(conn!=null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return myNews;
}
/*增加*/
public void saveNews(MyNew myNew){
Connection conn=null;
PreparedStatement pre=null;
DBConn conns=new DBConn();
conn=conns.getConnection();
try {
pre=conn.prepareStatement("INSERT INTO news (newsInfo,newsWeb) VALUES (?,?)");
pre.setString(1, myNew.getNewsInfo());
pre.setString(2, myNew.getNewsWeb());
pre.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
评论
相关推荐
最新资源