?? databean.java
字號:
/*<%--////////////////////////////////////////////////////GTON原創(chuàng)作品-Struts圖書館管理系統(tǒng)//////////////////////////////////////////////////////////////
////////////所用技術(shù):jsp2.0+servlet2.4+jstl1.1+Struts1.2+sqlserver2000+tomcat5.5/////////////////////////////////////
/////////////////////////////////////////////////////專業(yè)制作網(wǎng)站 專業(yè)制作畢業(yè)設(shè)計////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////QQ:27612285//////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////Mail:punkwang@126.com////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////WEB:www.98202.com www.630cn.com//////////////////////////////////////////////////////
////////////////////////////////////////////////////qq群:20665503////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////求高薪工作一個有意者聯(lián)系本人/////////////////////////////////////////////////////////
////////////////////////////////////////////////////Phone:010-81110277(王先生)///////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////--%>
<%--接 畢業(yè)設(shè)計業(yè)務(wù) 網(wǎng)站業(yè)務(wù) 商業(yè)網(wǎng)站 個人網(wǎng)站 商城系統(tǒng) 企業(yè)主頁 JSP ASP.net PHP !!!
業(yè)務(wù)種類
網(wǎng)站業(yè)務(wù)： 商業(yè)網(wǎng)站 個人網(wǎng)站 商城系統(tǒng) 企業(yè)主頁 等中小型網(wǎng)站（asp, jsp ,php ,asp.net）
畢業(yè)設(shè)計業(yè)務(wù):java（j2ee j2se） vb delphi php .net等畢設(shè)業(yè)務(wù)
模塊業(yè)務(wù)：各種中小型模塊 java .net
如有需要 價格細(xì)談 QQ:27612285
我的網(wǎng)站
HTTP://www.98202.com
HTTP://www.do3w.com
HTTP://www.201cn.com
HTTP://www.630cn.com--%>
*/package com.gton.bean.db;
import java.sql.*;
import com.gton.bean.*;
import com.gton.util.*;
import java.util.*;
public class DataBean {
private Connection conn = null;
private ResultSet res = null;
private java.sql.PreparedStatement prepar = null;
private java.sql.CallableStatement proc = null;
public int pagecount = 0;
public DataBean() { //構(gòu)造函數(shù)
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=Book",
"sa", "");
System.out.println("連接成功");
} catch (SQLException ex) {
System.out.println(ex.getMessage() + "路徑錯誤");
} catch (ClassNotFoundException ex) {
System.out.println(ex.getMessage() + "驅(qū)動錯誤");
}
}
public void Close() { //關(guān)閉方法
try {
if (res != null) {
res.close();
}
if (prepar != null) {
prepar.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException ex) {
ex.printStackTrace();
}
System.out.println("關(guān)閉成功");
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Admin登陸方法/////////////////////////////////////////////////
public boolean checkAdminLogin(AdminBean ab) { // 驗證登陸
boolean result = false;
if (!MyString.checkParameter(ab.getAdmin_Name()
+ ab.getAdmin_Pwd())) {
return result;
}
try {
String sql =
"select count(*) from Admin where Admin_Name=? and Admin_Pwd=?";
prepar = conn.prepareStatement(sql);
prepar.setString(1, ab.getAdmin_Name());
prepar.setString(2, ab.getAdmin_Pwd());
res = prepar.executeQuery();
if (res.next()) {
if (res.getInt(1) > 0) {
result = true;
}
}
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
public AdminBean getAdminBean(AdminBean ab) { // 獲取AdminBean持久化
AdminBean admin = null;
try {
String sql =
"select * from Admin where Admin_Name=? and Admin_Pwd=?";
prepar = conn.prepareStatement(sql);
prepar.setString(1, ab.getAdmin_Name());
prepar.setString(2, ab.getAdmin_Pwd());
res = prepar.executeQuery();
if (res.next()) {
admin = new AdminBean();
admin.setAdmin_ID(res.getInt("Admin_ID"));
admin.setAdmin_Name(res.getString("Admin_Name"));
admin.setAdmin_Pwd(res.getString("Admin_Pwd"));
admin.setAdmin_Flag(res.getString("Admin_Flag"));
}
} catch (Exception e) {
e.printStackTrace();
}
return admin;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User登陸方法/////////////////////////////////////////////////
public boolean checkUserLogin(UserBean ub) { // 驗證登陸
boolean result = false;
if (!MyString.checkParameter(ub.getUsers_Name()
+ ub.getUsers_Pwd())) {
return result;
}
try {
String sql =
"select count(*) from Users where Users_Name=? and Users_Pwd=?";
prepar = conn.prepareStatement(sql);
prepar.setString(1, ub.getUsers_Name());
prepar.setString(2, ub.getUsers_Pwd());
res = prepar.executeQuery();
if (res.next()) {
if (res.getInt(1) > 0) {
result = true;
}
}
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
public UserBean getUserBean(UserBean ub) { // 獲取UserBean持久化
UserBean user = null;
try {
String sql =
"select * from Users where Users_Name=? and Users_Pwd=?";
prepar = conn.prepareStatement(sql);
prepar.setString(1, ub.getUsers_Name());
prepar.setString(2, ub.getUsers_Pwd());
res = prepar.executeQuery();
if (res.next()) {
user = new UserBean();
user.setUsers_ID(res.getInt("Users_ID"));
user.setUsers_Name(res.getString("Users_Name"));
user.setUsers_Pwd(res.getString("Users_Pwd"));
user.setUsers_Adds(res.getString("Users_Adds"));
user.setUsers_Class(res.getString("Users_Class"));
user.setUsers_Count(res.getInt("Users_Count"));
user.setUsers_Phone(res.getString("Users_Phone"));
user.setUsers_Sex(res.getString("Users_Sex"));
}
} catch (Exception e) {
e.printStackTrace();
}
return user;
}
public UserBean getUserBean(int users_ID) { // 獲取UserBean持久化
UserBean user = null;
try {
String sql =
"select * from Users where Users_ID=?";
prepar = conn.prepareStatement(sql);
prepar.setInt(1, users_ID);
res = prepar.executeQuery();
if (res.next()) {
user = new UserBean();
user.setUsers_ID(res.getInt("Users_ID"));
user.setUsers_Name(res.getString("Users_Name"));
user.setUsers_Pwd(res.getString("Users_Pwd"));
user.setUsers_Adds(res.getString("Users_Adds"));
user.setUsers_Class(res.getString("Users_Class"));
user.setUsers_Count(res.getInt("Users_Count"));
user.setUsers_Phone(res.getString("Users_Phone"));
user.setUsers_Sex(res.getString("Users_Sex"));
}
} catch (Exception e) {
e.printStackTrace();
}
return user;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User注冊方法/////////////////////////////////////////////////
public boolean regUser(UserBean ub) {
try {
prepar = conn.prepareStatement(
"insert into Users (Users_Name,Users_Pwd,Users_Class,Users_Sex,Users_Count,Users_Phone,Users_Adds) values(?,?,?,?,?,?,?)");
prepar.setString(1, ub.getUsers_Name());
prepar.setString(2, ub.getUsers_Pwd());
prepar.setString(3, ub.getUsers_Class());
prepar.setString(4, ub.getUsers_Sex());
prepar.setInt(5, ub.getUsers_Count());
prepar.setString(6, ub.getUsers_Phone());
prepar.setString(7, ub.getUsers_Adds());
int flag = prepar.executeUpdate();
if (flag == 0) {
return false;
}
} catch (SQLException ex) {
ex.printStackTrace();
return false;
}
return true;
}
public boolean isHasName(String userName) {
try {
prepar = conn.prepareStatement(
"select count(*) from Users where Users_Name=?");
prepar.setString(1, userName);
res = prepar.executeQuery();
res.next();
if (res.getInt(1) != 0) {
return false;
}
} catch (SQLException ex) {
ex.printStackTrace();
return false;
} finally {
this.Close();
}
return true;
}
public static boolean HasName(String userName) {
return new DataBean().isHasName(userName);
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User更新信息方法/////////////////////////////////////////////////
public boolean updateUserInfo(UserBean ub) {
try {
prepar = conn.prepareStatement(
"update Users set Users_Name=?,Users_Pwd=?,Users_Class=?,Users_Sex=?,Users_Phone=?,Users_Adds=? where Users_ID=?");
prepar.setString(1, ub.getUsers_Name());
prepar.setString(2, ub.getUsers_Pwd());
prepar.setString(3, ub.getUsers_Class());
prepar.setString(4, ub.getUsers_Sex());
prepar.setString(5, ub.getUsers_Phone());
prepar.setString(6, ub.getUsers_Adds());
prepar.setInt(7, ub.getUsers_ID());
int flag = prepar.executeUpdate();
if (flag == 0) {
return false;
}
} catch (SQLException ex) {
ex.printStackTrace();
return false;
}
return true;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Users獲取User已借書的列表方法/////////////////////////////////////////////////
public ArrayList getUsersLendList(int users_ID) {
ArrayList list = new ArrayList();
try {
String sql =
"select * from BookLend where Users_ID=?";
prepar = conn.prepareStatement(sql);
prepar.setInt(1, users_ID);
res = prepar.executeQuery();
while (res.next()) {
LendBean lb = new LendBean();
lb.setBookLend_ID(res.getInt("BookLend_ID"));
lb.setBooks_ID(res.getInt("Books_ID"));
lb.setBookLend_StarTime(res.getString("BookLend_StarTime"));
lb.setBookLend_EndTime(res.getString("BookLend_EndTime"));
lb.setUsers_ID(res.getInt("Users_ID"));
list.add(lb);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Users獲取User已借書的列表方法/////////////////////////////////////////////////
public ArrayList getUsersList(int count, int page) {
ArrayList list = new ArrayList();
try {
proc = conn.prepareCall("{call UsersPage (?,?,?)}");
proc.setInt(1, page);
proc.setInt(2, count);
proc.registerOutParameter(3, Types.INTEGER);
res = proc.executeQuery();
while (res.next()) {
UserBean ub = new UserBean();
ub.setUsers_ID(res.getInt(1));
ub.setUsers_Name(res.getString(2));
ub.setUsers_Pwd(res.getString(3));
ub.setUsers_Class(res.getString(4));
ub.setUsers_Sex(res.getString(5));
ub.setUsers_Count(res.getInt(6));
ub.setUsers_Phone(res.getString(7));
ub.setUsers_Adds(res.getString(8));
list.add(ub);
}
pagecount = proc.getInt(3);
} catch (SQLException ex) {
System.out.println("服務(wù)器異常發(fā)生在 getUsersList()");
ex.printStackTrace();
}
return list;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User刪除方法/////////////////////////////////////////////////
public boolean deleteUsers(int users_ID) {
try {
prepar = conn.prepareStatement(
"delete Users where Users_ID=?");
prepar.setInt(1, users_ID);
int flag = prepar.executeUpdate();
if (flag == 0) {
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -