[Re]select, insert, delete, update ó¸® ¹æ¹ý


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :ä½Â±â 1998³â 6¿ù 03ÀÏ 14:53:51

In Reply to: ¼Ò½ºÀÔ´Ï´Ù. posted by À¯Çü¿­ on 1998³â 6¿ù 02ÀÏ 15:44:28:

´ÙÀ½Àº ±âº»ÀûÀÎ SQLÀ» ó¸®Çϱâ À§ÇÑ 4°¡Áö ÇÔ¼öÀÔ´Ï´Ù.
ÀÌ°ÍÀ» °¡Áö°í Å×½ºÆ® ÇØ º¸¼¼¿ä.


/**
* Insert SQL
*/
public void InsertStrToDB(String eno, String ename)
{


try{
String insertSQL = "insert into emp(empno, ename) values(1, 'chai')";
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@hostIPaddr:port:SID", "scott", "tiger");
PreparedStatement instmt = conn.prepareStatement(insertSQL);
instmt.execute();
instmt.close();
conn.close();
}catch(Exception e){
System.out.println(e);
}
}
/**
* Select SQL
*/
public void RetrieveStrFromDB(String inStr)
{
String retStr = "select empno from emp where empno =1";
try{
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@hostIPaddr:port:SID", "scott", "tiger");


Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery (retStr);


while (rset.next ()){
System.out.println (rset.getString (1));
resultStr = rset.getString(1);
}
rset.close();
stmt.close();
conn.close();


}catch(Exception e){
System.out.println(e);
}
}



/**
* Delete SQL
*/
public void DeleteStrFromDB(String inStr)
{


try{
String deleteSQL = "delete emp where empno = 1";
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@hostIPaddr:port:SID", "scott", "tiger");


Statement stmt = conn.createStatement ();
int rset = stmt.executeUpdate(deleteSQL);


if(rset==1) System.out.println( "delete Succeed " );


stmt.close();
conn.close();


}catch(Exception e){
System.out.println(e);
}



/**
* Update SQL
*/
public void UpdateStrToDB(String inStr, String inStrName)
{
try{
String updateSQL = "update emp set ename= " + QUOTE + inStrName + QUOTE + " where empno = " + inStr;
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@hostIPaddr:port:SID", "scott", "tiger");


Statement upstmt = conn.createStatement();
int rsetUpdate = upstmt.executeUpdate(updateSQL);


if(rsetUpdate==1) System.out.println( "update Succeed : " + inStr);


upstmt.close();
conn.close();


}catch(Exception e){
System.out.println(e);
}
}


´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]