⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 confirm.jsp

📁 一个使用jdbc存储和调用大对象(比如图片等)的例子
💻 JSP
字号:
<html>
<head>
<title>登录检查</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn =OPDB.getConn();
String regName=request.getParameter("loginName").trim();
String loginName=OPDB.AsciiToChineseString(regName); 
String loginPassword=request.getParameter("loginPassword").trim();
String Name=request.getParameter("userName").trim();
String userType = request.getParameter("userType");
String regname=null;
/*String chatName = (String) session.getValue("Name");
if (chatName != null) {
	out.print("<script>alert(\"请先退出,再登陆!\");window.close();</script>");		
	return;	
}
*/	
if((regName.length()!=0)) {  
	String sql="select userlevel,experience from t_bbs_user where username='"+loginName+"' and password='"+loginPassword+"' and userType = '" + userType + "'";
	ResultSet RS = OPDB.select(conn,sql);
 	if(RS.next()) {
 		
 		if (userType.equals("Y")) {
 			regname = regName + "(会员)";
 		}
 		else {
 			regname = regName;
 		}
 		
 		String userlevel = OPDB.GBK(RS.getString("userlevel"));
 		String experience = RS.getString("experience");
 		session.putValue("userlevel",userlevel);
 		session.putValue("experience",experience);		
		RS.close();
	}
	
	else { 
		RS.close();
		out.print("<script>alert(\"用户名/密码错!\");window.close();</script>");		
		return;		
	}
}

else {
	if((Name.length()<1)||(Name.length()>10)) {
		out.print("<script>alert(\"游客名不能超过6个字长!\");window.close();</script>");
		return;
	}

	Character c=new Character(' ');
	for(int i=0;i<Name.length();i++) {   
		if(Name.charAt(i) == c.charValue()) {
			out.print("<script>alert(\"名字中间不能有空格!\");window.close();</script>");
			return;
		}
	}
}

synchronized (application) {
	Vector UserName=null;  
	UserName= (Vector)application.getAttribute("UserName");
	if(UserName==null) {
		UserName= new Vector(30,10);		     
	}
	if(regname!=null ) {
		UserName.addElement(regname);		
		session.putValue("Name", regname);
	}
	else if(UserName.contains(Name)) {
		out.print("<script>alert(\"你的名字正在被人使用!\");window.close();</script>");
		return;
	}  
	else {
		UserName.addElement(Name+"(过客)");		
		session.putValue("Name", Name+"(过客)");
	}
		
	application.setAttribute("UserName",UserName);		     
	out.print("<script>window.location=\"chat.jsp\"</script>");	
}

%>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -