📄 dologin.java
字号:
package project1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.*;
import javax.servlet.http.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class dologin extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GB18030";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void service(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>dologin</title></head>");
out.println("<body>");
String dbUrl="jdbc:odbc:myaddressbook"; //addressbook是odbc数据源名称
String username,pwd;
username=request.getParameter("username");
out.print(username);
pwd=request.getParameter("password");
out.print(pwd);
Connection conn;
PreparedStatement pst;
try{
//装载JDBC驱动程序;
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
DriverManager.registerDriver(new JdbcOdbcDriver());
////以上两个语句可以互换////
//创建一个数据库连接；
conn=DriverManager.getConnection(dbUrl);
//组装标准的SQL语句
pst=conn.prepareStatement("select * from user where username=? and password=?");
pst.setString(1,username);
pst.setString(2,pwd);
//执行SQL语句
ResultSet rs=pst.executeQuery();
if (rs.next())
{
request.getSession().setAttribute("token", username);
out.print("祝贺你！身份验证成功！！<br>");
response.setHeader("Refresh","0;URL=index.jsp");
} else {
out.print("身份验证不成功！");
response.setHeader("Refresh","2;URL=login.jsp");
}
// 回收连接资源
pst.close();
conn.close();
}catch (Exception ex) {
out.print("<p align=center><font size=5 color=red>身份验证不成功！</font></p>");
ex.printStackTrace();
}
out.println("</body></html>");
out.close();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -