jsp代码实例第317课

最新推荐文章于 2024-12-05 00:03:22 发布

原创最新推荐文章于 2024-12-05 00:03:22 发布 · 178 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#java #sql #数据库

Java 专栏收录该内容

1308 篇文章

订阅专栏

本文详细介绍了使用Java编写的code317类，展示如何通过代码检查用户名和密码，调用数据库查询用户信息并处理异常。核心部分是check方法，确保用户存在且密码匹配。

code317.java

package pack08;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

//x1_user 
public class code317
{
	private int id;
	private String userName;
	private String pwd;
	private String phone;
	private String addr;
	private Date rdate;
	
	
	public int getId()
	{
		return id;
	}
	public void setId(int id)
	{
		this.id = id;
	}
	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 String getPhone()
	{
		return phone;
	}
	public void setPhone(String phone)
	{
		this.phone = phone;
	}
	public String getAddr()
	{
		return addr;
	}
	public void setAddr(String addr)
	{
		this.addr = addr;
	}
	public Date getRdate()
	{
		return rdate;
	}
	public void setRdate(Date rdate)
	{
		this.rdate = rdate;
	}
	
	public static code317 check(String userName,String pwd) throws Exception
	{
		code317 user = null;
		Connection conn = code316.getConnection();
		String sql = "select * from x1_user where username='" + userName + "'";
		Statement stmt = code316.getStatement(conn);
		ResultSet rs = code316.getResultSet(stmt, sql);
		
		try
		{
			if(!rs.next())
			{
				throw new Exception(userName +"用户不存在");
			}
			else 
			{
				if (!pwd.equals(rs.getString("pwd")))
				{
					throw new Exception("密码不正确！");
				}
			}
			user = new code317();
			user.setId(rs.getInt("id"));
			user.setUserName(rs.getString("username"));
			user.setPwd(rs.getString("pwd"));
			user.setPhone(rs.getString("phone"));
			user.setAddr(rs.getString("addr"));
			user.setRdate(rs.getDate("rdate"));
			
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		}
		finally 
		{
			code316.close(rs);
			code316.close(stmt);
			code316.close(conn);
		}
		
		return user;
	}
}