[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);
}
tableÔõô°ó¶¨Êý¾Ý¿â£¬²¢ÇÒÓÃJavaScriptʵÏÖ·Ò³¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£JavaScriptÄÜÏòJSPÒ³Ãæ´«µÝ²ÎÊýÂð
Äã˵µÄÎÊÌâÓеãÄǸö¡£¡££¬²»ºÃ»Ø´ð¡£¡£¡£¡£
jspÖÐtableÊÇÐèÒªhtml´úÂëÓëÒ³Ãæ¶Ë»ñÈ¡Êý¾Ý¿â²éѯºóµÄÐÅÏ¢½øÐÐ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
<head>
<title> ......