±Û¾´ÀÌ :¿Í´Ï... 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));
}
}