<%
String name=request.getParameter("name");
String mypassword=request.getParameter("mypassword");
DBconnection dbUtil=new DBconnection();
ResultSet rs=null;
String sql="select * from USERS where U_NAME='"+name+"'";
rs=dbUtil.executeQuery(sql);
String U_PASSWORD ="";
String U_NAME = "";
String U_DEPARTMENT ="";
String U_PASSWORD_QUESTION ="";
String U_PASSWORD_ANWSER ="";
String U_N_VIEW ="";
String U_N_MODIFY ="";
String U_N_CHECK ="";
String U_N_DELETE ="";
String U_A_VIEW ="";
String U_A_MODIFY ="";
String U_A_CHECK ="";
String U_A_DELETE ="";
String U_U_ADD ="";
String U_U_QXMANAGE ="";
String U_U_MANAGE ="";
String U_N_ADD ="";
String U_A_ADD ="";
try{
while(rs.next())
{
//String U_A_VIEW=session.getAttribute("U_A_VIEW").toString();
U_PASSWORD =rs.getString("U_PASSWORD");
U_NAME = rs.getString("U_NAME");
U_DEPARTMENT =rs.getString("U_DEPARTMENT");
U_PASSWORD_QUESTION =rs.getString("U_PASSWORD_QUESTION");
U_PASSWORD_ANWSER =rs.getString("U_PASSWORD_ANWSER");
U_N_VIEW =rs.getString("U_N_VIEW");
U_N_MODIFY =rs.getString("U_N_MODIFY");
U_N_CHECK =rs.getString("U_N_CHECK");
U_N_DELETE =rs.getString("U_N_DELETE");
U_A_VIEW =rs.getString("U_A_VIEW");
U_A_MODIFY =rs.getString("U_A_MODIFY");
U_A_CHECK =rs.getString("U_A_CHECK");
U_A_DELETE =rs.getString("U_A_DELETE");
U_U_ADD =rs.getString("U_U_ADD");
U_U_QXMANAGE =rs.getString("U_U_QXMANAGE");
U_U_MANAGE =rs.getString("U_U_MANAGE");
U_N_ADD =rs.getString("U_N_ADD");
U_A_ADD =rs.getString("U_A_ADD");
out.print(U_NAME);
//out.println(dbUtil.formatString(rs.getString("U_NAME")));
if((mypassword.equals(U_PASSWORD)))
{%>
<%out.print(name);%><%out.print("你已经成功登录");%>
<%} //if完成
else{%>
<%out.print("你的密码错误,请重新登录");%>
<td height="17" align="center" nowrap="nowrap" bgcolor="9dd7fd">用户名:</td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input name="name" type="text" size="12" /></td>
<td align="center" nowrap="nowrap" bgcolor="9dd7fd">密码:</td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input name="mypassword" type="password" size="12" /></td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input value="登录" type="submit" name="Submit" /> </td>
<td nowrap="nowrap" bgcolor="9dd7fd"><img src="images/lostpassword02.gif" alt="?" width="74" height="20" /></td>
<td align="center" nowrap="nowrap" bgcolor="9dd7fd">新用户注册</td>
<%} //else完成
}//while完成
dbUtil.sqlclose();
}catch(Exception ex){ }
//out.println(ex.getMessage());}
//<%if(==t){重要***
%>
<%
session.setAttribute("U_NAME",U_NAME);
//out.print(U_NAME);
session.setAttribute("U_DEPARTMENT",U_DEPARTMENT);
session.setAttribute("U_PASSWORD_QUESTION",U_PASSWORD_QUESTION);
session.setAttribute("U_PASSWORD_ANWSER",U_PASSWORD_ANWSER);
session.setAttribute("U_N_VIEW",U_N_VIEW);
session.setAttribute("U_N_MODIFY",U_N_MODIFY);
session.setAttribute("U_N_CHECK",U_N_CHECK);
session.setAttribute("U_N_DELETE",U_N_DELETE);
session.setAttribute("U_A_VIEW",U_A_VIEW);
session.setAttribute("U_A_MODIFY",U_A_MODIFY);
session.setAttribute("U_A_CHECK",U_A_CHECK);
session.setAttribute("U_A_DELETE",U_A_DELETE);
session.setAttribute("U_U_ADD",U_U_ADD);
session.setAttribute("U_U_QXMANAGE",U_U_QXMANAGE);
session.setAttribute("U_U_MANAGE",U_U_MANAGE);
session.setAttribute("U_N_ADD",U_N_ADD);
session.setAttribute("U_A_ADD",U_A_ADD);
%>
</tr>
<tr>
<td width="120" height="17" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-1.jpg" width="120" height="17" /></td>
<td width="120" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-0.jpg" width="120" height="17" /></td>
<td width="120" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-2.jpg" width="120" height="17" /></td>
<td width="120" align="center" nowrap="nowrap" bgcolor="9dd7fd"><p><img src="images/mine1-3.jpg" width="120" height="17" /></p>
</td>
</tr>
<tr>
<td height="33" colspan="8"><%out.print(U_NAME);%><%out.print(U_DEPARTMENT);%><%=session.getAttribute("U_DEPARTMENT")%>
<%=session.getAttribute("U_N_MODIFY")%>
</td>
**********************当在另一个页面中来获得上面页的session值是,为什么得不到
输出内容是空白的,但是也不报错
如:另一页中代码为:
<%
String U_A_VIEW=session.getAttribute("U_A_VIEW").toString();
%>
<%out.print(U_A_VIEW);%>
执行结果什么也不输出啊??
为什么呀??还有就是在当前页中执行<%=session.getAttribute("U_N_MODIFY")%>
时,也是什么也不输出呀,是空白的,不知道为什么大家帮忙看看吧!
谢谢!!
String name=request.getParameter("name");
String mypassword=request.getParameter("mypassword");
DBconnection dbUtil=new DBconnection();
ResultSet rs=null;
String sql="select * from USERS where U_NAME='"+name+"'";
rs=dbUtil.executeQuery(sql);
String U_PASSWORD ="";
String U_NAME = "";
String U_DEPARTMENT ="";
String U_PASSWORD_QUESTION ="";
String U_PASSWORD_ANWSER ="";
String U_N_VIEW ="";
String U_N_MODIFY ="";
String U_N_CHECK ="";
String U_N_DELETE ="";
String U_A_VIEW ="";
String U_A_MODIFY ="";
String U_A_CHECK ="";
String U_A_DELETE ="";
String U_U_ADD ="";
String U_U_QXMANAGE ="";
String U_U_MANAGE ="";
String U_N_ADD ="";
String U_A_ADD ="";
try{
while(rs.next())
{
//String U_A_VIEW=session.getAttribute("U_A_VIEW").toString();
U_PASSWORD =rs.getString("U_PASSWORD");
U_NAME = rs.getString("U_NAME");
U_DEPARTMENT =rs.getString("U_DEPARTMENT");
U_PASSWORD_QUESTION =rs.getString("U_PASSWORD_QUESTION");
U_PASSWORD_ANWSER =rs.getString("U_PASSWORD_ANWSER");
U_N_VIEW =rs.getString("U_N_VIEW");
U_N_MODIFY =rs.getString("U_N_MODIFY");
U_N_CHECK =rs.getString("U_N_CHECK");
U_N_DELETE =rs.getString("U_N_DELETE");
U_A_VIEW =rs.getString("U_A_VIEW");
U_A_MODIFY =rs.getString("U_A_MODIFY");
U_A_CHECK =rs.getString("U_A_CHECK");
U_A_DELETE =rs.getString("U_A_DELETE");
U_U_ADD =rs.getString("U_U_ADD");
U_U_QXMANAGE =rs.getString("U_U_QXMANAGE");
U_U_MANAGE =rs.getString("U_U_MANAGE");
U_N_ADD =rs.getString("U_N_ADD");
U_A_ADD =rs.getString("U_A_ADD");
out.print(U_NAME);
//out.println(dbUtil.formatString(rs.getString("U_NAME")));
if((mypassword.equals(U_PASSWORD)))
{%>
<%out.print(name);%><%out.print("你已经成功登录");%>
<%} //if完成
else{%>
<%out.print("你的密码错误,请重新登录");%>
<td height="17" align="center" nowrap="nowrap" bgcolor="9dd7fd">用户名:</td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input name="name" type="text" size="12" /></td>
<td align="center" nowrap="nowrap" bgcolor="9dd7fd">密码:</td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input name="mypassword" type="password" size="12" /></td>
<td nowrap="nowrap" bgcolor="9dd7fd"><input value="登录" type="submit" name="Submit" /> </td>
<td nowrap="nowrap" bgcolor="9dd7fd"><img src="images/lostpassword02.gif" alt="?" width="74" height="20" /></td>
<td align="center" nowrap="nowrap" bgcolor="9dd7fd">新用户注册</td>
<%} //else完成
}//while完成
dbUtil.sqlclose();
}catch(Exception ex){ }
//out.println(ex.getMessage());}
//<%if(==t){重要***
%>
<%
session.setAttribute("U_NAME",U_NAME);
//out.print(U_NAME);
session.setAttribute("U_DEPARTMENT",U_DEPARTMENT);
session.setAttribute("U_PASSWORD_QUESTION",U_PASSWORD_QUESTION);
session.setAttribute("U_PASSWORD_ANWSER",U_PASSWORD_ANWSER);
session.setAttribute("U_N_VIEW",U_N_VIEW);
session.setAttribute("U_N_MODIFY",U_N_MODIFY);
session.setAttribute("U_N_CHECK",U_N_CHECK);
session.setAttribute("U_N_DELETE",U_N_DELETE);
session.setAttribute("U_A_VIEW",U_A_VIEW);
session.setAttribute("U_A_MODIFY",U_A_MODIFY);
session.setAttribute("U_A_CHECK",U_A_CHECK);
session.setAttribute("U_A_DELETE",U_A_DELETE);
session.setAttribute("U_U_ADD",U_U_ADD);
session.setAttribute("U_U_QXMANAGE",U_U_QXMANAGE);
session.setAttribute("U_U_MANAGE",U_U_MANAGE);
session.setAttribute("U_N_ADD",U_N_ADD);
session.setAttribute("U_A_ADD",U_A_ADD);
%>
</tr>
<tr>
<td width="120" height="17" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-1.jpg" width="120" height="17" /></td>
<td width="120" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-0.jpg" width="120" height="17" /></td>
<td width="120" colspan="2" align="center" nowrap="nowrap" bgcolor="9dd7fd"><img src="images/mine1-2.jpg" width="120" height="17" /></td>
<td width="120" align="center" nowrap="nowrap" bgcolor="9dd7fd"><p><img src="images/mine1-3.jpg" width="120" height="17" /></p>
</td>
</tr>
<tr>
<td height="33" colspan="8"><%out.print(U_NAME);%><%out.print(U_DEPARTMENT);%><%=session.getAttribute("U_DEPARTMENT")%>
<%=session.getAttribute("U_N_MODIFY")%>
</td>
**********************当在另一个页面中来获得上面页的session值是,为什么得不到
输出内容是空白的,但是也不报错
如:另一页中代码为:
<%
String U_A_VIEW=session.getAttribute("U_A_VIEW").toString();
%>
<%out.print(U_A_VIEW);%>
执行结果什么也不输出啊??
为什么呀??还有就是在当前页中执行<%=session.getAttribute("U_N_MODIFY")%>
时,也是什么也不输出呀,是空白的,不知道为什么大家帮忙看看吧!
谢谢!!
解决方案 »
- java中怎么将http协议转成https协议?
- hibernate annotation映射
- jQuery Ajax返回不了数据。。。
- myeclipse+struts+tomcat的问题
- webdav 客户端开发的问题
- 求助关于@hibernate 多对多的用法
- 请问如何知道用户关闭了浏览器,用户关闭浏览器窗口时能否用程序通知SERVER,就像窗口的CLOSE事件一样???
- servlet编译出错
- 问个简单的问题(关于下拉框)!
- 无法将类型为“Excel.ApplicationClass”的 COM 对象强制转换为接口类型“Excel._Application”。
- 如何让生成的JFrame始终前端显示?
- 如何实现在一个IE中实现多用户登录
↑在前面加上、「getAttribute」是取对象,类型不明!
System.out.println("==========");
System.out.println("=="+U_N_MODIFY+"==");
System.out.println("==========");session.setAttribute("U_N_MODIFY",U_N_MODIFY);后加打印,看看设值结果
System.out.println("==========");
System.out.println("=="+session.getAttribute("U_N_MODIFY").toString()+"==");
System.out.println("==========");
有一个变量U_PASSWORD_ANWSER的名字写错了,应该是:U_PASSWORD_ANSWER
所以下面语句:
U_PASSWORD_ANWSER =rs.getString("U_PASSWORD_ANWSER");
之后的所有语句没有执行成功,所以就得不到值了吧
都怪我太粗心了!!
看代码好累呀...
可以插入空值吗?
应该写成:
String a=null;
还是:
String a="";
哪一种比较好??
自然写String a="";插null等于没查,这么做没意义
大个比方比如student表有三个字段id ,name,email
你写
insert into student values("01","Lee",null);
和
insert into student(id,name) values("01","Lee")一回事
但是如果取值的话
如果是null是不是取不出来??
如果是""
取出来的也相当于是个字符串""吧??
可以认为取出的内容就是null