再学习1的基础上使用DB集成块
包括文件DBOptions.properties(修改数据库的连接)
Option.java
ConnectionManager.java
DBConnection.java
DBOperate.java(以后就只使用DBOperate就可以了)
再次说明,这里的hibernate.cfg.xml只是摆设,没有用来连接数据库,这里是在
ConnectionManager.java
DBConnection.java中使用数据库连接池进行连接的.
使用实例
<%@ page language="java" import="java.util.*,my.bean.*" contentType="text/html; charset=GB2312"%>
<jsp:useBean id="dbo" class="com.pp.db.DBOperate"></jsp:useBean>
<html>
<head>
<title>My JSP 'login_do.jsp' starting page</title>
<body>
<%
request.setCharacterEncoding("GB2312");
String userName = request.getParameter("userName");
String password = request.getParameter("password");
Member member1 = new Member();
member1.setUsername(userName);
member1.setPassword(password);
String hql = "from Member where username='"+userName+"' and password='"+password+"'";
//Member是java类,不是实例,username,和password是Member的属性
List memberlist = (List) dbo.findSQLHibernate(hql, 1);
if (memberlist.size() > 0) {
System.out.println("登陆成功");
}
else
{System.out.println("没有你哩,要注册哦");}
%>
</body>
</html>
源代码见优快云上(明天来传)