▄◣问一个JSP超级菜鸟的问题 servlet可以javabean可以纯jsp也可以 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 数据库连接方面你可能得你自己改改==========================================package idmanage;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;import idmanage.*;/** * <p>Title: idmanage</p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2004</p> * <p>Company: </p> * @author rainworm * @version 1.0 */public class login extends HttpServlet { static final private String CONTENT_TYPE = "text/html; charset=GBK";public void init() throws ServletException {}public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//从login.htm里获取name和password String name = new String(request.getParameter("name").getBytes("8859_1")); String password = new String(request.getParameter("password").getBytes("8859_1"));boolean existed = checkUser(name);//处理用户名不存在的情况if(!existed){ response.sendRedirect("error.jsp?id=3");}else{ boolean isRight = checkPass(name, password); //处理密码错误情况 if(!isRight) { response.sendRedirect("error.jsp?id=2"); } //如果都用户名密码都正确,转到selectaction.html else { HttpSession usession = request.getSession(true); response.sendRedirect("selectaction.html"); }} } public boolean checkPass(String manager_name, String password) { // 检测密码和数据库密码确认是否一致函数 boolean identical = false;//连接checkmanagerid表获取管理员密码,如正确,返回identical为真 try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:Test"; Connection conn = java.sql.DriverManager.getConnection (url,"aaa","111"); Statement statement=conn.createStatement(); String sql_password = "select * from checkmanagerid where manager_name = '" + manager_name + "'"; ResultSet rs = statement.executeQuery(sql_password); rs.next(); if (password.equals(String.valueOf(rs.getString(2)))) { identical = true; } rs.close(); statement.close(); } catch (Exception ex) { // 处理异常 ex.printStackTrace(); } return identical; } public boolean checkUser(String manager_name) // 检测是否存在用户名函数 { boolean existed = false;//检查checkmanagerid表有无此用户,如有返回true try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:Test"; Connection conn = java.sql.DriverManager.getConnection (url,"aaa","111"); Statement statement=conn.createStatement(); String sql_managername = "select * from checkmanagerid where manager_name = '" + manager_name + "'"; ResultSet rs=statement.executeQuery(sql_managername); if(rs.next()) { existed = true; } rs.close(); statement.close(); conn.close(); } catch(Exception ex) // 处理异常 { ex.printStackTrace(); } return existed; }} 连接数据库的东东,网上到处都是MVC叫做模型视图控制器(model-view-controler)得简称,是一种编程的模式 关于抓取网页后javascrip动态网页代码解析的问题 证书 frame 取值 问题 将Tomcat设置为Window服务,该如何设置呢? 关于Struts中Checkbox与Textarea的使用问题 求助,这段链接数据库代码有什么问题?执行的时候不是每一次都报错 struts的这两个东西不知道是什么意思,请各位高手帮帮忙,谢谢了!!!!!! 求 用SSH开发的 生产订单的 例子 请教:关于jsp和sql server的问题.字段值的读取. 数据库排名问题!急!! 请问怎样把orion集成到eclipse里面? 哪里有这个插件下?谢谢 jsp之初玩
==========================================
package idmanage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import idmanage.*;/**
* <p>Title: idmanage</p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author rainworm
* @version 1.0
*/public class login extends HttpServlet {
static final private String CONTENT_TYPE = "text/html; charset=GBK";
public void init() throws ServletException {
}
public void service(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
//从login.htm里获取name和password
String name = new String(request.getParameter("name").getBytes("8859_1"));
String password = new String(request.getParameter("password").getBytes("8859_1"));
boolean existed = checkUser(name);
//处理用户名不存在的情况
if(!existed)
{
response.sendRedirect("error.jsp?id=3");
}
else
{
boolean isRight = checkPass(name, password);
//处理密码错误情况
if(!isRight)
{
response.sendRedirect("error.jsp?id=2");
}
//如果都用户名密码都正确,转到selectaction.html
else
{
HttpSession usession = request.getSession(true);
response.sendRedirect("selectaction.html");
}
}
}
public boolean checkPass(String manager_name, String password) { // 检测密码和数据库密码确认是否一致函数
boolean identical = false;
//连接checkmanagerid表获取管理员密码,如正确,返回identical为真
try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Test";
Connection conn = java.sql.DriverManager.getConnection (url,"aaa","111");
Statement statement=conn.createStatement(); String sql_password = "select * from checkmanagerid where manager_name = '" +
manager_name + "'";
ResultSet rs = statement.executeQuery(sql_password);
rs.next();
if (password.equals(String.valueOf(rs.getString(2)))) {
identical = true;
}
rs.close();
statement.close();
}
catch (Exception ex) { // 处理异常
ex.printStackTrace();
}
return identical;
} public boolean checkUser(String manager_name) // 检测是否存在用户名函数
{
boolean existed = false;
//检查checkmanagerid表有无此用户,如有返回true
try {
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Test";
Connection conn = java.sql.DriverManager.getConnection (url,"aaa","111");
Statement statement=conn.createStatement(); String sql_managername = "select * from checkmanagerid where manager_name = '" + manager_name + "'";
ResultSet rs=statement.executeQuery(sql_managername);
if(rs.next())
{
existed = true;
}
rs.close();
statement.close();
conn.close();
}
catch(Exception ex) // 处理异常
{
ex.printStackTrace();
}
return existed;
}}