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

ÓÃJavaдµÄMy SQL²Ù×÷·â×°Àà

Kagula
2009-11-17
 
¹Ø¼ü´Ê
    Java My SQL
 
¸ÅÒª£º
    ¶ÔMy SQL²Ù×÷·â×°µÄJavaÔ´ÂëʾÀý¡£
 
ÒªÇó»·¾³£º
    J2SE1.5 + Eclipse3.4.2
 
ÕýÎÄ£º
Ïȵ½ÍøÉÏÏÂÔØmysql-connector-java-5.0.8-bin.jar£¬²¢°ÑËü·Åµ½ÄãµÄJava ProjectµÄUser Library·¾¶ÖС£
ÏÂÃæÊÇCMySQLµÄÔ´ÂëÇåµ¥£¬¾ßÌåÈçºÎʹÓ㬲ο¼CMySQLµÄmain·½·¨¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
public class CMySQL {
private Connection conn;

public CMySQL(String sWhere,String sAccount,String sPWD)
{
connect(sWhere,sAccount,sPWD);
}

public void finalize()
{
shutdown();
}
private void connect(String sWhere,String sAccount,String sPWD)
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();

conn = DriverManager.getConnection(sWhere,sAccount,sPWD);
}catch(Exception ex)
{
ex.printStackTrace();
}
}

public boolean executeUpdate(String strSQL)
{
boolean bR=true;

try{
Statement stmt = conn.createStatement();
stmt.executeUpdate(strSQL);
}catch(SQLException ex)
{
ex.printStackTrace();
bR=false;
}

return bR;

}

public List<Map<String,String>> executeQuery(String strSQL)
{
List<Map<String,String>> list=new ArrayList<Map<String,String>>();
ResultSet rs;

try{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(strSQL);
if(rs.next())
{
ResultSetMetaData rsm = rs.getMetaData();
List<String> colNames = new ArrayList<String>();
for(int i=1;i<=rsm.getColumnCount();i++)
colNames.add(rsm.getColumnName(i));
do{


Ïà¹ØÎĵµ£º

javaÈëÃÅ

 Javaѧϰ´ÓÈëÃŵ½¾«Í¨ 
Ò»¡¢ JDK (Java Development Kit) 
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

javaÉú³ÉÑéÖ¤ÂëͼƬ£¨¸½£ºÑéÖ¤Âë½éÉÜ£©

import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.FileOutputStream;
import java.util.Random;
import com.sun.image.codec.jpeg.JPEGCodec;
import com.sun.image.codec.jpeg.JPEGImageEncoder;
/**
  *  ¹¦ÄÜÃèÊö ......

ÒÔjava±à³Ì·½Ê½µ÷Óà Apache Ant

 
±¾ÎÄÑÝʾÁËÈçºÎͨ¹ý Java µ÷Óà Apache Ant ¹¹½¨Îļþ¡£Äú½«¼ì²é±ØÒªµÄ Java ´úÂë²¢Á˽âÈçºÎÔÚ WebSphere Application Developer ÖÐÔËÐд˴úÂë¡£
ÒýÑÔ
Apache
Ant ÊÇÒ»¸ö»ùÓÚ Java µÄ¿ª·ÅÔ´´úÂë¹¹½¨ÊµÓù¤¾ß¡£ÈËÃdz£°ÑËüÓë Make ½øÐбȽϣ¬Make
³¤ÆÚÒÔÀ´Ò»Ö±ÓÃÓÚ°ïÖú×Ô¶¯Íê³É¹¹½¨¹ý³Ì¡£¾­¹ý²»Í¬°æ±¾µÄ¸Ä½ø£¬Ant Ò ......

SQL ºÍ´æ´¢¹ý³Ì¼¶±ðµÄÊÂÎñ¼°ADO.NET¼¶±ðµÄÊÂÎñ

 Êý¾Ý¿âÊÂÎñÊÇÆäËûÊÂÎñÄ£Ð͵Ļù´¡£¬µ±Ò»¸öÊÂÎñ´´½¨Ê±²»Í¬Êý¾Ý¿âϵͳ¶¼ÓÐ×Ô¼ºµÄ¹æ
Ôò¡£SQL Server ĬÈÏÔÚ×Ô¶¯Ìá½»µÄģʽϹ¤×÷£¬Ã¿¸öÓï¾äÖ´ÐÐÍêºó¶¼»áÁ¢¼´Ìá½»£»Óë´Ë¶ÔÕÕ
µÄÊÇ Oracle ÐèÒªÄã°üº¬Ò»¸öÌá½»Óï¾ä¡£µ«Êǵ±Ò»¸öÓï¾äͨ¹ý OLE  DB Ö´ÐÐʱ£¬ËüÖ´ÐÐÍêºó
Ò»¸öÌá½»¶¯×÷»á±»¸½¼ÓÉÏÈ¥¡£ÀýÈ磺
DECLARE  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ