jdbcÀÇ date¿Í sqlÀÇ date ????????


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

±Û¾´ÀÌ :¿Í´Ï... 1999³â 10¿ù 11ÀÏ 17:52:40

ÇÁ·Î±×·¥À» Â¥´Ù°¡ ¹«Áö ±Ã±ÝÇÑ °ÍÀÌ ÀÖ´Â µ¥
jdbcÀÇ date¿Í sqlÀÇ date°¡ ´Ù¸¥°¡¿ä???
Áö±Ý ÇØ°áÃ¥Àº ¾ÆÁÖ °£´ÜÇÒ °Í °°Àº µ¥....
´ÙÀ½ ÇÁ·Î±×·¥ÀÇ run time error Á» ÇØ°áÇØ ÁÖ¼¼¿ä...


access fileÀ» odbc·Î ¿¬µ¿½ÃÄѼ­ mainÇÔ¼ö¿¡¼­ date¸¦ »ý¼º½ÃÄѼ­
À̸¦ ÇÔ¼ö ÀÎÀÚ·Î º¸³»¼­ sqlÀÇ query¿¡¼­ where¿¡¼­ date°¡ ¾²ÀÌ´Â µ¥
ÀÌ date ÀÇ ¼­·ÎÀÇ Å¸ÀÔÀÌ ¸ÂÁö ¾ÊÀº °Í °°Àºµ¥ .....
date¸¦ »©°í Çϸé Á¦´ë·Î ¼öÇàÀÌ µÇ°Åµç¿ä..



¾Æ¹«°Íµµ ¾Æ´Ï°Í °°Àºµ¥ ¸îÀÏÀ» °í½ÉÇÏ°í Àֳ׿ä...
¾Ë·ÁÁÖ¼¼¿ä..
±×°Ô ¾Æ´Ï¶ó¸é date¿¡ °üÇÑ ÀÚ·á¶óµµ ¾Ë·Á ÁÖ¼¼¿ä.
°í¸¿½À´Ï´Ù. ²Ù¹÷.......


------------------ ½ÇÇà ½Ã error --------------------
SQL Exception
SQLState : 22005
Message:[Microsoft][ODBC Microsoft Access 97 µå¶óÀ̹ö]
Á¶°Ç ½ÄÀÇ µ¥ÀÌÅÍ Çü½ÄÀÌ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.
Vendero:-3030


null
Process Exit...
_______________________________________________________________________


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 String output(Date date, String time) {
ResultSet rs;
query = "SELECT plan FROM myplan WHERE time = '"+time+ " 'and date = ' " +date+" ';";
try{
rs = stmt.executeQuery(query);
rs.next();
planning = rs.getString("plan");


}catch(SQLException e){
traceSQLException(e);
}
return planning;

}

public static void main(String args[]) throws SQLException{
String time = "mor";
String temp = "1999-10-10";
String plan = "dkdk";
Date date;
date = Date.valueOf(temp);


DBaccess today = new DBaccess("myplan");

System.out.println(today.output(date, time));

}


}


´ÙÀ½ ±Ûµé:



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

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


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