JavaÖÐÁ¬½ÓÊý¾ÝµÄHibernateÅäÖÃ
JavaÖÐÁ¬½ÓÊý¾ÝµÄHibernate
ÅäÖÃ
hibernate.cfg.xml
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- properties -->
<!--
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
<property name="connection.url">jdbc:microsoft:sqlserver://192.168.0.118;databasename=saadmin</property>
<property name="connection.username">sa</property>
<property name="connection.password">saadmin</property>
-->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://192.168.0.117:3306/mysqldb?useUnicode=true&characterEncoding=gb2312</property>
<property name="connection.username">root</property>
<property name="connection.password">adminroot</property>
<property name="hibernate.c3p0.acquire_increment">1</property>
<property name="hibernate.c3p0.idle_test_period">0</property>
&nb
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
1¡¢¹¤³§Ä£Ê½£º¿Í»§ÀàºÍ¹¤³§Àà·Ö¿ª¡£Ïû·ÑÕßÈκÎʱºòÐèҪijÖÖ²úÆ·£¬Ö»ÐèÏò¹¤³§ÇëÇó¼´¿É¡£Ïû·ÑÕßÎÞÐëÐ޸ľͿÉÒÔ½ÓÄÉвúÆ·¡£È±µãÊǵ±²úÆ·ÐÞ¸Äʱ£¬¹¤³§ÀàÒ²Òª×öÏàÓ¦µÄÐ޸ġ£È磺ÈçºÎ´´½¨¼°ÈçºÎÏò¿Í»§¶ËÌṩ¡£
¡¡¡¡2¡¢½¨Ôìģʽ£º½«²úÆ·µÄÄÚ²¿±íÏóºÍ²úÆ·µÄÉú³É¹ý³Ì·Ö¸î¿ªÀ´£¬´Ó¶øÊ¹Ò»¸ö½¨Ôì¹ý³ÌÉú³É¾ßÓв»Í¬µ ......
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
public class ConvertMapToList {
/**
* ʵÏÖ½«HashMapת»»³ÉΪArrayList£¬²¢½«mapµÄKey ¡¢Value·Ö± ......
ʹÓÃjinvokeµ÷ÓÃwindowsAPI¡£jnaʹÓñȽÏÂé·³£¬ÐèҪдc´úÂëºÍ²ÎÊýת»»£¬jinvokeµÄʹÓþÍÏñjdkÖеİüÒ»Ñù¡£
¹ÙÍøÊ¹Óòο¼£ºhttp://www.jinvoke.com/calling-the-win32-api-from-java
Ò»¸öµ¯³ö¿òµÄÀý×Ó£¨ÕâÖÖ´úÂëÓÃÓÚµ÷ÓÃÈκÎdll£¬²»Ö»ÊÇwindowsµÄ£¬Ò²¿ÉÒÔÊÇ×Ô¼ºÐ´µÄdll£©
import com.jinvoke.JInvoke;
import com.jinvok ......