package servlet;
import javaBean.DJTUskins;
import java.lang.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class HandleDJTUskins extends HttpServlet{
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
Connection con;
Statement sql;
ResultSet rs;
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=DJTUskins";
String user="hss";
String userPwd="123456";
// Connection dbcon=DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("successful");
String userName=request.getParameter("userName").trim();
String passWord=request.getParameter("passWord").trim();
// String url="jdbc:sqlserver://localhost:1433;DatabaseName=DJTUskins";
System.out.println("4");
//boolean boo=userName.length()>0&&passWord.length()>0;
try {
con=DriverManager.getConnection(dbURL,user,userPwd);
System.out.println("9");
//String condition="select * from User where userName='"+userName+"'and passWord='"+passWord+"'";
sql=con.createStatement();
boolean boo=userName.length()>0&&passWord.length()>0;
if(boo) {
System.out.println("6");
rs=sql.executeQuery("select * from Users where usenumber='321'");
//rs=sql.executeQuery("SELECT * FROM User WHERE userName=\'"+userName+"\'and passWord=\'"+passWord+"\'");
System.out.println("5");
boolean m=rs.next();
if(m==true) {
RequestDispatcher dispatcher=request.getRequestDispatcher("DJTUskins.jsp");
dispatcher.forward(request, response);
}
else {
String backNews="wrong";
System.out.println("1");
fail(request,response,backNews);
}
}
else {
String backNews="input please";
System.out.println("2");
fail(request,response,backNews);
}
con.close();
}
catch(SQLException exp) {
String backNews=""+exp;
System.out.println("3");
fail(request,response,backNews);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
doPost(request,response);
}
public void fail(HttpServletRequest request,HttpServletResponse response,String back) {
response.setContentType("text/html;charset=utf-8");
DJTUskins userNameBean=null;
HttpSession session = request.getSession(true);
try { userNameBean=(DJTUskins)session.getAttribute("userNameBean");
if(userNameBean==null) {
userNameBean = new DJTUskins();
session.setAttribute("userNameBean", userNameBean);
userNameBean=(DJTUskins)session.getAttribute("userNameBean");
}
userNameBean.setBackNews(back);
}catch(Exception exp) {}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/81362.html
標籤：疑難問題