|
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","");
????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,res);
??
?}
}
?
Login.java
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,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',1)
insert into users values
('y','h',5)
insert into users values
('st','test',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,grade from users
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
