文件名称 123.jsp <%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GB2312" contentType="text/html"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerP ort()+path+"/"; %>
<%!public String codeToString(String str) { String s=str; try{ byte tempB[]=s.getBytes("ISO-8859-1"); s=new String(tempB); return s; } catch(Exception e) {
return s; } } %>
-->
<%out.println("你输入的账户 为:"+codeToString(request.getParameter("username"))); out.println("你输入的密码为: "+codeToString(request.getParameter("userpassword"))); %> <% Statement statement; ResultSet rs;
// 加载驱动程序以连接数据库 try { Class.forName("com.mysql.jdbc.Driver"); Connection connection = DriverManager.getConnection("jdbc:
mysql://localhost:3306/hacker", "root", "root"); System.out.println("连接成功"); statement=connection.createStatement(); rs=statement.executeQuery("select pass
word from user where username="+"'"+request.getParameter("username")+"'"); if(rs.next()) { String bb = rs.getString("password"); System.out.println("tongguo"); if(request.getParameter("userpassword").equals(bb)) out.println("登陆成功"); } else out.println("
登陆失败");
connection.close(); } // 捕获加载驱动
程序异常 catch (ClassNotFoundException cnfex) { System.err.println("装载 JDBC/ODBC 驱动程序失败。"); // cnfex.printStackTrace(); //System.exit(1); // terminate program } // 捕获连接数据库异常 catch (SQLException
sqlex) { System.err.println("无法连接数据库"); //sqlex.printStackTrace(); //System.exit(1); // terminate program
} %>