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 )
{
Ïà¹ØÎÊ´ð£º
ÎÒĿǰÔÚ±¾µØµÄlinuxÉÏдÁËÒ»¸öswingµÄ½çÃæ£¬Ïëͨ¹ýÕâ¸ö½çÃæÀ´¿ØÖÆÆäËüµçÄÔµÄlinuxÖØÆô¡£
ÎÒÖªµÀÓÃRuntime.getRuntime().exec("shutdown -r");¿ÉÒÔ¿ØÖƱ¾»úLinuxÖØÆô£¬µ«ÊÇÔõô¿ØÖÆÔ¶³ÌµÄlinuxÖØÆôÄØ£¿ ......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
×Ö·ûÁ÷µÄ¶ÁºÍд×îÖÕÔڵײ㶼ÊÇͨ¹ý×Ö½ÚÁ÷À´Íê³ÉµÄÂ𣿡¡¶ÁдÎı¾Îļþ×Ö·ûÁ÷Ó¦¸Ã¾Í¿ÉÒÔÁ˰ɡ£¡£
¸÷λ´ó¸ç´ó½ã°ï°ïæ°¢
JavaÁ÷°üÀ¨×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷£¬×Ö½ÚÁ÷ͨ¹ýIOÉ豸ÒÔ×Ö½ÚÊý¾ÝµÄ·½Ê½¶ÁÈ룬¶ø×Ö·ûÁ÷ÔòÊÇͨ¹ý×Ö½ÚÁ÷ ......
´ó¼ÒºÃ£¬ÎÒÃǽüÆÚÕÐÆ¸È«Ö°¡¢¼æÖ°¿ª·¢¹¤³Ìʦ£¬È«Ö°¹¤³Ìʦ¹¤×÷µØµãÖ÷ÒªÊÇÉîÛÚ£¬¼æÖ°¹¤³Ìʦ±¾ÈË¿ÉÔÚÉîÛÚ£¬Ò²¿ÉÒÔÔÚÒìµØÍ¨¹ýÔ¶³ÌÐͬ¿ª·¢µÄ·½Ê½¿ªÕ¹¹¤×÷£¬ºÏ×÷·½Ê½¿É¹²Í¬É̶¨¡£
ְλE601£ºJava ¹¤³ÌÊ ......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......