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

¹ØÓÚjavaÁ¬½Ósql2008µÄÎÊÌâ

ѧУҪÇó×ö¸ö¹ÜÀíϵͳ,Ïëͨ¹ýJAVAÁ¬½ÓSQL2008,°²×°ºÃÁËjdbc,ÔÚSQL2008ÀïÃæÒ²½¨ºÃÁ˵ǼÓû§,Á¬½Ó·½Ê½Ò²¸Ä³ÉÁËSQLºÍWINDOWS¶¼¿ÉÒԵǼ,Ò²½¨ºÃÁËyangkuanÕâ¸öµÇ¼Óû§,²¢ÇÒ¸øËû·ÖÅäÁËÊý¾Ý¿âËùÓÐÕߵĽÇÉ«,Ò²ÔÚ·þÎñÆ÷ÀïÃæ½¨ºÃÁËTestÊý¾Ý¿â,¿ÉÊÇÔÚeclipseÀïÃæÔËÐÐÈçϳÌÐò±¨´í,Ò»ÍíÉϵĵ÷ÊÔ¶¼ÎÞ·¨Õý³£µÇ¼·þÎñÆ÷,Çë½Ì¸ßÊÖ- -
Java code:
package test1;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class Connsql {

/**
* @param args
*/
public static void main(String[] args)
{
// TODO Auto-generated method stub

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").
newInstance();
System.out.println("Êý¾Ý¿âÇý¶¯³ÌÐò×¢²á³É¹¦£¡");
String url =
"jdbc:sqlserver://118.114.34.16:1433;DatabaseName=Test";
String user = "yangkuan";
String password = "yankguan1";
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("Êý¾Ý¿âÁ¬½Ó³É¹¦");

}
catch (Exception e) {
e.printStackTrace();
System.out.println("Êý¾Ý¿âÁ¬½Óʧ°Ü");
}

}

}



´íÎóÐÅÏ¢:
Êý¾Ý¿âÇý¶¯³ÌÐò×¢²á³É¹¦£¡
com.microsoft.sqlserver.jdbc.SQLServerException: Óû§ 'yangkuan' µÇÂ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÔÚjspÖÐÓÃsessionÔõôʵÏÖ¹ºÂò¹¦ÄÜ - Java / Web ¿ª·¢

ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ Ë­ÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá

ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë 
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:

public void doPost(HttpServletRequest reque ......

Ìì½ò ÕÐÆ¸¼æÖ°£¨java struts2)

ÎÒÃÇÓÐÏîÄ¿Ïë×齨һ¸ö¿ª·¢ÍŶӣ¬
Ö÷ÒªÓà tomcat,java,struts2,ÎÒÃǵĺËÐijÉÔ±¶¼ÊǾ­Ñé·Ç³£·á¸»µÄϵͳÉè¼ÆÊ¦£¬
Èç¹ûÄúÔÚÌì½ò£¬Í¬Ê±¶Ôjava±È½Ï¸ÐÐËȤ£¬
¿ÉÒÔ¼ÓÈëÎÒÃÇ¡£
Ï£ÍûÒªÇó
  1¡£°®ºÃ±à³Ì
......

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級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É

¶ÔÈյϹÐÐ.
ÄãÔõô² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ