📄 test3.jsp
字号:
<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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -