test3.jsp
来自「用java编写的通讯录」· JSP 代码 · 共 39 行
JSP
39 行
<html>
your username is :<%=request.getParameter("username") %>
<br><br>
your password is :<%=request.getParameter("password") %>
<br><br>
<%@page language = "java" import = "java.sql.*" %>
<%
String name = request.getParameter("username");
String pass = request.getParameter("password");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbcon=DriverManager.getConnection("jdbc:odbc:jsp1","","");
PreparedStatement stat = dbcon.prepareStatement("select * from jsp1 where name = ? and pass = ?");
stat.setString(1,name);
stat.setString(2,pass);
ResultSet result = stat.executeQuery();
if(result.next())
{
out.println("Login Successful");
session.putValue("name",name);
response.sendRedirect("http://127.0.0.1:8080/jsp/user.jsp");
}
else
{
out.println("Login Error");
session.putValue("name","");
}
}
catch (Exception e)
{
out.println(e);
//e.printStackTrace();
}
%>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?