Javaµ÷Óô洢¹ý³Ì
±¾ÎIJûÊöÁËÔõôʹÓÃDBMS´æ´¢¹ý³Ì¡£ÎÒ²ûÊöÁËʹÓô洢¹ý³ÌµÄ»ù±¾µÄºÍ¸ß¼¶ÌØÐÔ£¬±ÈÈç·µ»ØResultSet¡£±¾ÎļÙÉèÄã¶ÔDBMSºÍJDBCÒѾ·Ç³£ÊìϤ£¬Ò²¼ÙÉèÄãÄܹ»ºÁÎÞÕÏ°µØÔĶÁÆäËüÓïÑÔд³ÉµÄ´úÂ루¼´²»ÊÇJavaµÄÓïÑÔ£©£¬µ«ÊÇ£¬²¢²»ÒªÇóÄãÓÐÈκδ洢¹ý³ÌµÄ±à³Ì¾Àú¡£
´æ´¢¹ý³ÌÊÇÖ¸±£´æÔÚÊý¾Ý¿â²¢ÔÚÊý¾Ý¿â¶ËÖ´ÐеijÌÐò¡£Äã¿ÉÒÔʹÓÃÌØÊâµÄÓï·¨ÔÚJavaÀàÖе÷Óô洢¹ý³Ì¡£ÔÚµ÷ÓÃʱ£¬´æ´¢¹ý³ÌµÄÃû³Æ¼°Ö¸¶¨µÄ²ÎÊýͨ¹ýJDBCÁ¬½Ó·¢Ë͸øDBMS£¬Ö´Ðд洢¹ý³Ì²¢Í¨¹ýÁ¬½Ó£¨Èç¹ûÓУ©·µ»Ø½á¹û¡£
ʹÓô洢¹ý³ÌÓµÓкÍʹÓûùÓÚEJB»òCORBAÕâÑùµÄÓ¦Ó÷þÎñÆ÷Ò»ÑùµÄºÃ´¦¡£Çø±ðÊÇ´æ´¢¹ý³Ì¿ÉÒԴӺܶàÁ÷ÐеÄDBMSÖÐÃâ·ÑʹÓ㬶øÓ¦Ó÷þÎñÆ÷´ó¶¼·Ç³£°º¹ó¡£Õâ²¢²»Ö»ÊÇÐí¿ÉÖ¤·ÑÓõÄÎÊÌ⡣ʹÓÃÓ¦Ó÷þÎñÆ÷ËùÐèÒª»¨·ÑµÄ¹ÜÀí¡¢±àд´úÂëµÄ·ÑÓã¬ÒÔ¼°¿Í»§³ÌÐòËùÔö¼ÓµÄ¸´ÔÓÐÔ£¬¶¼¿ÉÒÔͨ¹ýDBMSÖеĴ洢¹ý³ÌËùÕû¸öµØÌæ´ú¡£
Äã¿ÉÒÔʹÓÃJava£¬Python£¬Perl»òC±àд´æ´¢¹ý³Ì£¬µ«ÊÇͨ³£Ê¹ÓÃÄãµÄDBMSËùÖ¸¶¨µÄÌض¨ÓïÑÔ¡£OracleʹÓÃPL/SQL£¬PostgreSQLʹÓÃpl/pgsql£¬DB2ʹÓÃProcedural SQL¡£ÕâЩÓïÑÔ¶¼·Ç³£ÏàËÆ¡£ÔÚËüÃÇÖ®¼äÒÆÖ²´æ´¢¹ý³Ì²¢²»±ÈÔÚSunµÄEJB¹æ·¶²»Í¬ÊµÏÖ°æ±¾Ö®¼äÒÆÖ²Session ......
¾àÀëJava7µÄMR°æ±¾·¢²¼ÓжÎʱ¼äÁË£¬Í¨¹ý°²×°ÊÔÓÃÖ®ºóµÄ×ÜÌå¸Ð¾õÊÇ£ºËÙ¶ÈÓÖ¿ìÁË¡£×ÐϸÔĶÁÁËJava7µÄÏà¹ØÎĵµ·¢ÏÖ£¬Java7ÓµÓÐÈçϵÄһЩеÄÌØÐÔ¡£
Ê×ÏÈÊÇÄ£¿é»¯ÌØÐÔ£¬Èç¹ûÄú°²×°ºÍʹÓùýNetBeans6.7µÄ»°£¬ÊDz»ÊÇ»áÓÐÒ»¸öºÜ´óµÄ¸Ð¾õ£¬¾ÍÊÇNetBeans6.7µÄÆô¶¯ËٶȱÈÒÔÇ°¿ìÁ˺ܶ࣬µ±È»²¢²»ÊÇNetBeansÒѾʹÓÃÁËJava7£¬¶øÊÇNetBeans½«ÒÔÇ°Ò»Æô¶¯¾Í¼ÓÔصŦÄÜ»®·Ö³ÉÁ˺ܶàµÄÄ£¿é£¬µÚÒ»´Î°²×°Æô¶¯µÄʱºò£¬ºÜ¶àÄ£¿é¶¼Ã»ÓмÓÔØ£¬Ö»ÊǼÓÔØÁËһЩ×î»ù±¾µÄ¹¦ÄÜÄ£¿é£¬ÔÚËæºóµÄʹÓùý³ÌÖУ¬Èç¹ûÓõ½ÁËijһÖÖ¹¦ÄÜ£¬¾ÍÆôÓÃÏàÓ¦µÄÄ£¿é£¬ÕâÑùÐγÉÁËÒ»¸ö°´Ðè¼ÓÔصÄÌص㣬µ±È»Ëæ׿ÓÔصÄÄ£¿éÊýÁ¿Ôö¼Ó£¬Æô¶¯µÄËÙ¶ÈÒ²»áËæÖ®±äÂý¡£²»¹ý³ý·ÇÄãÒªÓÃÆäÖеÄËùÓÐÄ£¿é£¬·ñÔò×ÜÊDZÈ֮ǰµÄ°æ±¾ËÙ¶ÈÒª¿ì¡£ÏÖÔÚµÄJava7Ò²ÊDzÉÓÃÁËÄ£¿éµÄ»®·Ö·½Ê½À´ÌáËÙ£¬Ò»Ð©²»ÊDZØÐëµÄÄ£¿é²¢Ã»ÓÐÏÂÔغͰ²×°£¬Òò´ËÔÚʹÓÃȫеÄJava7µÄÐéÄâ»úµÄʱºò»á·¢ÏÖÕæµÄºÜ¿ì£¬µ±ÐéÄâ»úÐèÒªÓõ½Ä³Ð©¹¦ÄܵÄʱºò£¬ÔÙÏÂÔغÍÆôÓÃÏàÓ¦µÄÄ£¿é£¬ÕâÑùʹµÃ×î³õÐèÒªÏÂÔصÄÐéÄâ»ú´óСµÃµ½ÁËÓÐЧµÄ¿ØÖÆ¡£Í¬Ê±¶ÔÆô¶¯ËÙ¶ÈÒ²ÓÐÁ˺ܴóµÄ¸ÄÉÆ¡£Èç¹ûÄã¶ÔOpenJDKµÄ¼Ü¹¹±È½ÏÊìϤ£¬ÄãÉõÖÁ¿ÉÒÔ¶¨ÖÆJDKµÄÄ£¿é¡£
Æä´ÎÊǶàÓïÑÔ ......
1.µÃµ½µ±Ç°µÄʱ¼ä
Calendar cal = Calendar.getInstance();
String time=formatter.format(cal.getTime());
String strEnd=time.substring(0, 16);// 2007-10-30 09:30
Calendar cal = Calendar.getInstance();
String time=formatter.format(cal.getTime());
String strEnd=time.substring(0, 16);// 2007-10-30 09:30
2.µÃµ½Ç°Ò»ÌìµÄʱ¼ä
Calendar c = Calendar.getInstance();
c.add(Calendar.DAY_OF_MONTH, -1);
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String mDateTime=formatter.format(c.getTime());
String strStart=mDateTime.substring(0, 16);//2007-10-29 09:30
Calendar c = Calendar.getInstance();
c.add(Calendar.DAY_OF_MONTH, -1);
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String mDateTime=formatter.format(c.getTime());
String strStart=mDateTime.substring(0, 16);//2007-10-29 09:30
3.µÃµ½Ç°¼¸ÌìµÄʱ¼ä
Calendar c = Calendar.getInstance();
c.ad ......
¶ÔÓÚÔÓïÀàÐ͵ÄÊý×飬Èçint[] a,ÔÚCÀïÃæÖ»ÒªÕâÑù¶¨ÒåÖ®ºó¾Í¿ÉÒÔÓÃa[i]ʹÓÃÁË£¬µ«ÊÇÔÚJAVAÀïÃæÊDz»Ðеģ¬±ØÐëÓÃint[] a = new int[LENGTH];À´ÎªÊý×é·ÖÅä¿Õ¼ä¡£ÕâÀïµÄa¸üÓ¦¸Ã¿´³ÉCÀïÃæµÄÖ¸Õ룬ËüºÍCÀïÃæµÄint* aÊÇÒ»ÑùµÄ£¬ÒòΪÕâ¸öa£¨CÀïÃæµÄ£©Ò²ÒªÏÈmallocÒ»¸ö¿Õ¼äÖ®ºó²Å¿ÉÒÔÓá£
¶ÔÓÚ¶ÔÏóÊý×飬ÔòÒª“Á½´Î·ÖÅ䔣¬È磺
Object[] obj = new Object[2];
obj[0] = new Object();
obj[1] = new Object();
ÒòΪÊý×éÊ×ÏÈÊÇÒ»¸ö¾ä±ú£¬¶øÕâ¸ö¾ä±úÖ¸ÏòµÄ2¸ö¿Õ¼äÀïÃæÓÖÊÇ´æ´¢×ÅÁ½¸öÖ¸ÏòObjectÀàÐ͵ľä±ú¡£
¶øCÀïÃæ²»ÍêÈ«Ïàͬ£º
struct Object{};
struct Object* obj = (struct Object *)malloc(2 * sizeof(struct Object));
ÆäʵËûÃǵÄÔÀí´óÖÁÊÇÏàͬµÄ¡£Ö»²»¹ýJAVAÀïÊý×éµÄÄÚ´æ·ÖÅäÊÇÔÚ¶ÑÀïÃæµÄ£¬±ØÐ ......
¶ÔÓÚÔÓïÀàÐ͵ÄÊý×飬Èçint[] a,ÔÚCÀïÃæÖ»ÒªÕâÑù¶¨ÒåÖ®ºó¾Í¿ÉÒÔÓÃa[i]ʹÓÃÁË£¬µ«ÊÇÔÚJAVAÀïÃæÊDz»Ðеģ¬±ØÐëÓÃint[] a = new int[LENGTH];À´ÎªÊý×é·ÖÅä¿Õ¼ä¡£ÕâÀïµÄa¸üÓ¦¸Ã¿´³ÉCÀïÃæµÄÖ¸Õ룬ËüºÍCÀïÃæµÄint* aÊÇÒ»ÑùµÄ£¬ÒòΪÕâ¸öa£¨CÀïÃæµÄ£©Ò²ÒªÏÈmallocÒ»¸ö¿Õ¼äÖ®ºó²Å¿ÉÒÔÓá£
¶ÔÓÚ¶ÔÏóÊý×飬ÔòÒª“Á½´Î·ÖÅ䔣¬È磺
Object[] obj = new Object[2];
obj[0] = new Object();
obj[1] = new Object();
ÒòΪÊý×éÊ×ÏÈÊÇÒ»¸ö¾ä±ú£¬¶øÕâ¸ö¾ä±úÖ¸ÏòµÄ2¸ö¿Õ¼äÀïÃæÓÖÊÇ´æ´¢×ÅÁ½¸öÖ¸ÏòObjectÀàÐ͵ľä±ú¡£
¶øCÀïÃæ²»ÍêÈ«Ïàͬ£º
struct Object{};
struct Object* obj = (struct Object *)malloc(2 * sizeof(struct Object));
ÆäʵËûÃǵÄÔÀí´óÖÁÊÇÏàͬµÄ¡£Ö»²»¹ýJAVAÀïÊý×éµÄÄÚ´æ·ÖÅäÊÇÔÚ¶ÑÀïÃæµÄ£¬±ØÐ ......
String keyword = request.getParameter("keyword");
String timeRange = request.getParameter("timeRange");
String type = request.getParameter("type");
StringBuffer sql = new StringBuffer();
sql.append("use webstation_leadall select f.id,f.title,f.publishtime from information f left join infotype t on f.typeid=t.id where ");
if( (keyword == null)|| (keyword.equals("")) ){
sql.append("title like '%' and ");
}else {
sql.append("title like '%"+keyword +"%' and ");
}
if(timeRange.equals("")||timeRange==null){
sql.append("");
}else{
//Calendar cal = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd kk:mm:ss");
//String now = sdf.format(cal.getTime());
&nbs ......
String keyword = request.getParameter("keyword");
String timeRange = request.getParameter("timeRange");
String type = request.getParameter("type");
StringBuffer sql = new StringBuffer();
sql.append("use webstation_leadall select f.id,f.title,f.publishtime from information f left join infotype t on f.typeid=t.id where ");
if( (keyword == null)|| (keyword.equals("")) ){
sql.append("title like '%' and ");
}else {
sql.append("title like '%"+keyword +"%' and ");
}
if(timeRange.equals("")||timeRange==null){
sql.append("");
}else{
//Calendar cal = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd kk:mm:ss");
//String now = sdf.format(cal.getTime());
&nbs ......
ÊÇ¿½±´µÄ±ðÈ˵ģ¬ÒÔ±¸Ñ§Ï°
package com.unmi.db;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
/**
* ¶ÁÈ¡ SQL ½Å±¾²¢Ö´ÐÐ
* @author Unmi
*/
public class SqlFileExecutor {
/**
* ¶ÁÈ¡ SQL Îļþ£¬»ñÈ¡ SQL Óï¾ä
* @param sqlFile SQL ½Å±¾Îļþ
* @return List<sql> ·µ»ØËùÓÐ SQL Óï¾äµÄ List
* @throws Exception
*/
private List<String> loadSql(String sqlFile) throws Exception {
List<String> sqlList = new ArrayList<String>();
try {
InputStream sqlFileIn = new FileInputStream(sqlFile);
StringBuffer sqlSb = new StringBuffer();
byte[] buff = new byte[1024];
int byteRead = 0;
while ((byteRead = sqlFileIn.read(buff)) != -1) {
sqlSb.append(new String(buff, 0, byteRead));
}
// Windows Ï»»ÐÐÊÇ \r\n, Linux ÏÂÊÇ \n
String[] sqlArr = sqlSb.toString().split("(;\\s*\\r\\n) ......
ÊÇ¿½±´µÄ±ðÈ˵ģ¬ÒÔ±¸Ñ§Ï°
package com.unmi.db;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
/**
* ¶ÁÈ¡ SQL ½Å±¾²¢Ö´ÐÐ
* @author Unmi
*/
public class SqlFileExecutor {
/**
* ¶ÁÈ¡ SQL Îļþ£¬»ñÈ¡ SQL Óï¾ä
* @param sqlFile SQL ½Å±¾Îļþ
* @return List<sql> ·µ»ØËùÓÐ SQL Óï¾äµÄ List
* @throws Exception
*/
private List<String> loadSql(String sqlFile) throws Exception {
List<String> sqlList = new ArrayList<String>();
try {
InputStream sqlFileIn = new FileInputStream(sqlFile);
StringBuffer sqlSb = new StringBuffer();
byte[] buff = new byte[1024];
int byteRead = 0;
while ((byteRead = sqlFileIn.read(buff)) != -1) {
sqlSb.append(new String(buff, 0, byteRead));
}
// Windows Ï»»ÐÐÊÇ \r\n, Linux ÏÂÊÇ \n
String[] sqlArr = sqlSb.toString().split("(;\\s*\\r\\n) ......