java web注册登陆_java web （登陆注册界面）

--java的代码部分

package com.demo.db.utils;

import java.sql.Connection;

import java.sql.DriverManager;

public class ConnUtils {

private static String driver;

private static String url;

private static String username;

private static String password;

private static Connection conn;

private static void init() {

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

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

username="sa";

password="svse";

}

//获取数据库连接

public static Connection getConn(){

init();

try{

Class.forName(driver);

conn=DriverManager.getConnection(url,username,password);

}catch(Exception e){

e.printStackTrace();

}

return conn;

}

//关闭连接

public static void closeConn(){

try{

if(conn!=null){

conn.close();

conn=null;

}

}catch(Exception e){

e.printStackTrace();

}

}

}

package com.demo.db.utils;

public class User {

private String username;

private String password;

private String email;

public User(String username, String password)

{

super();

this.username = username;

this.password = password;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

}

package com.demo.db.utils;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

public class UserDaoImpl {

public boolean login(String username, String

password) {

ResultSet resultSet =

null;

Statement stmt = null;

Connection conn = null;

boolean checkLogin =

false;

List users = new

ArrayList();

try {

String

sqlStr = "select name,password from t_user where name="

+

"'" + username + "'";

conn =

ConnUtils.getConn();

stmt =

conn.createStatement();

resultSet =

stmt.executeQuery(sqlStr);

while

(resultSet.next()) {

String

str1 = resultSet.getString(1);

String

str2 = resultSet.getString(2);

User

user = new User(str1, str2);

users.add(user);

}

System.out.println(users.size());

if

(users.size() == 0) {

checkLogin

= false;

} else

{

String

passInDb = users.get(0).getPassword();

if

(passInDb.equals(password)) {

checkLogin

= true;

}

else {

checkLogin

= false;

}

}

} catch (SQLException se)

{

se.printStackTrace();

} finally {

try {

if

(resultSet != null) {

resultSet.close();

}

if

(stmt != null) {

stmt.close();

}

if

(conn != null) {

conn.close();

}

} catch

(SQLException e) {

//

TODO Auto-generated catch block

e.printStackTrace();

}

}

return checkLogin;

}

public boolean register(String username,

String password, String email) {

Statement stmt = null;

Connection conn = null;

boolean checkLogin =

false;

List users = new

ArrayList();

try {

String

sqlStr = "insert into t_user(name,password,email)values"

+

"('" + username + "','" + password + "','" + email + "')";

conn =

ConnUtils.getConn();

stmt =

conn.createStatement();

stmt.executeUpdate(sqlStr);

checkLogin =

true;

} catch (SQLException se)

{

se.printStackTrace();

} finally {

try {

if

(stmt != null) {

stmt.close();

}

if

(conn != null) {

conn.close();

}

} catch

(SQLException e) {

//

TODO Auto-generated catch block

e.printStackTrace();

}

}

return checkLogin;

}

}

package com.demo.test;

import com.demo.db.utils.UserDaoImpl;

public class Application {

public static void main(String[] args) {

// TODO Auto-generated method

stub

UserDaoImpl dao=new

UserDaoImpl();

System.out.println(dao.login("admin",

"admin"));

}

}

package com.demo.web.utils;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Date;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.demo.db.utils.UserDaoImpl;

public class LoginServlet extends HttpServlet {

public void doPost(HttpServletRequest

request,HttpServletResponse response)throws

ServletException,IOException{

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

String

username=request.getParameter("username");

String

password=request.getParameter("password");

PrintWriter

out=response.getWriter();

UserDaoImpl dao=new

UserDaoImpl();

if(dao.login(username,

password)){

out.println("

");

out.println("");

out.print(username+"

登陆成功! ");

out.println("");

out.println("

");

}else{

out.println("

");

out.println("");

out.print("登陆失败!");

out.println("");

out.println("

");

}

out.flush();

out.close();

}

}

package com.demo.web.utils;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.demo.db.utils.UserDaoImpl;

public class RegisterServlet extends HttpServlet {

public void doPost(HttpServletRequest

request,HttpServletResponse response)throws

ServletException,IOException{

String

username=request.getParameter("username");

String

password=request.getParameter("password");

String

email=request.getParameter("email");

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

PrintWriter

out=response.getWriter();

UserDaoImpl dao=new

UserDaoImpl();

if(dao.register(username,

password, email)){

out.println("

");

out.println("");

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

out.println("");

out.println("

");

}else{

out.println("

");

out.println("");

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

out.println("");

out.println("

");

}

out.flush();

out.close();

}

}

----********************

---jsp界面

index 界面

method="post">

border="1">

账号

width="23"> 

密码

style="width: 120px" />

 

height="25"> 

/>

class="char">注册

 

----注册界面

method="post">

border="1">

账号

width="32"> 

密码

style="width: 120px" />

 

邮箱

 

height="25"> 

/>

class="char">返回主页