loginbean.java

已完成的jsp％2BjavaBean％2BServlet实例有增删改查很好的mvc源代码

package admin.loginBean;

import java.sql.*;

public class LoginBean{
	private String name;
	private String pwd;
	private Connection conn;
	private PreparedStatement ps;
	private ResultSet rs;
	
	public String getName(){
		return name;
	}

	public String getPwd(){
		return pwd;
	}

	public void setName(String name){
		this.name = name;
	}

	public void setPwd(String pwd){
		this.pwd = pwd;
	}

	public int check(){
		if(this.getName()==null) return -1;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:news");
			String qstr="select * from login where name=? and pwd=?";
			ps=conn.prepareStatement(qstr);			
			ps.setString(1,this.getName());
			ps.setString(2,this.getPwd());
			rs=ps.executeQuery();
			if(rs.next()){
				return 1;
			}
			else{
				return 0;
			}
		}
		catch (ClassNotFoundException ex){}
		catch (SQLException ex1){}
		finally{
				try {
					conn.close();
					conn=null;
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		return -1;
	}
}