聽涓€銆佸噯澶囩幆澧?
聽聽 Windows XP+tomcat6.0+Microsoft SQL Server 2000涓汉鐗?Dreamweaver
鏁版嵁搴撻┍鍔ㄧ▼搴廠QL Server 2000 Driver for JDBC Service Pack 3.exe聽
聽聽 瀹夎瀹屾瘯鍚?鍦–:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib
聽聽 鐩綍涓嬫湁涓変釜鍖卪sbase.jar mssqlserver.jar msutil.jar
鎶婅繖涓変釜鍖呮斁鍦–:/Tomcat 6.0/lib鐨勭洰褰曚笅
涓夈€佸缓绔嬫暟鎹簱
鎵撳紑浼佷笟绠＄悊鍣紝寤虹珛鏁版嵁搴撱€傚簱鍚嶈嚜宸辨兂涓€涓紝鎴戝湪杩欓噷璁句负鈥渟tudent鈥濓紝寤虹珛琛紝琛ㄥ悕鈥渟ut鈥濄€傚仛濂借繖姝ュ氨鍙互浜嗭紝鍒涘缓瀛楁涔嬬被灏变笉鐢ㄥ幓绠″畠浜嗐€?浠ヤ笂姝ラ閮藉仛濂藉悗锛屽氨鍙互鍋氬啓涓€涓▼搴忔潵娴嬭瘯鏄惁杩炴帴鎴愬姛浜?鍥涖€佸疄渚嬭鏄?<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
String user="sa";
String password="sa"; //鎴戠殑鐧婚檰瀵嗙爜涓簊a
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from sut";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
鎮ㄧ殑绗竴涓瓧娈靛唴瀹逛负锛?lt;%=rs.getString(1)%>
鎮ㄧ殑绗簩涓瓧娈靛唴瀹逛负锛?lt;%=rs.getString(2)%>
<%
}
%>
<%out.print("鏁版嵁搴撴搷浣滄垚鍔燂紝鎭枩浣?);%>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
聽
鏈€缁堢粨鏋滃氨鏄湪鎵撳紑鐨勭綉椤甸噷鏄剧ず锛氭暟鎹簱鎿嶄綔鎴愬姛锛屾伃鍠滀綘
聽
聽
聽
鎴戠殑鑷垜鎰熻鏄幇鍦↗SP涓笌鏁版嵁搴撶殑閾炬帴绫讳技浜嶫ava涓殑閾炬帴锛岃嚦浜庡埌搴曟槸鎬庝箞鍥炰簨锛岃繕鏄渶瑕佷粩缁嗙爺绌垛€︹€︽暚璇风瓑寰?
![【MySQL数据库】数据库索引事务1.索引2.事务[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)