Java Êý¾Ý¿âµÄUtil
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import com.paic.is.dispatch.TMPEntry;
import javapasswordsdk.PSDKPassword;
import javapasswordsdk.PSDKPasswordRequest;
import javapasswordsdk.exceptions.PSDKException;
public class DBUtil
{
public final static String SELECT = " select ";
public final static String from = " from ";
public final static String WHERE = " where ";
public final static String ON = " on ";
public final static String LEFT_JOIN = " left join ";
public final static String RIGHT_JOIN = " right join ";
public final static String INNER_JOIN = " inner join ";
public final static String COLUMN_SEPARATOR = " , ";
public final static String INSERT = " insert ";
public final static String INTO = " into ";
public final static String UPDATE = " update ";
public final static String SET = " set ";
public final static String LEFT_PARENTHESES = " ( ";
public final static String RIGHT_PARENTHESES = " ) ";
public final static String SINGLE_QUOTATION = "'";
public final static String TO_DATE = "to_date";
public final static String COMMA = " , ";
public final static String VALUES = " values ";
public final static String CONCATENATE_SING = "&";
public final static String CONCATENATE_STRING = "||";
public final static String CONCATENEATE_REPLACEMENT = "||'&'||";
public static String packColumnName(String columnName)
{
return " " + columnName + " ";
}
public static void executeSqlMapBatch(HashMap<String, ArrayList<String>> sqlMap)
{
if(null == sqlMap || sqlMap.size() <=0)
{
return;
}
Connection conn = DBConnection.getConnection();
Statement stmt = null;
try
{
conn.setAutoCommit(false);
stmt = conn.createStatement();
for(Iterator<String> i
Ïà¹ØÎĵµ£º
JavaÊÂÎñAPI£¨JTA£»Java Transaction API£©ºÍËüµÄͬ°ûJavaÊÂÎñ·þÎñ(JTS£»Java TransactionService)£¬ÎªJ2EEƽ̨ÌṩÁË·Ö²¼Ê½ÊÂÎñ·þÎñ¡£Ò»¸ö·Ö²¼Ê½ÊÂÎñ£¨distributedtransaction£©°üÀ¨Ò»¸öÊÂÎñ¹ÜÀíÆ÷£¨transaction manager£©ºÍÒ»¸ö»ò¶à¸ö×ÊÔ´¹ÜÀíÆ÷(resource manager)¡£Ò»¸ö×ÊÔ´¹ÜÀíÆ÷£¨resource manager£©ÊÇÈÎÒâÀàÐ͵ ......
¸´ÖÆÊý×éµÄ·½·¨£º
ÔÚJAVAÀïÃæ£¬¿ÉÒÔÓø´ÖÆÓï¾ä“A=B”¸ø»ù±¾ÀàÐ͵ÄÊý¾Ý´«µÝÖµ£¬µ«ÊÇÈç¹ûA,BÊÇÁ½¸öͬÀàÐ͵ÄÊý×飬¸´ÖƾÍÏ൱ÓÚ½«Ò»¸öÊý×é±äÁ¿µÄÒýÓô«µÝ¸øÁíÒ»¸öÊý×飻Èç¹ûÒ»¸öÊý×é·¢Éú¸Ä±ä£¬ÄÇôÒýÓÃͬһÊý×éµÄ±äÁ¿Ò²Òª·¢Éú¸Ä±ä¡£
ÒÔÏÂÊǹéÄɵÄJAVAÖи´ÖÆÊý×éÔªËØÖµµÄµÄ·½·¨£º£¨É±´£©
1¡£Ê¹ÓÃFORÑ»· ......
package server;
import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.Container;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.geom.Ellipse2D;
import java.awt.geom.Recta ......
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Properties;
public class SystemProperties
{
public static String LINE_SEPARATOR = "line.separator";
public static String FILE_SEPARATOR = "file.separator";
public static String USER_LANGUAGE = "user.language";
......