FilesExpand file tree

 master

/

ProviderDAO.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

127 lines (120 loc) · 3.8 KB

 master

/

ProviderDAO.java

Copy path

Top

File metadata and controls

• Code
• Blame

127 lines (120 loc) · 3.8 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

package com.dao;

import org.hibernate.Session;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Transaction;

import com.actionForm.ProviderForm;

import com.core.MySession;

public class ProviderDAO {

private Session session = null;

public List query(String strif) {

session = MySession.openSession(); //打开Session

List list=null;

String hql = "";

if (strif != "all" && strif != null && strif != "") { //条件查询

hql = "FROM ProviderForm provider WHERE " + strif +

"";

} else { //查询全部数据

hql = "FROM ProviderForm provider";

}

System.out.println(hql);

try{

Query query = session.createQuery(hql);

list = query.list();

}catch(Exception e){

e.printStackTrace();

}finally{

MySession.closeSession(session); //关闭Session

}

return list;

}

public int insert(ProviderForm providerForm){

int ret=0;

Transaction tx=null;

// ChStr chStr=new ChStr();

// providerForm.setName(chStr.toChinese(providerForm.getName()));

// providerForm.setAddress(chStr.toChinese(providerForm.getAddress()));

// providerForm.setBankName(chStr.toChinese(providerForm.getBankName()));

// providerForm.setMemo(chStr.toChinese(providerForm.getMemo()));

String str="name='" + providerForm.getName() + "'";

List list = query(str);

if (list.size()> 0) { //存在该信息

ret=2;

}else{

session=MySession.openSession(); //打开Session

try {

tx = session.beginTransaction();

session.save(providerForm);

tx.commit();

ret = 1;

} catch (Exception e) {

if (tx != null) {

tx.rollback();

}

System.out.println("添加供应商信息时的错误信息：" + e.getMessage());

return ret = 0;

} finally {

MySession.closeSession(session); //关闭Session

}

}

return ret;

}

//查询要修改的供应商信息

public ProviderForm query(int id){

session=MySession.openSession(); //打开Session

ProviderForm providerForm=null;

try{

providerForm=(ProviderForm)session.get(ProviderForm.class,id);

}catch(Exception e){

e.printStackTrace();

}finally{

MySession.closeSession(session); //关闭Session

}

return providerForm;

}

//修改供应商信息

public int Modify(ProviderForm providerForm){

session=MySession.openSession(); //打开Session

int id=providerForm.getId();

int ret = 0;

Transaction tx = null;

try {

tx = session.beginTransaction();

// ProviderForm providerF=(ProviderForm)session.get(ProviderForm.class,id);

session.update(providerForm);

tx.commit();

ret = 1;

} catch (Exception e) {

if (tx != null) {

tx.rollback();

}

System.out.println("修改供应商信息时的错误信息：" + e.getMessage());

return ret = 0;

} finally {

MySession.closeSession(session); //关闭Session

}

return ret;

}

//删除供应商信息

public int del(int id){

session=MySession.openSession(); //打开Session

int ret = 0;

Transaction tx = null;

try {

tx = session.beginTransaction();

ProviderForm providerF=(ProviderForm)session.get(ProviderForm.class,id);

session.delete(providerF);

tx.commit();

ret = 1;

} catch (Exception e) {

if (tx != null) {

tx.rollback();

}

System.out.println("删除供应商信息时的错误信息：" + e.getMessage());

return ret = 0;

} finally {

MySession.closeSession(session); //关闭Session

}

return ret;

}

}