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
{
private Connection con;
public static void main(String [] atgs)
{
QueryTest test = new QueryTest();
Connection con = test.getConnection();
String sql = "select * from Student";
test.getStudent(con, sql);
}
public void getStudent(Connection con, String sql)
{
try
{
Statement st = con.createStatement(); //ÉêÇë»á»°
ResultSet rs = st.executeQuery(sql); //»ñµÃ²éѯ¼Ç¼¼¯
while( rs.next() )
{
String name = rs.getString( "ÐÕÃû" );
String number = rs.getString( "ѧºÅ" );
String sex = rs.getString( "ÐÔ±ð" );
Date date = rs.getDate( "ÉúÈÕ" );
String spe = rs.getString( "רҵ" );
String address = rs.getString( "¼®¹á" );
System.out.println( "\nÐÕÃû£º " + name + "\tѧºÅ" + number + "\tÐÔ±ð" + sex
+ "\tÉúÈÕ" + date + "\tרҵ" + spe + "\t¼®¹á" + address );
}
st.close();
con.close();
}
catch( SQLException e )
{
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
´ó¼ÒºÃ£¬ÎÒÃǽüÆÚÕÐÆ¸È«Ö°¡¢¼æÖ°¿ª·¢¹¤³Ìʦ£¬È«Ö°¹¤³Ìʦ¹¤×÷µØµãÖ÷ÒªÊÇÉîÛÚ£¬¼æÖ°¹¤³Ìʦ±¾ÈË¿ÉÔÚÉîÛÚ£¬Ò²¿ÉÒÔÔÚÒìµØÍ¨¹ýÔ¶³ÌÐͬ¿ª·¢µÄ·½Ê½¿ªÕ¹¹¤×÷£¬ºÏ×÷·½Ê½¿É¹²Í¬É̶¨¡£
ְλE601£ºJava ¹¤³Ìʦ£¨Web ¿ ......