<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,org.loushang.waf.ComponentFactory,javax.sql.DataSource,javax.naming.*"%>
<%@ page import="java.sql.*"%>
<%Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
String url="jdbc:db2:cqyancao";
//pubs为你的数据库的
String user="db2admin";
String password="admin";
Connection conn= DriverManager.getConnection(url,user,password);
PreparedStatement ps=conn.prepareStatement("select * from yc_news");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println(rs.getString("NEWS_TITLE"));
}
rs.close();
ps.close();
conn.close();
%>
<%@ page import="java.sql.*,org.loushang.waf.ComponentFactory,javax.sql.DataSource,javax.naming.*"%>
<%@ page import="java.sql.*"%>
<%Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
String url="jdbc:db2:cqyancao";
//pubs为你的数据库的
String user="db2admin";
String password="admin";
Connection conn= DriverManager.getConnection(url,user,password);
PreparedStatement ps=conn.prepareStatement("select * from yc_news");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println(rs.getString("NEWS_TITLE"));
}
rs.close();
ps.close();
conn.close();
%>