--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">
/>
----注册界面
method="post">
border="1">
账号
width="32">
密码
style="width: 120px" />
邮箱
height="25">
/>