62,614
社区成员
发帖
与我相关
我的任务
分享
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import jiang5495.util.*;
import java.sql.*;
public class login extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
String name=request.getParameter("name");
String password=request.getParameter("password");
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
conn=DataBase.getConnection();
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/register.jsp?name=jiang5495");
}
try{
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/main.jsp?name=jiang5495");
}
stmt=conn.createStatement();
String sql="select password from student where name='"+password+"'";
rs=stmt.executeQuery(sql);
String npassword="iyuihjknhjkhxuihuihjhl";
while(rs.next()){
npassword=rs.getString(1);
}
if(npassword.equals(password)){
request.getRequestDispatcher("/main.jsp").forward(request, response);
}else{
// request.getRequestDispatcher("/main.jsp").forward(request, response);
response.sendRedirect("http://localhost:8080/HelleWorld/main.jsp");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
doPost(request,response);
}
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
conn=DataBase.getConnection();
try{
stmt=conn.createStatement();
String sql2="select * from bkliuhecai";
rs=stmt.executeQuery(sql2);
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}
}
}
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import jiang5495.util.*;
import java.sql.*;
public class login extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
String name=request.getParameter("name");
String password=request.getParameter("password");
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
conn=DataBase.getConnection();
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/register.jsp?name=jiang5495");
}
try{
/*
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/main.jsp?name=jiang5495");
}
*/
if(conn==null){
System.out.println("天哪,为什么我就是取不到!");
response.sendRedirect("http://localhost:8080/HelleWorld/register.jsp?name=jiang5495");
}
stmt=conn.createStatement();
String sql="select password from student where name='"+password+"'";
rs=stmt.executeQuery(sql);
String npassword="iyuihjknhjkhxuihuihjhl";
while(rs.next()){
npassword=rs.getString(1);
}
if(npassword.equals(password)){
request.getRequestDispatcher("/main.jsp").forward(request, response);
}else{
// request.getRequestDispatcher("/main.jsp").forward(request, response);
response.sendRedirect("http://localhost:8080/HelleWorld/main.jsp");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
doPost(request,response);
}
/*
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
conn=DataBase.getConnection();
try{
stmt=conn.createStatement();
String sql2="select * from bkliuhecai";
rs=stmt.executeQuery(sql2);
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}
}
*/
}
package jiang5495.util;
import java.sql.*;
public class DataBase {
public static Connection getConnection(){
Connection conn=null;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=temp";
String uName = "sa";
String uPwd = "123456";
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,uName,uPwd);
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e2){
e2.printStackTrace();
}
if(conn==null){
System.out.println("you who you");
}
return conn;
}
public static void main(String[] args){
Connection conn=DataBase.getConnection();
Statement stmt=null;
ResultSet rs=null;
System.out.println("you are not a good boy!");
try{
stmt=conn.createStatement();
String sql="select * from web";
rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e3){
e3.printStackTrace();
}
}
}
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/register.jsp?name=jiang5495");
}
try{
/*
if(conn==null){
response.sendRedirect("http://localhost:8080/HelleWorld/main.jsp?name=jiang5495");
}
*/
if(conn==null){
System.out.println("天哪,为什么我就是取不到!");
response.sendRedirect("http://localhost:8080/HelleWorld/register.jsp?name=jiang5495");
}