JSP复习笔记——第10章 连接数据库 之 使用JSP+DAO完成用户登陆

使用JSP+DAO完成用户登陆

import java.sql.* ;

public class DataBaseConnection {
	private String DBDRIVER			= "oracle.jdbc.driver.OracleDriver" ;
	private String DBURL			= "jdbc:oracle:thin:@localhost:1521:sky" ;
	private String DBUSER			= "scott" ;
	private String DBPASSWORD		= "darkness" ;
	private Connection conn			= null ;

	public DataBaseConnection() {
		try {
			Class.forName(DBDRIVER) ;
			this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
		} catch (Exception e) {
		}
	}

	public Connection getConnection() {
		return this.conn ;
	}

	public void close() {
		try {
			this.conn.close() ;
		}
		catch (Exception e) {
		}
	}
};

--------------------------PersonVO.java---------------

package org.darkness.vo;

public class PersonVO {
private String id;
private String name;
private String password;
// getter and setter 方法
}
------------------------PersonDAO.java-------------
package org.darkness.dao;
public interface PersonDAO{
   boolean isLogin(PersonVO pv);
}
------------------------PersonDAOImpl.java-----------
package org.darkness.daoimpl;
public class PersonDAOImpl implements PersonDAO {
   public boolean isLogin(PersonVO pv){
      boolean flag = false;
      return flag;
}
}