±Û¾´ÀÌ :ä½Â±â 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);
}
}