ITPub博客

首页 > Linux操作系统 > Linux操作系统 > JBuilderw中输入用户名密码比较SQL用户名密码应该怎么写代码?

JBuilderw中输入用户名密码比较SQL用户名密码应该怎么写代码?

原创 Linux操作系统 作者:rain0903 时间:2019-06-27 14:30:04 0 删除 编辑

String str1=(String)request.getParameter("name1");
String str2=(String)request.getParameter("name2");

Connection conn=null;
Statement sta=null;
ResultSet re=null;
Statement st=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Administrivia");
sta = conn.createStatement();
String sql="select * from hao";
re=sta.executeQuery(sql);


} catch (SQLException ex) {
} catch (ClassNotFoundException ex) {
}

int n=0;
String s[] = new String[2];
try {

while (re.next()) {
s[0] = re.getString("id");
s[1] = re.getString("mima");
n++;
String ss[]=new String[2];
ss[0]=s[0].trim();
ss[1]=s[1].trim();
for(int t=0;t<=n;t++){
if(ss[0].equals(str1)&&ss[1].equals(str2)){
response.sendRedirect("ok.jsp");
break;
}
else
response.sendRedirect("error.jsp");
}

}
} catch (SQLException ex1) {
}
}

已离线
短消息 发送邮件
多重引用 - 选中要回复的帖子后,点击旁边的回复按钮进行回复 引用回复 返回顶部
Tanya级别:24 | 在线时长:692小时 | 升级还需:33小时级别:24 | 在线时长:692小时 | 升级还需:33小时级别:24 | 在线时长:692小时 | 升级还需:33小时
☆☆☆☆☆☆☆☆
********



会员等级: 总版主
发帖数量: 1,063
精华数量: 0
所持现金: 637NB
银行状态:正常
用户积分: 5
来自: 江苏
注册日期: 2006-05-01

论坛建设奖 最佳创作奖 论坛卫士奖 帅哥专用章
2007-04-20 22:04

servlet

代码: [ 复制到剪贴板 ]
package XXXXXXX; //包名

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;

public class adminLoginServ extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
AdminBean admin=new AdminBean();
List list=new ArrayList();
List list1=new ArrayList();

public void init() throws ServletException {
}

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
//PrintWriter out = response.getWriter();
//User user = new User();
String name = request.getParameter("adminName");
String pass = request.getParameter("adminPass");
String val = request.getParameter("adminVal");
String val1 = (String)request.getSession().getAttribute("flag");
//System.out.println(name+pass+val+val1);
byte[] a = name.getBytes("ISO-8859-1");
byte[] b = pass.getBytes("ISO-8859-1");
byte[] c = val.getBytes("ISO-8859-1");
name = new String(a);
pass = new String(b);
val = new String(c);
if (val.equals("")){
response.sendRedirect("Errer.jsp?errer=1");
}
else{
if(val.equals(val1)){
if (name.equals("") || pass.equals(""))
response.sendRedirect("Errer.jsp?errer=3");
else{
String sql = "select * from admin where admin='" + name +
"' and adminpass='" + pass + "'";
list = admin.getList(sql);
if (list.equals(list1))
response.sendRedirect("Errer.jsp?errer=3");
else{
response.sendRedirect("admin_Manager.jsp");
request.getSession().setAttribute("loginin",name);
}
}

}
else
response.sendRedirect("Errer.jsp?errer=2");
}

}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
//Clean up resources
public void destroy() {
}
}


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7178747/viewspace-160923/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2006-04-07

  • 博文量
    708
  • 访问量
    620110