dim class_id,mun,tow
Sub news(class_id,mun,top)
set rs=server.createobject("adodb.recordset")
sql="select top "&top&" id,news_name,news_text,news_time,news_hit from news_info where news_class2 = '"&class_id&"' and news_validate = 0 order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有记录"
'response.End()
end if
do while not (rs.eof)
response.write "<table width='100%' border='0' cellspacing='0' cellpadding='0'>"
response.write "<tr>"
response.write "<td width='8%' align='center' class='font'>·</td>"
response.write "<td height='20' class='font'><a href='index_wen.asp?id="&rs("id")&"'>"&len_game(rs("news_name"),mun)&" "&date_time(rs("news_time"),rs("news_time"),rs("news_time"))&"</a>"
if year(rs("news_time")) &"-"& month(rs("news_time")) &"-"& day(rs("news_time")) = CStr(date) then response.write "<image src='../images/new.gif'>" end if
response.write "</td>"
response.write "</tr>"
response.write "</table>"
rs.movenext
loop
rs.close
End Sub
上面是ASP写的 请问JSP怎么写?麻烦帮写下 谢了~~
Sub news(class_id,mun,top)
set rs=server.createobject("adodb.recordset")
sql="select top "&top&" id,news_name,news_text,news_time,news_hit from news_info where news_class2 = '"&class_id&"' and news_validate = 0 order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有记录"
'response.End()
end if
do while not (rs.eof)
response.write "<table width='100%' border='0' cellspacing='0' cellpadding='0'>"
response.write "<tr>"
response.write "<td width='8%' align='center' class='font'>·</td>"
response.write "<td height='20' class='font'><a href='index_wen.asp?id="&rs("id")&"'>"&len_game(rs("news_name"),mun)&" "&date_time(rs("news_time"),rs("news_time"),rs("news_time"))&"</a>"
if year(rs("news_time")) &"-"& month(rs("news_time")) &"-"& day(rs("news_time")) = CStr(date) then response.write "<image src='../images/new.gif'>" end if
response.write "</td>"
response.write "</tr>"
response.write "</table>"
rs.movenext
loop
rs.close
End Sub
上面是ASP写的 请问JSP怎么写?麻烦帮写下 谢了~~
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String ConnStr="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Program Files\\Apache Software Foundation\\Tomcat 6.0\\webapps\\myweb\\datebase.mdb";
Connection con = DriverManager.getConnection(ConnStr);
String scribe;
byte[] temp;
scribe = request.getParameter("name1");
temp = scribe.getBytes("iso8859-1");
scribe = new String(temp);
String name = scribe;
PreparedStatement stat=con.prepareStatement(
"select * from show ");
ResultSet result=stat.executeQuery();while(result.next()){
out.print(result.getString(1));}
result.close();
stat.close();
con.close();}
catch(Exception e)
{
out.println(e);
} 试试
是不是想要的?
.........