java wed登录面 代码_第三章 java web（登陆注册界面）自己的代码

--sql文件

create database student

go

use student

go

create table stuinfo

(

--stuid int primary key identity(1,1) not

null,

stuname nvarchar(10) not null,

stupwd nvarchar(20) not null

)

insert into stuinfo values('admin','123')

select * from stuinfo

select stuname,stupwd from stuinfo where stuname='admin'

create table stuinfo_email

(

--stuid int primary key identity(1,1) not

null,

stuname nvarchar(10) not null,

stupwd nvarchar(20) not null,

stuemail nvarchar(20) not null

)

select * from stuinfo_email

insert into stuinfo_email values('1','123','1@sina.com')

----java  代码

package com.svse.ADO;

public class ADO {

private String stuname;

private String stupwd;

public String getStuname() {

return stuname;

}

public void setStuname(String stuname) {

this.stuname = stuname;

}

public String getStupwd() {

return stupwd;

}

public void setStupwd(String stupwd) {

this.stupwd = stupwd;

}

}

----注册

package com.svse.Applion;

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.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

//在次出继承

public class Regist  extends

HttpServlet{

public Connection  conn;

public  PreparedStatement pstm;

public ResultSet rs;

//连接数据库

public void getConn(){

String

url="jdbc:sqlserver://localhost:1433;database=student";

String user="sa";

String pwd="svse";

String

driverpath="com.microsoft.sqlserver.jdbc.SQLServerDriver";

try {

Class.forName(driverpath);

conn=DriverManager.getConnection(url,user,pwd);

if(conn!=null){

//System.out.println("ok");

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//得到post资源

public void doPost(HttpServletRequest

request,HttpServletResponse response)throws

ServletException,IOException{

//网页出现乱码情况  将打印的字转换成正规字体

response.setContentType("text/html;charset=gbk");

PrintWriter out=response.getWriter();

String name=request.getParameter("registName");

String pwd=request.getParameter("registPwd");

String email=request.getParameter("registSina");

//System.out.println(name);

//System.out.println(pwd);

//System.out.println(email);

if(this.insert(name,pwd,email)== true){

out.println("注册成功！");

}else{

out.println("注册失败！");

}

out.flush();

out.close();

}

//注册  添加数据

public boolean insert(String name,String pwd,String

email){

getConn();

boolean bol=false;

String sql="insert into stuinfo_email values(?,?,?) ";

try {

pstm=conn.prepareStatement(sql);

//System.out.println(name);

//System.out.println(pwd);

//System.out.println(email);

pstm.setString(1, name);

pstm.setString(2, pwd);

pstm.setString(3, email);

pstm.execute();

bol=true;

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}finally{

try {

if(rs!=null){

rs.close();

}

if(pstm!=null){

pstm.close();

}

if(conn!=null){

conn.close();

}

} catch (Exception e) {

// TODO: handle exception

}

}

return bol;

}

}

--登陆

package com.svse.Applion;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Connection;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class Acpplion extends HttpServlet

{

public Connection  conn;

public  PreparedStatement pstm;

public ResultSet rs;

//连接数据库

public void getConn(){

String

url="jdbc:sqlserver://localhost:1433;database=student";

String user="sa";

String pwd="svse";

String

driverpath="com.microsoft.sqlserver.jdbc.SQLServerDriver";

try {

Class.forName(driverpath);

conn=DriverManager.getConnection(url,user,pwd);

if(conn!=null){

//System.out.println("ok");

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//获取get资源

public void doPost(HttpServletRequest

requst,HttpServletResponse response)throws

ServletException,IOException{

response.setContentType("text/html;charset=gbk");

PrintWriter out=response.getWriter();

String name=requst.getParameter("loginName");

String pwd=requst.getParameter("loginPwd");

//等到数据库的值  看是否与其匹配

if(this.select(name,pwd)==true)

{

out.print("登陆成功！！！");

}else{

out.print("登录失败！！！");

}

out.flush();

out.close();

}

//查询

public boolean select(String name,String pwd){

getConn();

boolean bol=false;

String sql="select stuname,stupwd from stuinfo where stuname=?

";

try {

pstm=conn.prepareStatement(sql);

pstm.setString(1, name);

pstm.executeQuery();

bol=true;

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}finally{

try {

if(rs!=null){

rs.close();

}

if(pstm!=null){

pstm.close();

}

if(conn!=null){

conn.close();

}

} catch (Exception e) {

// TODO: handle exception

}

}

//返回值

return bol;

}

}

-----jsp 界面

action="login"

method="post">

用户名：

id="loginName"/>

密  码：

id="loginPwd"/>

value="登陆"/>

注册

-----注册界面

action="loginregister"

method="post">

用户名：

/>

密 

码：

name="registPwd" />

/>

邮 

箱：

name="registSina"/>

value="确定"/>

------web.xml

login

com.svse.Applion.Acpplion

login

/login

register

com.svse.Applion.Regist

register

/loginregister