Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½«Excelת»»³ÉsqlÎļþ£¬²åÈëÊý¾Ý¿â

ÐèÇó£ºÓÐexcelÎļþ£¬º¬¶à¸ösheet£¬Ã¿¸ösheetµÄÄÚÈݶÔÓ¦²åÈëµ½Ò»ÕÅ±í£¬sheetµÄÃû³Æ¾ÍÊǶÔÓ¦µÄ±íÃû³Æ¡£
 Ã¿Ò»ÐÐΪÁÐÃû£¬ÀýÈ磺
´ï³É£º½«Ã¿¸ösheetÊä³ö³ÉÒ»¸öÒÔsheetÃû³ÆÃüÃûµÄsqlÎļþ£¬ÄÚÈÝΪÿÐÐÄÚÈݵÄinsertÓï¾ä¡£
ÒÔÉÏͼΪÀý»áÉú³ÉÈý¸ösqlÎļþ£¬·Ö±ðÊÇTF_R_TERMINAL_ARCH.sql£¬ TF_R_STOCK_TRADE.sql ºÍ TF_R_STOCK_TRADE_DETAIL.sql  ÈçÏÂͼ
ÏÂÃæÊdzÌÐòExcelToInsert.java
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;
public class ExcelToInsert {
public static void main(String[] args) {
String table_name = ""; // ±íÃû
String sqlCell = ""; // ±íµ¥Ôª¸ñ
String SQL = ""; // ÍêÕûµÄÒ»ÌõSQL²åÈëÓï¾ä
final String EXL_NAME = "20100419"; // ExcelÎļþÃû
final String BASE_PATH = "F:/temp/"; // Îļþ·¾¶
final String IN_EXL_PATH = BASE_PATH + EXL_NAME + ".xls"; // excelPath
FileWriter fw = null;
int rows = 0;
int columns = 0;
try {
try {
Workbook rwb = Workbook.getWorkbook(new File(IN_EXL_PATH));
Sheet rs[] = rwb.getSheets();
// ±éÀúsheet
for (int i = 0; i < rs.length; i++) {
table_name = rwb.getSheetNames()[i]; // ±íÃûÈ¡sheetName
fw = new FileWriter(BASE_PATH + table_name + ".sql");
String preSql = "INSERT INTO TABLE "; // insertÓï¾äµÄÇ°°ë²¿·Ý
preSql += table_name + "(";
rows = rs[i].getRows();
columns = rs[i].getColumns();
// ±éÀúÐÐ
for (int j = 0; j < rows; j++) {
String sufSql = " VALUES( ";
if (j == 0) {// µÚÒ»ÐУ¬ÓÃÓÚÈ¡ÁÐÃû£¬ÔìinsertÓï¾äÇ°°ë²¿·Ý£¬Õⲿ·Ý¶ÔÓÚͬһÕűíÊÇÏàͬµÄ
for (int g = 0; g < columns - 1; g++) {
sqlCell = rs[i].getCell(g, 0).getContents().trim();
preSql += sqlCell + ",";
}
// insertÓï¾äÇ°°ë²¿·ÝÉú³É
preSql += rs[i].getCell(columns - 1, 0).getContents().trim()+ ") ";
}
// ÆäËüÐУ¬È¡¾ßÌåinsertµÄÄÚÈÝ£¬¼ÈinsertÓï¾äµÄºó°ë²¿·Ý
else {
for (int g = 0; g < columns - 1; g++) {
sqlCell = rs[i].ge


Ïà¹ØÎĵµ£º

SQL¿ç·þ²éѯ

½ñÈÕ²úÆ·²¿Òªµ¼ÅúÊý¾Ý£¬µ«ÊÇÐèÒªÁ¬½Ó²éѯ²éѯµÄ¼¸¸ö±í²»ÔÚͬһ·þÎñÆ÷ÉÏ¡£ËùÒÔÎÒ¿ªÊ¼ÊÇÕâô¸ÉµÄ£º
1.²éѯһ̨·þÎñÆ÷µÄÊý¾Ý£¬²¢µ¼Èë±¾µØExcel
2.²éѯÁíһ̨·þÎñÆ÷µÄÊý¾Ý£¬²¢µ¼Èë±¾µØExcel
3.Excleµ¼ÈëÊý¾Ý¿â£¬Êý¾Ý¿â×Ô´øÁËExcelµ¼ÈëÊý¾Ý¿âµÄ¹¦ÄÜ
4.Á¬½Ó²éѯ£¬OVER£¡
ºóÀ´²ÅÖªµÀ²úÆ·²¿ÒªÈ«¹ú50¶à¸ö³ÇÊеÄÊý¾Ý£¬ËùÒÔÿ¸ö³Ç ......

sql»ù±¾Óï¾ä

/*********************************************************/
Ŀ¼Çåµ¥CONTEXT LIST
/*********************************************************/
1.Êý¾Ý¿âDataBase
1.1Êý¾Ý¿â½¨Á¢/ɾ³ýcreate/drop database
1.2Êý¾Ý¿â±¸·ÝÓë»Ö¸´backup/restore database
/***************************************************** ......

Oracle SQL Developer¹¤¾ß²»ÄÜÆô¶¯½â¾ö°ì·¨

ÏÂÔؽâѹÁËOracle SQL Developer¹¤¾ß£¬ÔËÐÐʱ£¬Æô¶¯²»ÁË£¬±¨´íÐÅÏ¢ÈçÏ£º
---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<SQLDEVELOPER>\jdk\jre\bin\client\jvm.dll
---------------------------
ÊÇJVM²ÎÊýÉèÖõÄÎÊÌ⣬ÎҵĽâ¾ö·½°¸ÈçÏ£º
<SQ ......

·ÀÖ¹Ò³ÃæÔÚÌøתµÄʱºò±»SQL×¢Èë

Ê×ÏÈдһ¸öSQL×¢Èë¹ýÂ˵ÄÀࣺ
public class SqlFilter
{
#region SQL×¢Èëʽ¹¥»÷´úÂë·ÖÎö
/// <summary>
/// ´¦ÀíÓû§Ìá½»µÄÇëÇó
/// </summary>
public void StartProcessRequest()
{
string getkeys = "";
s ......

sql server 2005 ѧϰ±Ê¼Ç

µÚÒ»Õ£ºÐÅÏ¢Ìåϵ½á¹¹Ô­Ôò
¸ù¾ÝÒÔÏÂ7¸öÏ໥ÒÀÀµµÄÊý¾Ý´æ´¢Ä¿±êÉè¼ÆºÍÆÀ¹ÀÈκÎÊý¾Ý´æ´¢£º
l  ¼òµ¥ÐÔ£»
l  ÓÐÓÃÐÔ
l  Êý¾ÝÍêÕûÐÔ
l  ÐÔÄÜ
l  ¿ÉÓÃÐÔ
l  ¿ÉÀ©Õ¹ÐÔ
l  °²È«ÐÔ
 
¼Ü¹¹Éè¼ÆÔ­Ôò
l  ±ÜÃâ¹ýÓÚ¸´ÔÓ
l  ¾«ÐÄÌôÑ¡¼ü
l  Ê÷Á¢¿ÉÑ¡Êý¾Ý
l  ÊµÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ