[color=#FF0000][/color]Ê×ÏÈ£¬Ð»Ð»Äã»Ø´ðÎÒÕâ¸öÎÊÌ⣬ÇëÄã˵µÄʱºò˵Ã÷°×µã£¬ÒòΪÎÒÊǸöÐÂÊÖ£¬ÎÊÌâÈçÏÂ.
ÎÒÔÚMySQLÖÐ ²åÈë±íµÄÓï¾äΪ insert into news(id,title,content,ndatetime)values(2,"ÐÄϵÓñÊ÷","Ŀǰ¡¡","20010-01-20 17:00:05");
ÕâÑùµÄ»° ²éѯ±í ûÓÐÒ»µãÎÊÌâ¿ÉÊÇÎÒÔÚmyEclipseÖÐ Èç¹ûʹÓÃÔ¤±àÒëµÄSQLÓï¾ä²åÈëÊý¾ÝµÄ»°,ÔÙ²éѯÊý¾Ý¿â£¬ËùÓÐÖµ¶¼²åÈëµ½Êý¾Ý¿âÁË£¬¿ÉÊdzýÁËÈÕÆÚÒÔÍ⣬ÆäËûµÄ¶¼ÊÇÂÒÂë
ÒÔÏÂÊÇJAVAµÄÎļþ
package newdao;
import comdb.ConnectionManager;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;
public class NewsFirsTitleDB2 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con=null;
PreparedStatement stmt=null;
try
{
SimpleDateFormat hmfromat=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
con=ConnectionManager.getConnection();
String sql="insert into news(title,content,newtime)VALUES(?,?,?);";
stmt=con.prepareStatement(sql);
stmt.setString(1, "ÓñÊ÷");
stmt.setString(2, "°®ÉñµÄ¼ý");
stmt.setString(3, hmfromat.format(new Date()));
stmt.executeUpdate();
}catch(SQLException sqle)
{
sqle.printStackTrace();
}finally
{
ConnectionManager.closeStatement(stmt);
ConnectionManager.closeConnection(con);
}
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......