try
{
String sql="select * from user where name='" + name + "' and pass='" + pass + "'";
ResultSet rs=reg.executequery(sql);
if(rs.next())
{
String cat=rs.getString("cat");
Cookie User=new Cookie("User",cat);
User.setMaxAge(18000);//设置cookie时间
response.addCookie(User);//添加cookie
rs.close();
rs=null;
response.sendRedirect("edit.jsp?find=");
}
else//登录失败
{
%>
<p> </p><p> </p><p> </p><p> </p><p align="center">用户名或密码错误<br><input type="button" value="返回" onClick="window.history.back();"></p>
<%
rs.close();
rs=null;
reg.closecon();
}
}
catch(SQLException SQLe)
{
SQLe.printStackTrace();
}
%>
{
String sql="select * from user where name='" + name + "' and pass='" + pass + "'";
ResultSet rs=reg.executequery(sql);
if(rs.next())
{
String cat=rs.getString("cat");
Cookie User=new Cookie("User",cat);
User.setMaxAge(18000);//设置cookie时间
response.addCookie(User);//添加cookie
rs.close();
rs=null;
response.sendRedirect("edit.jsp?find=");
}
else//登录失败
{
%>
<p> </p><p> </p><p> </p><p> </p><p align="center">用户名或密码错误<br><input type="button" value="返回" onClick="window.history.back();"></p>
<%
rs.close();
rs=null;
reg.closecon();
}
}
catch(SQLException SQLe)
{
SQLe.printStackTrace();
}
%>
解决方案 »
- 急!!!2个站点之间如何共享用户?
- 要做个网站,请问:可以不用框架,仅在html嵌入java程序可以吗?谢谢
- Java字符串分解,
- Eclipse下log4j的配置问题
- 如何得到一个网页的header信息?
- 谁研究过jasperreports-0.5.2-project的报表制作包,如何修改显示PDF的中文呢?
- 如何将MySQL数据库中的负值读出来?
- 请教一个发群体消息的设计思想
- 为什么我能运行TOMCAT下的examples的servlet却不能运行我自己的servlet
- 为什么会有这样的错误??? 关于jsp中调用javabean的问题...???help me???
- 求爱国歌曲-类似屠洪刚“精忠报国”的
- win2003下配置resin3的问题
<%
String ID=request.getParameter("id");
String psw=request.getParameter("password");
Class.forName("oracle.jdbc.driver.OracleDriver");
String m="jdbc:oracle:thin:@192.168.0.129:1521:webs";
Connection con=DriverManager.getConnection(m,"HF","HF");
Statement st=con.createStatement();
ResultSet str=st.executeQuery("select PASSWORD from HF.MANAGEMENT where ID='"+ID+"'");%>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>cheCk</title>
</head><body background="haha.jpg" bgproperties='fixed'>
<%
if(str.next())
{
if(str.getString("PASSWORD").equals(psw))
{
session.setAttribute("ID",ID);
response.sendRedirect("htgl-main.jsp");
}
else
{%>
<script>
window.alert("输入用户名或密码有误!!");
location="htgl.htm";
</script>
<%}}
else{
%>
<script>
window.alert("输入用户名或密码有误!!");
location="htgl.htm";
</script>
<%}
str.close();
st.close();
con.close();%>
</body>
request.setAttribute("hello_message", "");
String name = request.getParameter("USER_NAME");
String password = request.getParameter("USER_PWD"); DBAccessBean dbaccess = new DBAccessBean();
rs = dbaccess.select_name(name); try {
if (!rs.next()) {
url = "/login.htm";
request.setAttribute("login_message", "name is not exist");
} else {
rs = dbaccess.select(name, password);
if (rs.next()) {
url = "/hello.jsp";
request.setAttribute("hello_message", "login successfully");
}
else {
url = "/login.jsp";
request.setAttribute("login_message", "password is wrong");
} }
ServletContext sc = getServletContext();
RequestDispatcher rd = sc.getRequestDispatcher(sql);
rd.forward(request, response);
}
catch (Exception e) {
e.printStackTrace();
}