±Û¾´ÀÌ :±èÇöö 2000³â 6¿ù 27ÀÏ 16:07:38
DB¿¡ updateÇÏ´Â ¹®Á¦Àä..
Ŭ·¡½º ¾È¿¡ °°Àº ¹æ¹ýÀ¸·Î DB¿¡ update ÇÏ´Â ¸Þ¼Òµå°¡
2°³(UpdateDB, UpdateRefDB)Àִµ¥ ¾ÕÀÇ°ÍÀº ÀߵǴµ¥
µÚ¿¡ °Í(UpdateRefDB)°¡ µµ´ëü updateµÇÁú ¾Ê½À´Ï´Ù.
¸çĥ° °í»ýÇÏ´Ù °í¼ö´ÔµéÀÇ Á¶¾ðÀ» ¾ò°íÀÚ ÇÕ´Ï´Ù.
ºÎŹµå¸³´Ï´Ù.
//¹®Á¦ÀÇ ¼Ò½º...
package Admin;
import java.io.*;
import java.text.*;
import java.util.*;
import java.io.IOException;
import java.sql.*;
import java.sql.SQLException;
import Admin.*;
public class DBupdate {
/* ÇÑ±Û Ã³¸® ºÎºÐ
public static String GetKoreanToDB(String Source)
{
String KrStr = null;
byte byteData[];
try
{
byteData = Source.getBytes("KSC5601");
KrStr = new String(byteData, "8859_1");
}
catch(UnsupportedEncodingException e){}
return KrStr;
}
*/
public void UpdateDB(String wLastId)
{
Connection conn= null;
PreparedStatement ps =null;
//ResultSet rs =null;
String stmt = null;
String wFileName = null;
String fName = null;
// 1. jdbc driver ¸¦ µî·ÏÇÑ´Ù.
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e )
{
System.err.println("Class Not Found : " + e.getMessage());
}
// 2. DB¿Í ¿¬°áÇÑ´Ù.
try
{
String url = "jdbc:odbc:eBack";
conn = DriverManager.getConnection(url,"sa","");
}
catch (SQLException e)
{
System.err.println("SQL Error : " + e.getMessage());
}
// 3. update
try
{
// ÇÑ±Û º¯È¯
wFileName = "data" + wLastId;
// fName = new String(wFileName); //wFileNameÀº ³Ñ°Ü¹ÞÀº FileName
ps = conn.prepareStatement( "update Banner set " + "FileName = ? Where ID= ? " );
ps.setString(1,wFileName);
ps.setString(2,wLastId);
ps.execute();
// 4.db¸¦ ´Ý´Â´Ù.
ps.close();
conn.close();
System.out.println("ÀÚ·á ÀúÀå ¿Ï·á");
}
catch (SQLException e)
{
System.out.println(e);
}
}
public void UpdateRefDB()
{
Connection conn= null;
PreparedStatement ps =null;
//ResultSet rs =null;
String stmt = null;
// 1. jdbc driver ¸¦ µî·ÏÇÑ´Ù.
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e )
{
System.err.println("Class Not Found : " + e.getMessage());
}
// 2. DB¿Í ¿¬°áÇÑ´Ù.
try
{
String url = "jdbc:odbc:eBack";
conn = DriverManager.getConnection(url,"sa","");
}
catch (SQLException e)
{
System.err.println("SQL Error : " + e.getMessage());
}
// 3. Reference field Update
String szBannerNameTime = null;
String Fname = null;
String Ftime = null;
int count = 0;
AllDBread rDB;
rDB = new AllDBread();
ResultSet rsUse = null;
ResultSet rsUseCount = null;
rsUse = rDB.ReadDB("SELECT DispTime, FileName FROM Banner Where UseStatus = 1");
rsUseCount = rDB.ReadDB("SELECT count(*) as Value FROM Banner Where UseStatus = 1");
//Recordset Count°ª¾ò±â.
try
{
if(!rsUseCount.wasNull())
{
rsUseCount.next();
count = rsUseCount.getInt("Value");
}
if(!rsUse.wasNull() && count > 0)
{
String[] pBannerName = new String[count];
String[] szBannerName = new String[count];
String[] pBannerTime = new String[count];
String[] szBannerTime = new String[count];
rsUse.next();
for(int i=0; i<count;i++)
{
pBannerName[i] = pBannerName[i] + rsUse.getString("FileName") ;
szBannerName[i] = pBannerName[i] + "#";
pBannerTime[i] = pBannerTime[i] + rsUse.getString("DispTime") ;
szBannerTime[i] = pBannerTime[i] + ";" ;
rsUse.next();
}
for(int j=0; j<count; j++)
{
Fname = Fname + szBannerName[j];
Ftime = Ftime + pBannerName + "," + szBannerTime[j];
}
szBannerNameTime = Fname + "?" + Ftime ;
ps = conn.prepareStatement("update Reference set" + "Name = ? Where PID=C0012");
ps.setString(1, szBannerNameTime);
ps.execute();
// db¸¦ ´Ý´Â´Ù.
ps.close();
conn.close();
System.out.println("ÀÚ·á ÀúÀå ¿Ï·á");
}
}
catch(SQLException e)
{
System.out.println("SQL Error : " + e.getMessage());
}
}
}