JavaÁ¬½ÓSQL ServerÊý¾Ý¿â
ÓÃJavaÁ¬½ÓSQL Server2000Êý¾Ý¿âÓжàÖÖ·½·¨£¬ÏÂÃæ½éÉÜÆäÖÐ×î³£ÓõÄÁ½ÖÖ£¨Í¨¹ýJDBCÇý¶¯Á¬½ÓÊý¾Ý¿â£©¡£
1. ͨ¹ýMicrosoftµÄJDBCÇý¶¯Á¬½Ó¡£´ËJDBCÇý¶¯¹²ÓÐÈý¸öÎļþ£¬·Ö±ðÊÇmssqlserver.jar¡¢msutil.jarºÍmsbase.jar£¬¿ÉÒÔµ½Î¢ÈíµÄÍøվȥÏÂÔØ£¨http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en£©£¬Èç¹ûÄãÏÂÔصÄÊÇsetup.exe£¬»¹ÐèÒª°²×°Ëü£¬°²×°ºó»áÉú³ÉÉÏÃæµÄÈý¸öjarÎļþ¡£´ËJDBCÇý¶¯ÊµÏÖÁË JDBC 2.0¡£
Çý¶¯³ÌÐòÃû³Æ£ºcom.microsoft.jdbc.sqlserver.SQLServerDriver£¨¼´ÏÂÃæµÄclassforname£©
Êý¾Ý¿âÁ¬½ÓURL£ºjdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname£¨¼´ÏÂÃæµÄurl£©
2. ͨ¹ýJTDS JDBC DriverÁ¬½ÓSQL ServerÊý¾Ý¿â£¬´ËÇý¶¯µÄÎļþÃûΪjtds-1.2.jar£¬ÏÂÔØ·¾¶Îª£¨http://sourceforge.net/project/showfiles.php?group_id=33291£©£¬´ËÇý¶¯Ö§³ÖMicrosoft SQL Server (6.5, 7.0, 2000 ºÍ2005) ºÍSybase£¬²¢ÇÒʵÏÖÁËJDBC3.0£¬ÊÇÃâ·ÑµÄ¡£
Çý¶¯³ÌÐòÃû³Æ£ºnet.sourceforge.jtds.jdbc.Driver£¨¼´ÏÂÃæµÄclassforname£©
Êý¾Ý¿âÁ¬½ÓURL£ºjdbc:jtds:sqlserver://localhost:1433/dbname£¨¼´ÏÂÃæµÄurl£©
JDBCÁ¬½ÓSQL ServerÊý¾Ý¿âµÄBean´úÂëÍøÉÏ´ó°ÑµÄÓУ¬ÏÂÃæժ¼ÆäÖеÄÒ»²¿·Ö£º£¨Ç뽫localhostºÍ1433¸Ä³ÉÄãʵ¼ÊÓ¦ÓÃÖеÄSQL Server·þÎñÆ÷µØÖ·ºÍ¶Ë¿ÚºÅ£¬dbname¸Ä³ÉÄãʵ¼ÊµÄÊý¾Ý¿âÃû£©
import java.sql.*;
public class DatabaseConn {
private Connection conn;
private Statement stmt;
private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname";
private String classforname = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String uid = "sa";
private String pwd = "password";
public DatabaseConn(){}
/**
* <p>ͨ¹ýMicrosoft JDBCÇý¶¯»ñµÃÊý¾Ý¿âÁ¬½Ó</p>
* @return Connection
* @exception ClassNotFoundException, SQLException
*/
public Connection getConnection()
{
try
{
Class.forName(classforname);
if (conn == null || conn.isClosed())
conn = DriverManager.getConnection( url, uid, pwd);
}
catch (ClassNotFoundException ex)
{
ex.printStackTrace();
}
catch (SQLException ex)
{
ex.printStack
Ïà¹ØÎĵµ£º
×¼±¸Öð²½ÕûÀíÒ»ÏÂÊÖÖеĵÚÈý·½JavaÓÎÏ·´úÂ룬½«ÄÜÓõIJ¿·ÖÈÚÈëµ½LGameÀïÈ¥£¬Ã»ÓÐÄÜÓò¿·ÖµÄ¾ÍÖ±½Óɾµô¡£
µ«ÎÞÂÛ³ÌʽÄÑÒ×ÈçºÎ£¬Ò²ÊÇÔ×÷ÕßÒ»·¬ÐÄѪ£¬²»Ó¦½«ËüÃÇÆúÈç±ÖÂÄ£¬ËùÒÔÎÒ½«Ò»Ò»ÕûÀíºó·¢²¼µ½ÍøÉϱ£Áô£¨±ÜÃâʧ´«……£©£¬Ò²·½±ãÓÐÐèÒªµÄÅóÓѲο¼Ê¹Óá£
ÏÂÃæÉÏ´«µÄÊÇÒ»¸öJava°æºáÏòÉä»÷ÓÎÏ·£¬ËäÈ»´úÂë±È½ÏÁ ......
×î½ü×öÒ»¸öÏîÄ¿,˵ÆðÀ´±È½Ï¶ñ,ÊÇ´ÓÁíÒ»¸ö±íÖжÁÈ¡Êý¾ÝË͵½Õâ¸ö±íÖÐ.¶øÇÒÒªÓô¥·¢Æ÷Ñ»·ÕâЩÄÚÈÝÔÙ·¢³öÈ¥.
¿ÉÊÇÈç¹ûÕâ¸öÊý¾ÝÁ¿ºÜ´óµÄ»°,»áÒ»ÏÂ×Ó¹ÒËÀ.ËùÒÔ¾ÍÏëµ½ÁË.Äܲ»ÄÜ,ÿ´ÎÎÒ´«Ò»µã,¸ô¼¸ÃëÔÙËÍÒ»µã.
ÏÂÃæÊÇÒ»¸ö¼òµ¥µÄÀý×Ó
declare @i int
set @i=1
while @i<101
begin
insert into Cname ([name],csex,Number) ......
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó ......
SQL³£Ó÷ÖÒ³µÄ°ì·¨:
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
(SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
from ±íÃû
ORDER BY ID))
ORDER BY ID
//×Ô ......
MS SQL Server2000 Êý¾ÝÔ´ÅäÖÃ
£¨×¢£ºsqljdbc.jarÏÂÔز»µ½µÄ»°£¬ÕÒÎÒË÷È¡pengqinghui110@126.com)
1¡¢ÔÚÏîÄ¿µÄWebRootϵÄMETA-INFÖÐн¨context.xmlÎļþ¡£ÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/sqlserver"
&nbs ......