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 ÊÇ·ñÕý³£·ÃÎÊ¡£
¼ì²
Ïà¹ØÎÊ´ð£º
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......