servelt 应用

最新推荐文章于 2024-07-25 22:55:31 发布

wenhuahetao

最新推荐文章于 2024-07-25 22:55:31 发布

阅读量735

点赞数

文章标签： exception import sqlserver microsoft string login

本文链接：https://blog.csdn.net/wenhuahetao/article/details/4648882

版权

LoginCl.java

package com.hetao;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class LoginCl extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res){
   Connection ct=null;
   Statement sm=null;
   ResultSet rs=null;
  try{
   String u=req.getParameter("name");
   String p=req.getParameter("password");

   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

   ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","");
   sm=ct.createStatement();
   rs=sm.executeQuery("select top 1 * from users where username='"+u+"'and password='"+p+"'");
   if(rs.next()){

    HttpSession hs=req.getSession(true);
    hs.setAttribute("pass","ok");
    hs.setMaxInactiveInterval(20);

    res.sendRedirect("wel?un="+u+"&up="+p);

   }
   else{
    res.sendRedirect("login");
   }

  }
  catch(Exception e){
   e.printStackTrace();

  }
  finally{
   try{
    if(rs!=null){
    rs.close();
    }
    if(sm!=null){
    sm.close();
    }
    if(ct!=null){
    ct.close();
    }

   }
   catch(Exception ex){
   ex.printStackTrace();
   }
  }
}

public void doPost(HttpServletRequest req,HttpServletResponse res){
  this.doGet(req,res);

}
}

Wel.java

package com.hetao;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Wel extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res){
   Connection ct=null;
   PreparedStatement ps=null;
   ResultSet rs=null;
   String u=req.getParameter("un");
   String p=req.getParameter("up");
  HttpSession hs=req.getSession(true);
  String val=(String)hs.getAttribute("pass");

   if(val==null){
    try{
     res.sendRedirect("login");
     res.setCharacterEncoding("gbk");

    }
    catch(Exception e){
     e.printStackTrace();
    }



   }
   try{
    int pageSize=3;
    int pageNow=1;
    int rowCount=0;
    int pageCount=0;
    res.setCharacterEncoding("gbk");
    PrintWriter pw=res.getWriter();
    pw.println("<body><center>");
    pw.print("<img src=imgs/2.jpg><br>");
    pw.println("wel,hello<br>");
    pw.println("用户名为 " + u);
    pw.println("<br><a href=login> 返回重新登录 </a>");
    String sPageNow=req.getParameter("pageNowok");
    if(sPageNow!=null){
     pageNow=Integer.parseInt(sPageNow);
    }
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

    ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","");
    ps=ct.prepareStatement("select count(*) from users");
    rs=ps.executeQuery();
    if(rs.next()){
    rowCount=rs.getInt(1);
    }
    if(rowCount%pageSize==0){
     pageCount=rowCount/pageSize;
    }else{
     pageCount=rowCount/pageSize+1;
    }
    ps=ct.prepareStatement("select top "+pageSize+" *from users where userId not in (select top "+pageSize*(pageNow-1)+" userId from users)");
    /*ps.setInt(1,pageSize);
    ps.setInt(2,pageSize*(pageNow-1));*/
    rs=ps.executeQuery();
    pw.println("<table border=1>");
    pw.println("<tr><th>id</th><th>name</th><th>password</th><th>mail</th><th>grade</th></tr>");
    while(rs.next()){
     pw.println("<tr>");
     pw.println("<td>"+rs.getInt(1)+"</td>");
     pw.println("<td>"+rs.getString(2)+"</td>");
     pw.println("<td>"+rs.getString(3)+"</td>");
     pw.println("<td>"+rs.getString(4)+"</td>");
     pw.println("<td>"+rs.getInt(5)+"</td>");
     pw.println("</tr>");
    }
    pw.println("</table>");
    if(pageNow!=1)
    pw.println("<a href=wel?pageNowok="+(pageNow-1)+">上一页</a>");
    for(int i=pageNow;i<=(pageNow+4);i++){
     pw.println("<a href=wel?pageNowok="+i+">"+i+"</a>");
    }
    if(pageNow!=pageCount)
    pw.println("<a href=wel?pageNowok="+(pageNow+1)+">下一页</a>");
    pw.println("</center></body>");

   }
   catch(Exception e){
    e.printStackTrace();
   }







  }

public void doPost(HttpServletRequest req,HttpServletResponse res){
  this.doGet(req,res);

}
}

package com.hetao;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Login extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res){
try{
res.setContentType("text/html;charset=gbk");

   PrintWriter pw=res.getWriter();
   pw.println("<html>");
   pw.println("<head>");
   pw.println("<title>hello,world</title>");
   pw.println("</head>");
   pw.println("<body bgcolor=/"white/">");
   pw.println("<form action=logincl method=post>");
   pw.println("用户名:<input type=text name=name><br>");
   pw.println(" 密码:<input type=password name=password><br>");
   pw.println("<input type=submit value=login><br>");

   pw.println("<hr>");
   pw.println("你好");
   pw.print("</body></html>");

  }
  catch(Exception e){
   e.printStackTrace();

  }
}

public void doPost(HttpServletRequest req,HttpServletResponse res){
  this.doGet(req,res);

}
}

查询语句

create table users(
userId int primary key identity(1,1),
username varchar(20),
password varchar(20),
email varchar(30),
grade int )

select * from users
use sqdb
insert into users values
('di','adm','sdfdsfsf@sohu.com',1)
insert into users values
('to','hto','sdfdsfsf@sohu.com',1)
insert into users values
('y','h','sdfdsfsf@sohu.com',5)
insert into users values
('st','test','sdfdsfsf@sohu.com',5)
select top 3 *from users where userId not in (select top 6 userId from users)
select count(*) from users

insert into users (username,password,email,grade) select username,password,email,grade from users

wenhuahetao

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
servelt 应用

LoginCl.javapackage com.hetao;import java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;public class LoginCl extends HttpServlet{ public void doGet(HttpServletRequest req
复制链接

扫一扫