±Û¾´ÀÌ :¿Í´Ï 1999³â 10¿ù 13ÀÏ 16:35:54
Á¤¸»¡¡¿©·¯ºÐµéÀÇ¡¡µµ¿ò¡¡°í¸¿½À´Ï´Ù£®
±â¿Õ¿¡¡¡ºÎŹÇϴ¡¡±è¿¡¡¡³¡±îÁö¡¡ºÎŹÇغ¼¶ø´Ï´Ù£®
Àúµµ¡¡ÀÌ·¸°Ô¡¡Àú·¸°Ô¡¡Çغ¸´Â¡¡µ¥¡¡¾ÊµÇ´Â¡¡±º¿ä£®£®£®
³¯Â¥¸¦¡¡£á£ã£ã£å£ó£ó·ÎºÎÅÍ¡¡¾ò¾î³»´Â¡¡°ÍÀº¡¡Àß¡¡µÇ´Âµ¥¡¡
³¯Â¥¸¦¡¡£á£ã£ã£å£ó£ó¿¡¡¡Áý¾î¡¡³Ö´Â¡¡°ÍÀº¡¡¾ÈµÇ´Â¡¡
±º¿ä£®
À±°æ±¸´ÔÀÇ¡¡±ÛÀ»¡¡º¸°í¡¡£í£á£é£î¿¡¼¡¡´ÙÀ½°ú¡¡°°ÀÌ
¼öÁ¤Ç߰ŵç¿ä£®£®£®
¸Â³ªºÁÁֽǷ¡¿ä£®£®£®£®
import java.awt.*;
import java.sql.*;
public class DBaccess{
Statement stmt;
Connection con;
String planning;
String query;
Date today;
DBaccess(String dbname){
try{
//jdbc-odbcºê¸®Áö °ü·Ã µå¶óÀ̹ö Ŭ·¡½º ÀûÀç
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//DriverManager.setLog
//odbc¿¡ myplanÀ¸·Î µî·ÏµÈ µ¥ÀÌŸº£À̽º »ç¿ëÀÚ id¿Í password¸¦ ÁöÁ¤ÇÏ¿© Á¢¼ÓÇÑ´Ù.
con = DriverManager.getConnection("jdbc:odbc:"+dbname);
//Á¢¼Ó ÈÄ ÁúÀǹ® »ý¼º
stmt = con.createStatement();
}catch(ClassNotFoundException cnf){}
catch(SQLException sqle){}
}
public Date[] dateout() throws SQLException{
Date[] date = new Date[100];
int i = 0;
query = "SELECT date FROM myplan;" ;
ResultSet rs = stmt.executeQuery(query);
//resultSetÀÇ cursor´Â Ç×»ó óÀ½ÀÇ row¾Õ¿¡ À§Ä¡ÇϹǷÎ
//rs.next()·Î ´ÙÀ½À» ÁöÁ¤Çϵµ·Ï ÇÏ¿©¾ß ÇÑ´Ù.
while(rs.next()){
date[i] = rs.getDate("date");
i++;
}
rs = null;
return date;
}
public String input(Date date, String time, String plan) throws SQLException{
query = "INSERT INTO myplan( date, time, plan) VALUES(' "+date+ "','"+ time+"','"+ plan+"');";
stmt.executeUpdate(query);
return planning;
}
public String output(java.util.Date date, String time) {
try{
query = "SELECT plan FROM myplan WHERE time = '"+time+ " 'and date =' "+date+" ';";
ResultSet rs = stmt.executeQuery(query);
rs.next();
planning = rs.getString("date");
rs = null;
}catch(SQLException e){traceSQLException(e);}
return planning;
}
public void traceSQLException(SQLException e){
System.out.println("SQL Exception");
while(e != null){
System.out.println("SQLState : "+ e.getSQLState());
System.out.println("Message:" + e.getMessage());
System.out.println("Vendero:"+e.getErrorCode());
e = e.getNextException();
System.out.println("");
}
}
public static void main(String args[]) throws SQLException{
String time = "din";
String temp = "99-11-11";
String plan = "go to school";
java.util.Date date;
date = Date.valueOf(temp);
DBaccess today = new DBaccess("myplan");
java.text.SimpleDateFormat formatter =
new java.text.SimpleDateFormat("yy-MM-dd");
formatter.format(date);
System.out.println(today.output(date, time));
}
}