<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://102.168.10.53:1433;DatabaseName=database_portal";
String user="sa";
String password="paw";
Connection conn= DriverManager.getConnection(url,user,password);
PreparedStatement ps=conn.prepareStatement("select NEWSTITLE from c_news");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println(rs.getString("NEWSTITLE"));
}
rs.close();
ps.close();
conn.close();
%>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://102.168.10.53:1433;DatabaseName=database_portal";
String user="sa";
String password="paw";
Connection conn= DriverManager.getConnection(url,user,password);
PreparedStatement ps=conn.prepareStatement("select NEWSTITLE from c_news");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println(rs.getString("NEWSTITLE"));
}
rs.close();
ps.close();
conn.close();
%>