blocks|key|1499677|text|我想知道如何做到这一点的唯一方法是为我的类设置两个属性。一个作为未包含在映射中的编程API的布尔值。它的getter和setter引用一个私有char变量，即Y/N。然后，我有另一个受保护的属性，该属性包含在hibernate映射中，它的getter和setter直接引用私有char变量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1499678|编辑:正如已经指出的那样，还有其他解决方案直接内置到Hibernate中。我之所以留下这个答案，是因为它可以在您使用的遗留字段与内置选项不能很好配合的情况下工作。最重要的是，这种方法没有严重的负面后果。|1499679|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The only way I've figured out how to do this is to have two properties for my class. One as the boolean for the programming API which is not included in the mapping. It's getter and setter reference a private char variable which is Y/N. I then have another protected property which is included in the hibernate mapping and it's getters and setters reference the private char variable directly.

EDIT: As has been pointed out there are other solutions that are directly built into Hibernate. I'm leaving this answer because it can work in situations where you're working with a legacy field that doesn't play nice with the built in options. On top of that there are no serious negative consequences to this approach.

blocks|key|1499722|text|Hibernate有一个内置的"yes_no“类型，它可以做你想做的事情。它映射到数据库中的CHAR(1)列。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1499723|基本映射：<property+name="some_flag"+type="yes_no"/>|offset|length|style|CODE|1499724|注释映射(Hibernate扩展)：|1499725|@Type(type="yes_no")
public+boolean+getFlag();|code-block|syntax|javascript|1499726|entityMap^0|0|5|16|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Hibernate has a built-in "yes_no" type that would do what you want. It maps to a CHAR(1) column in the database. 

Basic mapping: <code>&lt;property name="some_flag" type="yes_no"/&gt;</code> 

Annotation mapping (Hibernate extensions):

<pre><code>@Type(type="yes_no")
public boolean getFlag();
</code></pre>

blocks|key|1284887|text|要更好地将布尔映射到Y/N，请添加到hibernate配置中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1284888|
<property+name="hibernate.query.substitutions">true+'Y',+false+'N'</property>|code-block|syntax|javascript|1284889|现在，您可以在HQL中使用布尔值，例如：|1284890|"FROM+"+%2B+SomeDomainClass.class.getName()+%2B+"+somedomainclass+"+%2B
"WHERE+somedomainclass.someboolean+=+false"|1284891|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To even do better boolean mapping to Y/N, add to your hibernate configuration:

<pre><code>&lt;!-- when using type="yes_no" for booleans, the line below allow booleans in HQL expressions: --&gt;
&lt;property name="hibernate.query.substitutions"&gt;true 'Y', false 'N'&lt;/property&gt;
</code></pre>

Now you can use booleans in HQL, for example:

<pre><code>"FROM " + SomeDomainClass.class.getName() + " somedomainclass " +
"WHERE somedomainclass.someboolean = false"
</code></pre>

blocks|key|1499820|text|为了使用getter注解以通用的JPA方式完成此工作，下面的示例适用于我在Hibernate+3.5.4和Oracle+11g上的工作。注意，映射的getter和setter+(getOpenedYnString和setOpenedYnString)是私有方法。这些方法提供映射，但对类的所有编程访问都使用getOpenedYn和setOpenedYn方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1499821|private+String+openedYn;

@Transient
public+Boolean+getOpenedYn()+{
++return+toBoolean(openedYn);
}

public+void+setOpenedYn(Boolean+openedYn)+{
++setOpenedYnString(toYesNo(openedYn));
}

@Column(name+=+"OPENED_YN",+length+=+1)
private+String+getOpenedYnString()+{
++return+openedYn;
}

private+void+setOpenedYnString(String+openedYn)+{
++this.openedYn+=+openedYn;
}|code-block|syntax|javascript|1499822|下面是带有静态方法toYesNo和toBoolean的util类|1499823|public+class+JpaUtil+{

++++private+static+final+String+NO+=+"N";
++++private+static+final+String+YES+=+"Y";

++++public+static+String+toYesNo(Boolean+value)+{
++++++++if+(value+==+null)
++++++++++++return+null;
++++++++else+if+(value)
++++++++++++return+YES;
++++++++else
++++++++++++return+NO;
++++}

++++public+static+Boolean+toBoolean(String+yesNo)+{
++++++++if+(yesNo+==+null)
++++++++++++return+null;
++++++++else+if+(YES.equals(yesNo))
++++++++++++return+true;
++++++++else+if+(NO.equals(yesNo))
++++++++++++return+false;
++++++++else
++++++++++++throw+new+RuntimeException("unexpected+yes/no+value:"+%2B+yesNo);
++++}
}|1499824|entityMap^0|2H|H|2Z|H|49|B|4L|B|0|0|9|7|H|9|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|P|$]]

To do it in a generic JPA way using getter annotations, the example below works for me with Hibernate 3.5.4 and Oracle 11g. Note that the mapped getter and setter (<code>getOpenedYnString</code> and <code>setOpenedYnString</code>) are private methods. Those methods provide the mapping but all programmatic access to the class is using the <code>getOpenedYn</code> and <code>setOpenedYn</code> methods.

<pre><code>private String openedYn;

@Transient
public Boolean getOpenedYn() {
 return toBoolean(openedYn);
}

public void setOpenedYn(Boolean openedYn) {
 setOpenedYnString(toYesNo(openedYn));
}

@Column(name = "OPENED_YN", length = 1)
private String getOpenedYnString() {
 return openedYn;
}

private void setOpenedYnString(String openedYn) {
 this.openedYn = openedYn;
}
</code></pre>

Here's the util class with static methods <code>toYesNo</code> and <code>toBoolean</code>:

<pre><code>public class JpaUtil {

 private static final String NO = "N";
 private static final String YES = "Y";

 public static String toYesNo(Boolean value) {
 if (value == null)
 return null;
 else if (value)
 return YES;
 else
 return NO;
 }

 public static Boolean toBoolean(String yesNo) {
 if (yesNo == null)
 return null;
 else if (YES.equals(yesNo))
 return true;
 else if (NO.equals(yesNo))
 return false;
 else
 throw new RuntimeException("unexpected yes/no value:" + yesNo);
 }
}
</code></pre>

blocks|key|1285004|text|我使用了@marcg发布的答案中的概念，它在JPA+2.1中工作得很好。他的代码不太正确，所以我发布了我的工作实现。这会将Boolean实体字段转换为数据库中的Y/N字符列。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1285005|在我的实体类中：|1285006|@Convert(converter=BooleanToYNStringConverter.class)
@Column(name="LOADED",+length=1)
private+Boolean+isLoadedSuccessfully;|code-block|syntax|javascript|1285007|我的转换程序类：|1285008|/**
+*+Converts+a+Boolean+entity+attribute+to+a+single-character
+*+Y/N+string+that+will+be+stored+in+the+database,+and+vice-versa
+*+
+*+@author+jtough
+*/
public+class+BooleanToYNStringConverter+
++++++++implements+AttributeConverter<Boolean,+String>+{

++++/**
+++++*+This+implementation+will+return+"Y"+if+the+parameter+is+Boolean.TRUE,
+++++*+otherwise+it+will+return+"N"+when+the+parameter+is+Boolean.FALSE.+
+++++*+A+null+input+value+will+yield+a+null+return+value.
+++++*+@param+b+Boolean
+++++*/
++++@Override
++++public+String+convertToDatabaseColumn(Boolean+b)+{
++++++++if+(b+==+null)+{
++++++++++++return+null;
++++++++}
++++++++if+(b.booleanValue())+{
++++++++++++return+"Y";
++++++++}
++++++++return+"N";
++++}

++++/**
+++++*+This+implementation+will+return+Boolean.TRUE+if+the+string
+++++*+is+"Y"+or+"y",+otherwise+it+will+ignore+the+value+and+return
+++++*+Boolean.FALSE+(it+does+not+actually+look+for+"N")+for+any
+++++*+other+non-null+string.+A+null+input+value+will+yield+a+null
+++++*+return+value.
+++++*+@param+s+String
+++++*/
++++@Override
++++public+Boolean+convertToEntityAttribute(String+s)+{
++++++++if+(s+==+null)+{
++++++++++++return+null;
++++++++}
++++++++if+(s.equals("Y")+%7C%7C+s.equals("y"))+{
++++++++++++return+Boolean.TRUE;
++++++++}
++++++++return+Boolean.FALSE;
++++}

}|1285009|如果你喜欢表情符号，并且对数据库中的Y/N或T/F感到厌烦，这个变体也很有趣。在这种情况下，数据库列必须是两个字符，而不是一个字符。可能没什么大不了的。|1285010|/**
+*+Converts+a+Boolean+entity+attribute+to+a+happy+face+or+sad+face
+*+that+will+be+stored+in+the+database,+and+vice-versa
+*+
+*+@author+jtough
+*/
public+class+BooleanToHappySadConverter+
++++++++implements+AttributeConverter<Boolean,+String>+{

++++public+static+final+String+HAPPY+=+":)";
++++public+static+final+String+SAD+=+":(";

++++/**
+++++*+This+implementation+will+return+":)"+if+the+parameter+is+Boolean.TRUE,
+++++*+otherwise+it+will+return+":("+when+the+parameter+is+Boolean.FALSE.+
+++++*+A+null+input+value+will+yield+a+null+return+value.
+++++*+@param+b+Boolean
+++++*+@return+String+or+null
+++++*/
++++@Override
++++public+String+convertToDatabaseColumn(Boolean+b)+{
++++++++if+(b+==+null)+{
++++++++++++return+null;
++++++++}
++++++++if+(b)+{
++++++++++++return+HAPPY;
++++++++}
++++++++return+SAD;
++++}

++++/**
+++++*+This+implementation+will+return+Boolean.TRUE+if+the+string
+++++*+is+":)",+otherwise+it+will+ignore+the+value+and+return
+++++*+Boolean.FALSE+(it+does+not+actually+look+for+":(")+for+any
+++++*+other+non-null+string.+A+null+input+value+will+yield+a+null
+++++*+return+value.
+++++*+@param+s+String
+++++*+@return+Boolean+or+null
+++++*/
++++@Override
++++public+Boolean+convertToEntityAttribute(String+s)+{
++++++++if+(s+==+null)+{
++++++++++++return+null;
++++++++}
++++++++if+(HAPPY.equals(s))+{
++++++++++++return+Boolean.TRUE;
++++++++}
++++++++return+Boolean.FALSE;
++++}

}|1285011|entityMap^0|1P|7|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|13|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|14|8|@]|D|@]|E|$K|L]]|$1|U|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|V|$]]

I used the concept from the answer posted by @marcg and it works great with JPA 2.1. His code wasn't quite right, so I'm posted my working implementation. This will convert <code>Boolean</code> entity fields to a Y/N character column in the database.

From my entity class:

<pre><code>@Convert(converter=BooleanToYNStringConverter.class)
@Column(name="LOADED", length=1)
private Boolean isLoadedSuccessfully;
</code></pre>

My converter class:

<pre><code>/**
 * Converts a Boolean entity attribute to a single-character
 * Y/N string that will be stored in the database, and vice-versa
 * 
 * @author jtough
 */
public class BooleanToYNStringConverter 
 implements AttributeConverter&lt;Boolean, String&gt; {

 /**
 * This implementation will return "Y" if the parameter is Boolean.TRUE,
 * otherwise it will return "N" when the parameter is Boolean.FALSE. 
 * A null input value will yield a null return value.
 * @param b Boolean
 */
 @Override
 public String convertToDatabaseColumn(Boolean b) {
 if (b == null) {
 return null;
 }
 if (b.booleanValue()) {
 return "Y";
 }
 return "N";
 }

 /**
 * This implementation will return Boolean.TRUE if the string
 * is "Y" or "y", otherwise it will ignore the value and return
 * Boolean.FALSE (it does not actually look for "N") for any
 * other non-null string. A null input value will yield a null
 * return value.
 * @param s String
 */
 @Override
 public Boolean convertToEntityAttribute(String s) {
 if (s == null) {
 return null;
 }
 if (s.equals("Y") || s.equals("y")) {
 return Boolean.TRUE;
 }
 return Boolean.FALSE;
 }

}
</code></pre>

This variant is also fun if you love emoticons and are just sick and tired of Y/N or T/F in your database. In this case, your database column must be two characters instead of one. Probably not a big deal.

<pre><code>/**
 * Converts a Boolean entity attribute to a happy face or sad face
 * that will be stored in the database, and vice-versa
 * 
 * @author jtough
 */
public class BooleanToHappySadConverter 
 implements AttributeConverter&lt;Boolean, String&gt; {

 public static final String HAPPY = ":)";
 public static final String SAD = ":(";

 /**
 * This implementation will return ":)" if the parameter is Boolean.TRUE,
 * otherwise it will return ":(" when the parameter is Boolean.FALSE. 
 * A null input value will yield a null return value.
 * @param b Boolean
 * @return String or null
 */
 @Override
 public String convertToDatabaseColumn(Boolean b) {
 if (b == null) {
 return null;
 }
 if (b) {
 return HAPPY;
 }
 return SAD;
 }

 /**
 * This implementation will return Boolean.TRUE if the string
 * is ":)", otherwise it will ignore the value and return
 * Boolean.FALSE (it does not actually look for ":(") for any
 * other non-null string. A null input value will yield a null
 * return value.
 * @param s String
 * @return Boolean or null
 */
 @Override
 public Boolean convertToEntityAttribute(String s) {
 if (s == null) {
 return null;
 }
 if (HAPPY.equals(s)) {
 return Boolean.TRUE;
 }
 return Boolean.FALSE;
 }

}
</code></pre>

Can I setup JPA/hibernate to persist <code>Boolean</code> types as <code>Y/N</code>? In the database (the column is defined as <code>varchar2(1)</code>. It currently stores them as <code>0/1</code>. The database is Oracle.

Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1

数据库

我可以设置JPA/hibernate将Boolean类型持久化为Y/N吗？在数据库中(该列被定义为varchar2(1)。它目前将它们存储为0/1。数据库为Oracle。

问配置hibernate (使用JPA)为Boolean类型存储Y/N，而不是0/1
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问配置hibernate (使用JPA)为Boolean类型存储Y/N，而不是0/1EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问配置hibernate (使用JPA)为Boolean类型存储Y/N，而不是0/1
EN