jsp+javabean+servlet+mysql编写的登录程序，急用，谢谢

如题所述

举报该文章

相关建议 2010-12-31

javabpackage login;

public class Databean {
String username;
String qx;
public String getQx() {
return qx;
}
public void setQx(String qx) {
this.qx = qx;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public boolean isBoo() {
return boo;
}
public void setBoo(boolean boo) {
this.boo = boo;
}
String pwd;
boolean boo;

}

package login;

/* 数据访问组件 */

import java.sql.*;

public class DbPool{

//取得连接
public Connection getConnection() {
Connection con;
try
{
Class.forName("com.mysql.jdbc.Driver");
String uri= "jdbc:mysql://localhost/Login";
con=DriverManager.getConnection(uri,"root","");
return con;
}
catch(Exception e)
{
System.out.println(e);
return null;

}

}

//释放资源
}

servlet 如下：：：

import java.sql.*;
import java.util.*;

import javax.servlet.http.HttpSession;
import javax.xml.ws.Response;

public class LoginHandler {
public LoginHandler() {
}

Connection conn;
PreparedStatement ps;
ResultSet rs;

//检查是否已注册
public int checkLogin(String name,String password){
//从数据访问组件dbPool中取得连接
DbPool db=new DbPool();
conn = db.getConnection();

try {
String sql = "select * from t_userInfo where username=? and password=?";
ps = conn.prepareStatement(sql);
ps.setString(1,name);
ps.setString(2,password);
rs = ps.executeQuery();

if(rs.next())
{
String s=rs.getString(3);
if(s.equals("com"))
return 1;
else
conn.close();
return 2;

//释放资源
}
else {
conn.close();
return 0;
}

} catch (SQLException e) {
System.out.println(e);
}
return 0;

}

public boolean checkLoginregister(String username,String pwd){
DbPool db=new DbPool();
conn = db.getConnection();
int n=0;
try{
String sql = "insert into t_userInfo values(?,?,?) ";
ps = conn.prepareStatement(sql);
ps.setString(1,username);
ps.setString(2,pwd);
ps.setString(3, "com");
n=ps.executeUpdate();
}catch(Exception e){
System.out.println(e);
}
if(n!=0)
{

return true;
}
else
{
return false;
}

}

}
jsp：

<%@page contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>登录页面</title>
</head>
<body>
<form method="post" action="loginservlet" >
用户名： <input type="text" name="username" size="15"><br><br>
密码： <input type="password" name="password" size="15"><br><br>

<input type="submit" name="submit" value="登录"><br>
</form>
</body>
</html>

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/pff8q8mq7.html

其他看法

第1个回答 2010-12-31

做任务的

相似回答

大家正在搜