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
Ïà¹ØÎĵµ£º
×òÌì²Å¿´µ½£¬µ«ÊÇÓöµ½Ò»Ð©ÎÊÌ⣬½ñÌì½â¾öÁË£¬¼ÇÏ¡¡£¨²Î¿¼£ºhttp://netbeans.org/kb/55/beginning-jni-part1.html£©
ÎÒÓõÄÊÇNetbeans 6.7£¬µ«ÊÇºÍÆäËûµÄÒ²Ó¦¸Ã´óͬСÒì°É¡£ »ù±¾Á÷³Ì£º JavaÕâ±ßµÄ£º
´´½¨javaÎļþ£¨´ønativeµÄ£©£¬»¹Òª¼ÇµÃÔÚÀàÖмÓÈ룺System.loadLibrary(xxx) ¡£
È»ºóÓÃjavahÀ´Éú³ÉC/ ......
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Ò».µã»÷ͼÊ飬չʾ¸ÃÊéµÄÏêϸÐÅÏ¢
µã»÷ͼÊé→booksÒ³Ãæ→ͨ¹ýurlÖØÐ´displayBook.jsp?isbn=¸ÃÊé±àºÅ →´«ÈëdisplayBooksÒ³Ãæ→
<c:set var="isbn" value="${param.isbn}"></c:set>
<c:forEach var="currentBook" items="${sessionScope.bookTitles}">
<c:if test="${ ......
¿Î³ÌÄÚÈÝ
¸ü¼ÓʵÓÿÆÑ§µÄJava»ù´¡¿Î³Ì
¾ßÓÐÔúʵµÄ±àÂ빦µ×ÊÇÒ»¸öJava¹¤³Ìʦ±Ø±¸µÄÄÜÁ¦£¬ÎÒÃÇÁ¦Çó´ÓѧԱ½Ó´¥JavaµÄµÚÒ»ÌìÆð¾ÍÅàÑøÆäÐγÉÕýȷ˼¿¼ÎÊÌâµÄ·½Ê½¡£ÎÒÃǵĹØ×¢µã²»½ö½öÔÚÓÚ¶Ôij¸öÀà¿â£¨API£©µÄÕÆÎÕ£¬¸ü¶àµÄÊÇÏòѧԱչʾÆóÒµÖÐÕæÕýÒªÖØÊÓµÄÎÊÌ⣬ÀýÈçÒì³£ÈçºÎ´¦Àí¡¢Ëã·¨ÈçºÎÓÅ»¯µÈ¡£Í¬Ê±£¬ÎÒÃÇ×¢ÖØÈÃÑ§Ô±Ñø³ÉÁ¼ºÃµ ......
java»º´æ¼¼ÊõÒ»£¨×ª£©
¿´Ò»Á£É³ÖеÄÊÀ½ç£¬ Ò»¶äÒ°»¨ÖеÄÌìÌᣠ°ÑÎÞÏÞÎÕÓÚÕÆÖУ¬ °ÑÓÀºãÎÕÓÚ˲¼ä¡£——ÍþÁ®• ²¼À³¿Ë
¿ªÊ¼ÌÖÂÛ»º´æÖ®Ç°,ÈÃÎÒÃÇÏÈÀ´ÌÖÂÛÌÖÂÛÁíÍâÒ»¸öÎÊÌâ:ÀíÂÛºÍʵ¼ù.´Óahuaxuan½Ó´¥µÄ³ÌÐòÔ±À´¿´,ÓеijÌÐòԱƫʵ¼ù,ÓеijÌÐòԱƫÀíÂÛ,µ«ÊÇÕâ¶¼ÊDz»ºÃµÄÐÐΪ,ÀíÂÛºÍʵ¼ùͬÑùÖØÒª,ÎÒÃÇÔÚ×öºÜ¶àº ......