基于jsp实现新闻管理系统 附完整

String url = "jdbc:oracle:thin:@localhost:1521:orcl";

conn = DriverManager.getConnection(url, "scott", "wjk139");//不安全

//运行SQL语句

Statement stat = conn.createStatement();

String sql = "select * from newmessage where newsid=?";//获取newsid，使用？代替字符串，以免会发生错误

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, Integer.valueOf(newsid));

ResultSet rs = ps.executeQuery();// 之前已经给了sql字符串，所以executeUpdate是无参的。

while (rs.next()) { //实例化VO

NewsRealese news = new NewsRealese();