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

JAVA SQLSERVER Á¬½Ó

ÎÒдÁËÒ»¸öÁ¬½ÓSQLSERVERµÄÀ࣬µ«ÊDZ¨´í
com.microsoft.sqlserver.jdbc.SQLServerException: µ½Ö÷»ú  µÄ TCP/IP Á¬½Óʧ°Ü¡£ java.net.ConnectException: Connection refused: connect

´ó¼Ò°ïæ¿´¿´´úÂëÄÄÀï´íÁË
package cn.ctgu.edu.ac;
import java.sql.*;

public class connect {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String url="jdbc:sqlserver://localhost:1433;Database=ÍøÉÏÊéµê¹ÜÀíϵͳ;integratedSecurity=true;"; //ÓÃwidowsÉí·ÝµÇ¼
String sql="select * users";
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection(url);
Statement SQLStatement=conn.createStatement();
ResultSet rt=SQLStatement.executeQuery(sql);
while(rt.next())
{
System.out.println(rt.getInt("userID")+""+rt.getString("username"));
}
if(rt!=null)
{
rt.close();
}
if(SQLStatement!=null)
{
SQLStatement.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

»¹ÓУ¬ÔÚurlÖеĶ˿ںÅÓ¦¸ÃÊÇIPAllÖеÄÄÄÒ»¸ö£¿
ûÓÐÁ¬½ÓÉÏ ¼ì²ésql ÊÇ·ñÕý³£·ÃÎÊ¡£
¼ì²


Ïà¹ØÎÊ´ð£º

Unable to compile class for JSP - Java / Web ¿ª·¢

<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......

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

¶ÔÈյϹÐÐ.
ÄãÔõô² ......

ÇëÎÊÓÃjava´úÂëÈçºÎ¶ÁÈ¡javaµÄ×¢ÊÍ£¿

ÈçÌ⣬ÓÃjava´úÂëÀ´¶ÁÈ¡java×¢ÊÍ£¬¶ø²»ÓõÚÈý·½Èí¼þ¡£¿ÉÒԵϰ£¬Ï£Íû¿ÉÒÔ°Ñ´úÂëÕ³Ìù³öÀ´£¬Ð»Ð»~£¡
ÓÐЩעÊÍÔÚ±àÒëµÄʱºò¶¼¸ø¹ýÂ˵ôÁË

java×¢ÊÍÎ޷ǾͰüÀ¨£º"//","/*¡­¡­*/","/***/&quo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ