¹ØÓÚ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' µÇÂ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
ÎÒÃÇÓÐÏîÄ¿Ïë×齨һ¸ö¿ª·¢ÍŶӣ¬
Ö÷ÒªÓà tomcat,java,struts2,ÎÒÃǵĺËÐijÉÔ±¶¼ÊǾÑé·Ç³£·á¸»µÄϵͳÉè¼ÆÊ¦£¬
Èç¹ûÄúÔÚÌì½ò£¬Í¬Ê±¶Ôjava±È½Ï¸ÐÐËȤ£¬
¿ÉÒÔ¼ÓÈëÎÒÃÇ¡£
Ï£ÍûÒªÇó
1¡£°®ºÃ±à³Ì
......
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對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......