javaÈÕÆڵĴ¦Àí
ÏÂÃæÊdz£Óô¦ÀíÈÕÆڵķ½·¨£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¡
ÔÚÎÒmysql Êý¾Ý¿âÖÐÓÐÕÅBlog±íµÄ×Ö¶ÎΪDateÐÍ£¬ÎÒÃǾ³£×öµÄÊÇ°ÑËüÈ¡³öÀ´·ÅÔÚÒ³ÃæÉÏÏÔʾ¾ßÌåµÄÄêÔÂÈÕ»ò°üÀ¨Ê±·ÖÃë £¡
public static String DRIVER = "com.mysql.jdbc.Driver";
public static String URL = "jdbc:mysql://localhost:3306/blog";
public static String USERNAME = "root";
public static String PASSWORD = "123";
/**
* @param args
* ºÍÊý¾Ý¿â´ò½»µÀµÄÀà
* java sql.Date ÈÕÆÚÀà
* java sql Time ʱ¼äÀà
* java sql Timestamp ÈÕÆÚʱ¼äÀà
* ÕâÈý¸öÀ඼¼Ì³Ð java .util Date
* ͨ¹ýSimpleDataFormat ½øÐиñʽ»¯
* java .util .Calendar ÈÕÀúÀà¿ÉÒÔÈ¡µÃËùÓж«Î÷ Ëü¼Ì³ÐObjectÀà
* java .util .Timezone ʱÇøÀà ´«½øÒ»¸öCalendar Ò»°ãÎÒÃǵõ½µÄCalendarÊÇϵͳĬÈϵÄʱȥ ÒªÉèÖÃʱÇø´«½øÒ»¸öCalendar ¼´¿É
*/
public static void main(String[] args) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME,
PASSWORD);
String sql = "select birthday from date";
ps =conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next())
{
°ÑÊý¾Ý¿âÖеÄDateÐÐת»»ÎªStringÐÐ Date ÀàÐÍÖ»ÄÜÄõ½ÈÕÆÚ ²»ÄÜÄõ½Ê±¼ä
Date date =rs.getDate("birthday");//·µ»ØµÄÊÇÒ»¸
Ïà¹ØÎĵµ£º
ת×Ô
http://blog.pfan.cn/sword2008/13772.html
Ò»¡¢static
¡¡¡¡ÇëÏÈ¿´ÏÂÃæÕâ¶Î³ÌÐò£º
public class Hello{
public static void main(String[] args){
//(1)
System.out.println("Hello,world!"); //(2)
......
javeÔõôѧϰ×î¿ì
2008-11-08 06:57
ÓûËÙÔò²»´ï£¬Ñ§Ï°JAVAûÓГ¿ÉÒÔÀ”ÕâÖ̶ֳȡ£·á¸»¶à²Ê£¬Ñ§Ï°Ò»ÄêµÄʱ¼äÒ²²»Ò»¶¨ÄÜѧÍê»ù´¡£¬ÎÒÔø¾Ò²Ïë¹ýÕâ¸öÎÊÌ⣬µ«ºóÀ´¿´ÁËһƪÎÄÕ£¬±ã³¹È»ÐÑÎò¡£ÏÂÃæÕâƪÎÄÕ£¨²»ÒªÏÓ³¤£¬¿´Íê¾ÍÓÐÊÕÒ棬»¹ÓдËÎÊÌâ²»Òª¹Ø±Õ»òÊÇͶƱ£¬»Ø´ð¶¼ÊÇÐÁ¿àµØ£¬²»Òª´ò»ý¼«ÐÔ£¬²»¹»ºÃÒ²½«¾ÍЩ°É ......
1. ¹ØÓÚConnection Pool
JDBC±¾Éí²»ÌṩÁ¬½Ó³Ø¼¼Êõ£¬ÐèÒªµÚÈý·½¿âµÄÖ§³Ö¡£
ÔÚÐèҪƵ·±»ñµÃÁ¬½ÓµÄApplicationÖÐ×îºÃÓÃConnection Pool£¬ÈçWeb ApplicationÖÐ
¶ÔÓÚÒ»°ãµÄJava ApplicationÔò¿ÉÒÔÖ±½ÓÓÃJDBCÁ¬½ÓÊý¾Ý¿â¡£
2. Java ApplicationÖÐÁ¬½ÓDB2
°²×°DB2 Personal Edition V9Ö®ºó£¬ÔÚÆäÖ ......
1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
public static String entry ......