javaÎļþÁ¬½ÓmysqlÊý¾Ý¿âÂÒÂë - Java / Eclipse
ÏÖÔÚÕâ¸öÎÊÌ⻹ûÓнâ¾ö£¬ÎÒÔÚmyeclipseÖÐjdbcÁ¬½ÓmysqlÊý¾Ý¿â£¬ºóÀ´×öÁËÊý¾Ý²âÊÔ£¬É¾³ý£¬²éѯµÃµ½µÄÊý¾ÝºÜÕý³££¬µ«ÊÇ£¬²åÈëÊý¾Ý£¬Ö»ÒªÓÐÖÐÎÄ£¬ÓÀÔ¶¶¼ÊÇÂÒÂ룬°üÀ¨¸üÐÂÊý¾Ý£¬Ò²ÊÇÂÒÂë¡£¿´ÁËÍøÉÏ´ò´óƪµÄµÄÈçºÎ¸Ä£¬ÎÒ¶¼¸ÄÁË£¬¿ÉÊÇ»¹ÊDz»ÐС£Õâ¸öÎÊÌâ¿àÄÕËÄÌìÁË¡£ÕæÊǹ»·³È˵ġ£»¹ÇóÓÐÄÜÁ¦µÄ¸ø¸ö»Ø´ð¡£Ëµ·çÁ¹»°£¬ºÍ˵Á˵ÈÓÚûÓÐ˵µÄÇë±ðÀË·ÑÐÄÇé¡£
ÏÂÃæÌṩ×ÊÁÏ¡£
Õâ¸öÊÇÁ¬½ÓjdbcµÄURL
import java.sql.*;
public class ConnectionManager {
private static final String DRIVER_CLASS="com.mysql.jdbc.Driver";
//url="jdbc:mysql://localhost:3306/examonline?useUnicode=true&characterEncoding=GBK"
private static final String DATABASE_URL="jdbc:mysql://localhost:3306/newsdb";
private static final String DATABASE_USER="root";
private static final String DATABASE_PASSWORD="3022103";
public static Connection getConnection()
{
Connection dbcon=null;
try {
Class.forName(DRIVER_CLASS);
dbcon=DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return dbcon;
}
PS Á¬½ÓÍêÈ«Õý³££¬Ã»ÓÐÒ»µãÎÊÌâ¡£
ÏÂÃæÊÇÎÒÔÚmysql´´½¨Êý¾Ý¿âÒÔ¼°²åÈëµÄÊý¾ÝÖµ£¬Ò²Ã»ÓÐÎÊÌâ¡£
CREATE DATABASE newsdb;
USE newsdb;
DROP TABLE IF EXISTS FristTitle;
CREATE TABLE FristTitle(id INT UNSIGNED NOT NULL AUTO_INCREMENT,
FristName VARCHAR(50) NOT NULL,
creator VARCHAR(50) NOT NUL
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
java swing ³ÌÐòÈçºÎ´ò°ü³Éjar£¬È»ºó¿ÉÒÔͨ¹ýÅú´¦ÀíÎļþbatÖ±½ÓÔËÐУ¬ÓÐûÓÐʲô¹¤¾ßÖ±½Ó¿ÉÒÔÍê³ÉÕâÁ½¸ö¹¤×÷£¿
ÓÃjar´ò°ü£¬°ÑÔËÐÐÐèÒªµÄjar¿½±´µ½Ò»¸öĿ¼£¬Åú´¦ÀíÓà start javaw -cp .;ÆäËû°ü·¾¶ ÔËÐÐ
ÓÃzip ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......