我做这个做了一天多了,就是不成功,跪求帮助
jsp文件是
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>登陆</title>
</head>
<body >
<font size=6 color="black"> 登陆</font>
<form action="login_in" method="post" onSubmit="return checkLogin()">
用户名:<input type="text" name="user" size="20"><br><br>
密 码:<input type="password" name="pwd" size="20"><br><br>
<input type="submit" value="提交">
<input type="reset" name="reset" value="重置"><br><br>
<a href="registuser.jsp">注册新用户</a>
</form>
</body>
</html>bean是
package dao;public class UserBean
{
private String user;
private String pwd;
public UserBean() {}
public UserBean(String user,String pwd)
{
this.user=user;
this.pwd=pwd;
}
public void setuser(String user) {
this.user = user;
}
public String getuser() {
return user;
}
public void setpwd(String pwd) {
this.pwd = pwd;
}
public String getpwd() {
return pwd;
}
}servlet是
package dao;import java.io.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import connection.DBConnection;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class login_in extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private Connection conn;
private PreparedStatement pstate;
private ResultSet rs; public login_in()
{
super();
}
public void destroy() {
super.destroy();
}
public boolean checkLogin(UserBean ub)
{
int jg=0;
try
{
pstate=conn.prepareStatement("select MName,MPwd from tb_member where MName=? and MPwd=?");
pstate.setString(1,ub.getuser());
pstate.setString(2,ub.getpwd());
rs=pstate.executeQuery();
if(rs.next())
jg=1;
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
pstate.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
if(jg>0)
return true;
else
return false;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String user=request.getParameter("user");
String pwd=request.getParameter("pwd");
UserBean ub=new UserBean(user,pwd);
if(this.checkLogin(ub))
out.print("dengluchengong");
else
out.print("denglushibai");
}
}
请大家帮忙看看是哪里的问题啊,或者大家给个简单登陆的代码看看啊,我做了一天多了,就是不行,快哭了!
jsp文件是
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>登陆</title>
</head>
<body >
<font size=6 color="black"> 登陆</font>
<form action="login_in" method="post" onSubmit="return checkLogin()">
用户名:<input type="text" name="user" size="20"><br><br>
密 码:<input type="password" name="pwd" size="20"><br><br>
<input type="submit" value="提交">
<input type="reset" name="reset" value="重置"><br><br>
<a href="registuser.jsp">注册新用户</a>
</form>
</body>
</html>bean是
package dao;public class UserBean
{
private String user;
private String pwd;
public UserBean() {}
public UserBean(String user,String pwd)
{
this.user=user;
this.pwd=pwd;
}
public void setuser(String user) {
this.user = user;
}
public String getuser() {
return user;
}
public void setpwd(String pwd) {
this.pwd = pwd;
}
public String getpwd() {
return pwd;
}
}servlet是
package dao;import java.io.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import connection.DBConnection;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class login_in extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private Connection conn;
private PreparedStatement pstate;
private ResultSet rs; public login_in()
{
super();
}
public void destroy() {
super.destroy();
}
public boolean checkLogin(UserBean ub)
{
int jg=0;
try
{
pstate=conn.prepareStatement("select MName,MPwd from tb_member where MName=? and MPwd=?");
pstate.setString(1,ub.getuser());
pstate.setString(2,ub.getpwd());
rs=pstate.executeQuery();
if(rs.next())
jg=1;
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
pstate.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
if(jg>0)
return true;
else
return false;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String user=request.getParameter("user");
String pwd=request.getParameter("pwd");
UserBean ub=new UserBean(user,pwd);
if(this.checkLogin(ub))
out.print("dengluchengong");
else
out.print("denglushibai");
}
}
请大家帮忙看看是哪里的问题啊,或者大家给个简单登陆的代码看看啊,我做了一天多了,就是不行,快哭了!
# import java.sql.Connection;
# import java.sql.DriverManager;
# import java.sql.SQLException;
#
# public class DBAccess {
#
# /**
# * @param args
# */
# public DBAccess(){
# }
# public static Connection getConnection(){
# try {
# Class.forName("com.mysql.jdbc.Driver");
# } catch (ClassNotFoundException e) {
# // TODO Auto-generated catch block
# System.out.println("驱动程序未找到");
# e.printStackTrace();
# }
# String url="jdbc:mysql://localhost:3306/person";
# String user="root";
# String password="123";
# Connection conn=null;
# try {
# conn=DriverManager.getConnection(url, user, password);
# } catch (SQLException e) {
# // TODO Auto-generated catch block
# System.out.println("数据库连接出错啦!");
# e.printStackTrace();
# }
# System.out.println("Connection连接成功!");
# return conn;
# }
# public static void main(String[] args) {
# // TODO Auto-generated method stub
# Connection connection=getConnection();
# }
#
# }
package connection;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import dao.Message;
import dao.User;
public class DBConnection {
static String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String URL="jdbc:microsoft:sqlserver://localhost:1433;dataBasename=hotel";
static String NAME="sa";
static String PWD="";
static Connection con=null;
ResultSet rs=null;
PreparedStatement pstmt=null;
public static Connection getConnection(){
try{
Class.forName(DRIVER);
con=DriverManager.getConnection(URL,NAME,PWD);
}catch(Exception e){
System.out.print(e.toString());
}finally{
return con;
}
}
public void CloseAll(){
try {
this.rs.close();
this.pstmt.close();
this.con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}出错信息是
type Status reportmessage /testFilter/login_indescription The requested resource (/testFilter/login_in) is not available.xml里的部署代码是
<servlet>
<servlet-name>login_in</servlet-name>
<servlet-class>dao.login_in</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>login_in</servlet-name>
<url-pattern>/login_in</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>login.html</welcome-file>
</welcome-file-list>
大家帮忙看看啊,还有我那个servlet里的以前是初始化了的,后来我给删了,那时候也报错,谢谢大家,跪求啊,我刚学的,大家给我个做好的也行啊,我又快哭啦。
type Status reportmessage /testFilter/login_indescription The requested resource (/testFilter/login_in) is not available