📄 frame.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import=" java.lang.* " %>
<%@ page import=" java.sql.*"%>
<%@ page import="java.util.*" %>
<HTML>
<HEAD>
<TITLE>JSP 聊天室 --中央大厅--</TITLE>
<META NAME="Author" CONTENT="jj">
</HEAD>
<%
String spath = "chat.mdb";
String user = "";
String password = "";
String dbpath = application.getRealPath(spath);
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
String pass="";
String sex="";
String qq="";
String face="";
String email="";
boolean ismember=false;//varirable defination
String name=request.getParameter("userid");
String code=request.getParameter("password");
session.setAttribute("password",code);
byte[] temp = name.getBytes("iso8859-1");
name= new String(temp); //get parameter
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection(url);//link database
Statement s = c.createStatement();
ResultSet r =s.executeQuery("SELECT * FROM chat where Nickname='"+name+"'"); // query user
while(r.next())
{
ismember=true;
pass=r.getString("Password");
face= r.getString("Face");
sex = r.getString("Sex");
qq = r.getString("QQ") ;
email = r.getString("Email");
} // get user's information
}catch(SQLException e){}
if (ismember==true)
{ // user is a registed user
if (code.equals(pass))
{
session.putValue("userid",name);
session.putValue("QQ",qq);
session.putValue("Sex",sex);
session.putValue("Email",email);
session.putValue("Face",face); //save user's information in //session
Hashtable userlist =(Hashtable)application.getAttribute("userlist");
if (userlist==null)
userlist = new Hashtable();
userlist.put(name,name+"++"+face+"++"+sex+"++"+qq+"++"+email);
application.setAttribute("userlist",userlist);//insert uer's infomation into userlist (Hashtable)
%>
<FRAMESET COLS="*,200" >
<FRAMESET ROWS="*,118" >
<FRAME SRC="receive.jsp" NAME="receivemessage" noresize frameborder=0 >
<FRAME SRC="send.jsp" NAME="sendmessage" noresize frameborder=0 >
</FRAMESET>
<FRAME SRC="getinfo.jsp" NAME="memberInfo" noresize frameborder=0 >
<noframes>
<BODY>
<H1>浏览器不支持框架多页面显示，建议使用IE v4.0以上版本。谢谢你的支持！</H1>
</BODY>
</noframes>
</FRAMESET>
<%
} else
{ %>
<BODY bgcolor=#99CCFF><BR><BR>
<FONT SIZE="4" COLOR=""><CENTER>密码错误，请<A HREF="login.jsp">重新登录</A>。</CENTER></FONT></BODY>
<% }
} else
{ %>
<BODY bgcolor=#99CCFF><BR><FONT SIZE="4" COLOR=""><CENTER>会员<%= name %>不存在，请<A HREF="apply.jsp">注册新会员</A>。</CENTER></FONT></BODY >
<% }
%>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -