javaºÍSQLÁ¬½ÓÎÊÌâ
ÎÒÏëÓÃÒ»¸öjavaдһ¸ö¹ÜÀíÈí¼þ Ïë°ÉjavaºÍSQLÁ¬½ÓÆðÀ´
ÎÒÒѾÓÐJDBCÁË ¾ÍÊDz»ÖªµÀÔõôÓà ÔõôÁ¬½Ó
Ï£Íû¸ßÊÖÃǰï°ïÎÒ
¸üÏ£ÍûÓиöÊÓÆµ½ÌÎÒÓÃ
лл
Íû¸ßÊÖÃÇÖ¸µã
ÔÚÏ¸м¤²»¾¡
http://www.itcast.net/course/detail/945
ÕâÊÇÎÒ×Ô¼ºÔÚ±à³ÌʱһֱÓõÄÁ¬½Ó³Ø£¬Äã¾ÍÖ±½Óµ¼Èë½øÄãµÄÏîÄ¿ÖоͿÉÒÔÁË£¨¼ÇµÃÐ޸İüÃû£¬Êý¾Ý¿âÃû¡¢ÃÜÂ룬etc£©
DB.java
package com.majh.bean;
import java.sql.*;
public class DB {
public static Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost/bbs?" +
"user=root&password=root");
}catch(ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e) {
e.printStackTrace();
}
return conn;
}
public static Statement getStatement(Connection conn) {
Statement stmt = null;
try {
stmt = conn.createStatement();
}catch(SQLException e) {
e.p
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÏëÎÒjavaÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......
Ïë×öÒ»¸öjspµÄµç×ÓÉÌÎñÍøÕ¾£¬ÏëÕÒһЩԴ´úÂ룬ÇëÎÊÄǸöÍøÕ¾ÓкõÄ×ÊÔ´¡£Ð»Ð»£¡
ËÑË÷Ï塃 ¿ªÔ´µÄÒ²ÓÐ
csdn¾ÍÓÐÏàËÆµÄÔ´Â룬¥Ö÷ËÑÒ»ÏÂ
java ¿ªÔ´´óÈ«
¸ÄÄ£°åºÃÂ鷳Ŷ£¬»¹²»Èç×Ô¼ºÐ´¸öÁËÄØ
jf
¶¥Ò» ......