?? newslist.java
字號:
package mypackage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;
public class NewsList extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
//聲明變量并初始化
String id = null;
String title = null;
String date = null;
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:MyDB";
String sql = "select * from news";
ConnectionDB db = new ConnectionDB();
ResultSet rs = db.executeQuery(sql);
//輸出HTML
out.println("<html>");
out.println("<head><title>NewsList</title></head>");
out.println("<body>");
out.println("<table width=70% border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#999999>");
out.println("<tr>");
out.println("<td width=48% bgcolor=#FFFFFF>>>新聞列表:</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=240 colspan=2 align=center bgcolor=#FFFFFF>");
out.println("<table width=98% cellpadding=0 cellspacing=1 bgcolor=#999999>");
try{
while(rs.next()){
title = rs.getString("title");
date = rs.getString("addtime");
id = rs.getString("id");
out.println("<tr>");
out.println("<td bgcolor=#FFFFFF><a href=NewsDetail?id="+id+">"+title+"</a></td>");
out.println("<td bgcolor=#FFFFFF>"+date+"</td>");
out.println("</tr>");
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
finally{
db.CloseDataBase();
}
out.println("</table>");
out.println("</td>");
out.println("</tr>");
out.println("</body></html>");
out.close();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -