登录页面asp和jsp相互转化的问题

Question

你写的asp我看不明白，不知道如何转化，这是一个登录，自己凑合看吧
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<%
java.util.Date lasttime=new java.util.Date();
String lastlogintime=lasttime.toLocaleString();
String uname=request.getParameter("username");
String pwd=request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:board","board","board");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from b_user where u_name=\'"+uname+"\' and u_pwd=\'"+pwd+"\'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
String u_id=rs.getString("u_id");
String forbid=rs.getString("u_forbid");
String msg=null;
try
{
msg=rs.getString("u_message");
}
catch(Exception e)
{
}
stmt.executeUpdate("update b_user set u_lastlogintime=\'"+lastlogintime+"\',u_viwecounter=u_viwecounter+1 where u_name=\'"+uname+"\'");
session.setAttribute("userid",u_id);
session.setAttribute("username",uname);
if(msg!=null)
{
session.setAttribute("msg",msg);
}
if(forbid.compareTo("0")==0)
{
session.setAttribute("forbid","yy");
}
stmt.close();
conn.close();
response.sendRedirect("board.jsp");
//&micro;&Ccedil;&Acirc;&frac12;&sup3;&Eacute;&sup1;&brvbar;

}
else
{
stmt.close();
conn.close();
response.sendRedirect("sorry.htm");
}
%>