Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT NULL,
FRIEND_SEX CHAR(2) NOT NULL,
FRIEND_BIRTHDAY DATATIME NOT NULL,
FRIEND_WORKUNIT VARCHAR(100),
FRIEND_HOMEADD VARCHAR(200),
FRIEND_PHONECODE VARCHAR(40),
FRIEND_MOBILE VARCHAR(20) NOT NULL,
FRIEND_QQ VARCHAR(20) NOT NULL,
FRIEND_EMAILE VARCHAR(40),
FRIEND_ MAILINGADD VARCHAR(200),
FRIEND_POSTCODE VARCHAR(10));
Ϊʲô²»ÐÐÄØ£¿
×îºó¼ÓÉÏcommit;ÊÔÊÔ

Óï¾ä¿´²»³ö´íÀ´£¬Ìù³ö´íÎóÐÅÏ¢

¿´²»³öÀ´´í°¡



ÒýÓÃ
SQL codeCREATEDATABASE ADDRESSLIST;USE ADDRESSLIST;DROPTABLEIFEXISTS FRIEND;CREATETABLE FRIEND
(FRIEND_IDINTEGERNOTNULL AUTO_INCREMENTPRIMARYKEY ,
FRIEND_NAMEVARCHAR(20)NOTNULL,
FRIEND_SEXCHAR(2)NOTNULL,
FRIEND_BIRTHDAYDATETIMENOTNULL,
FRIEND_WORKUNITVARCHAR(100),
FRIEND_HOMEADDVARCHAR(200),
FRIEND_PHONECODEVARCHAR(40),
FRIEND_MOBILEVARCHAR(20)NOTNULL,
FRIEND_QQVARCHAR(20)NOTNULL,
FRIEND_EMAILEVARCHAR(40),
FRIEND_MAILINGADDVARCHAR(200),
FRIEND_POSTCODEVARCHAR(10));
´íÎóÁ½´¦£º
FRIEND_BIRTHDAYDATATIMENOT NULL,⇒DATATIME ´íÎó£¬ÕýÈ·ÊÇDATETIME
FRIEND_ MAILINGADD VARCHAR(200), º¬Óпոñ


ÕæÏ¸ÐÄ£¬ÔÞ

4Â¥ºÜÈÏÕæ¡£¡£ºÃ¡£¡£


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

Çó職£¬java·½Ãæ - °¤ÌßÖ°ÑÄ / ²ÅÈëÖ°³¡

Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É

¶ÔÈյϹÐÐ.
ÄãÔõô² ......

execlÔõôµ÷ÓÃjava³ÌÐò - C/C++ / CÓïÑÔ

ÈçÌ⣬C/C++ÖеÄexeclÔõôµ÷ÓÃдºÃµÄjava³ÌÐò£¬
execl("/opt/java1.5/bin/java","MyClass",NULL);
ÕâÑùµÄ²»ÐÐŶ¡£

²»»á.

ÔËÐÐjava³ÌÐò
ÕÒ¹¤¾ß²é¿´Ò»ÏÂÄǸö³ÌÐòµÄÃüÁîÐÐ

ËÑË÷Ï£ºjni ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

¹ØÓÚAJAXºÍJSPµÄһЩСÎÊÌâ¡« - Java / Web ¿ª·¢

ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
  %>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ