javaÊý¾Ý¿âÁ¬½Ó¼°²âÊÔ(sqlserver)
package com.test.util;
import java.sql.*;
public class ConnectDB {
private Connection conn=null;
private PreparedStatement pt=null;
private ResultSet rs=null;
private String uname="sa";
private String upwd="sa";
private String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=vsktest";
public Connection getConnection() throws Exception{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection(url, uname, upwd);
return conn;
}
public void closeDB() throws Exception{
if(rs!=null){
rs.close();
}
if(pt!=null){
pt.close();
}
if(conn!=null){
conn.close();
}
}
public static void main(String[] args) throws Exception {
Connection conn=new ConnectDB().getConnection();
PreparedStatement pt=conn.prepareStatement("select * from test");
ResultSet rs=pt.executeQuery();
while(rs.next())
{
System.out.println(rs.getString("testname"));
}
}//end main
}
Ïà¹ØÎĵµ£º
ÓÐʱºòÎÒÃÇ»áÓöµ½java³ÌÐòʹÓÃÄÚ´æ¹ý¶àµÄÇé¿ö£¬ÕâÖÖÇé¿öÒ»°ãÊÇÒòΪ³ÌÐòÓÐÄÚ´æÐ¹Â©£¬ÄÇôÈçºÎ·ÖÎöÊÇ·ñÓÐÄÚ´æÐ¹Â©ÄØ£¿ÆäʵÔÒò±È½Ï¼òµ¥£¬ÏÈÓÃjmapÀ´Éú³ÉÒ»¸ö½ø³ÌµÄÄÚ´æ¿ìÕÕ£¬È»ºóÀûÓÃheapAnalyzer»òÕßMod4JÀ´¶ÔÕâ¸ö¿ìÕÕ½øÐзÖÎö£¬ÕÒµ½ÄÚ´æÊ¹ÓÃ×î¶àµÄ¶ÔÏ󡣯äʵÓÐÎÞÄÚ´æÐ¹Â©µÄÒ»¸ö±íÏÖ¾ÍÊÇÄÚ´æ·Ö²¼ÊÇ·ñ¾ùÔÈ£¬Èç¹û²»¾ùÔÈ£¬Ò»°ãÀ ......
½áºÏ±¾ÈËѧϰ¾ÑéºÍÍøÉÏÅàѵ»ú¹¹µÄ×ÊÁÏ£¬ÁгöjavaѧϰµÄ˳Ðò¡£
Ò»£ºJ2SE
¡ðÃæÏò¶ÔÏó£·â×°¡¢¼Ì³Ð¡¢¶à̬
¡ðÄÚ´æµÄ·ÖÎö
¡ðµÝ¹é
¡ð¼¯ºÏÀà¡¢·ºÐÍ¡¢×Ô¶¯´ò°üÓë½â°ü¡¢Annotation
¡ðIO
¡ð¶àÏ̡߳¢Ïß³Ìͬ²½
¡ðTCP/UDP
¡ðAWT¡¢Ê¼þÄ£ÐÍ¡¢ÄäÃûÀà
¡ðÕýÔò±í´ïʽ
¡ð·´Éä»úÖÆ
2£ºÊý¾Ý¿â£¨Oracle»òÕßMySQL£©
¡ðSQLÓï¾ä
......
Ò»¸öÓÅÐãµÄJava³ÌÐòÔ±±ØÐëÁ˽âGCµÄ¹¤×÷ÔÀí¡¢ÈçºÎÓÅ»¯GCµÄÐÔÄÜ¡¢ÈçºÎÓëGC½øÐÐÓÐÏ޵Ľ»»¥£¬ÒòΪÓÐһЩӦÓóÌÐò¶ÔÐÔÄÜÒªÇó½Ï¸ß£¬ÀýÈçǶÈëʽϵͳ¡¢ÊµÊ±ÏµÍ³µÈ£¬Ö»ÓÐÈ«ÃæÌáÉýÄÚ´æµÄ¹ÜÀíЧÂÊ £¬²ÅÄÜÌá¸ßÕû¸öÓ¦ÓóÌÐòµÄÐÔÄÜ¡£±¾ÆªÎÄÕÂÊ×Ïȼòµ¥½éÉÜGCµÄ¹¤×÷ÔÀíÖ®ºó£¬È»ºóÔÙ¶ÔGCµÄ¼¸¸ö¹Ø¼üÎÊÌâ½øÐÐÉîÈë̽ÌÖ£¬×îºóÌá³öһЩJava³ÌÐòÉ ......
ÎÊÌ⣺ÔÚ´æ´¢¹ý³ÌÖУ¬ÓÐʱ»áÓöµ½±È½Ï±ä̬µÄ¶«Î÷£¬ÈçÒ»¸ö´æ´¢¹ý³ÌÖÐÓÐoutput·µ»ØÖµ£¬ÓÐreturn·µ»ØÖµ£¬»¹ÓвéѯµÄ·µ»ØÖµTABLE£¬Óöµ½ÕâÑùµÄ´æ´¢¹ý³ÌÕæÊÇÓôÃÆ£¬Ò»´ÎÐÔ°ÑËùÓеķµ»ØÖµÈ¡³öÀ´»¹ÕæµÄÓеãÂé·³¡£
1¡¢ Ê×ÏÈÀ´¿´Õâ¸ö´æ´¢¹ý³Ì°É
CREATE PROCEDURE ParaTest
@paraout varchar(20) ......
¡¡1.Ê×ÏÈÊǹ¤¾ß±ÈÈçEclipseºÜ·½±ãÁË¡£
¡¡¡¡2.ÓÃwinrarÖ®ÀàµÄ¹¤¾ß£¬°Ñweb-infoĿ¼£¬¼°¸úËüͬ¼¶µÄËùÓÐĿ¼¼°Îļþ£¬´ò°ü³É zipÎļþ¾ÍÐÐÁË£¬È»ºó°ÑÀ©Õ¹Ãû¸Ä³Éwar!
¡¡¡¡3 JarÃüÁ
¡¡¡¡¼Ù¶¨ÓÐÒ»¸öWebÓ¦ÓãºC:\myHome
¡¡¡¡ myHome/WEB-INF/……
¡¡¡¡myHome/files/……
¡¡¡¡myHome/image/… ......