????澶╂???ㄨ?????琛ㄨ?涓?绡???绔???绠???浠?缁?java web涓?灞??舵??????缃??規?锛?????杩??ユ???缃???涓?涓?绠???娴?璇??規?锛?锛??鎬俊璁稿???杩?璇ユ??绔?????瀛?凡缁???寤鴻搗 tomcat+ms sqlserver??jsp缂?杈?杩?琛???澧???涓??㈡??绠???浠?缁?涓?涓??轟?杩?涓??舵??涓???jsp绋?搴?瀹?渚???锛?瀹??ㄥ??浠ュ?浣?璇劇?璁捐?＄??浣?涓?锛??鎬俊?典俊涓?涓????朵負浜?璇劇?璁捐?″ご?肩????瀛??寰????磋叮锛?
????
???? 浜???缂?绋?宸ュ?蜂???缃?
????
????1. 宸ュ??
????
??????涓哄??瀛??????蟲??濂界?ㄧ?椤靛伐?峰?璇ユ??Dreamwaver锛?Frontpage涔???浠ワ?锛??ㄦ??瀹?渚?涓昏??ㄤ?璁捐?¤〃?煎???版??娣誨??琛ㄥ????
????
?????ユ病??瀹?瑁?DW??FP????瀛??????涓??寵?锛?涔?????璋?锛???涓?????缂?杈?宸ュ?鳳?璁頒???锛?灏卞??浠ワ?涓??㈢??瀹?渚?浼?璐村?轟唬??锛?浣?????copy+灏???淇??瑰氨??瀹???浣?涓???
????
????2.??缃???椤?
????
?????朵?绡???绔?宸茬?浠?缁?浜???缃?????棰?锛??闆?ㄥ??璁句?宸茬????ф??涓?绡???绔?浠?缁???缃?????浜?锛?骞朵?浣???宸ヤ??鴻?懼??:/wool锛?????璺?寰?锛?涓?绡???绔?涓?wool. xml??浠朵腑path锛?""璇??ヤ腑????瀹癸?涓?wool锛??版??搴???涓?est锛?杩??ユ???涓?jdbc/sqlserver??
????
???? 涓????版??搴?璁捐??
????
??????寮?锛?寮?濮?????锛???sqlserver蹇??鋒?瑰?缁?锛???浼?涓?绠＄??????ㄤ?涓?绠＄???ㄤ腑?懼?拌??ユ?杩??ョ??搴?锛??ㄥ?涓??闆緩涓?涓?琛??琛ㄥ??涓?tudent??student琛ㄤ腑??濡?涓?瀛?娈碉?
????
????id锛?涓婚??锛??? int???? ???ㄦ??绀鴻???ㄥ?1
????name???????? ntext绫誨??
????sex????????????ntext绫誨??
????mark??????????ntext绫誨??
????number??????ntext绫誨??
????
????璐村?撅?
???? ??
????娉????绡???绔????逛??ㄨ?叉?版??搴?璁捐?★??跺???版??搴?璁捐?＄????涔?涓??ㄨ?锛????風??璇達?锛???浠ラ?や?涓婚??澶??朵?瀛?娈甸?界?ㄤ?ntext绫誨??锛?杩?涓?绫誨??涓??ㄨ??????瀹瑰お澶??朵??歸?㈤??棰?锛?
????
???? ????寮?濮?缂?绋?锛?????锛?
????
????1.??:/wool??褰?涓?????寤虹??浠ヤ???浠訛?
????
????list.jsp
????del.jsp
????add.htm
????getadd.jsp
????edit.jsp
????getedit.jsp
????濡??撅?
???? ??
????涓??㈢????璐村?鴻?浜???浠剁??婧?????
????
????2.list.jsp
????
???????芥??杩幫????烘?版??搴??????版??锛?涓虹????璧瘋?锛?????椤靛???斤?
????浠?缁?瑙?瀵?涓???唬?????頒??㈠??璐ㄥ氨????涓?涓?绡???绔?涓??ㄤ?娴?璇???jsp??浠躲??
????????璐村?撅?
???????版???訛?
???? ??
???????版???訛?
???? ??
????浠ｇ??锛?
????
????<%@ page contentType="text/html; charset=gb2312" %>
????<%@ page import="javax.naming.Context" %>
????<%@ page import="javax.sql.DataSource"%>
????<%@ page import="javax.naming.InitialContext"%>
????<%@ page import="java.sql.*"%>
????
????<%
????DataSource ds = null;
????try{
????Context initCtx = new InitialContext();
????ds = (DataSource) initCtx.lookup("java:comp/env/ jdbc/sqlserver");
????
????if(ds!=null)
????{
????Connection conn = ds.getConnection();
????Statement stmt=conn.createStatement();
????ResultSet rst=stmt.executeQuery("select * from student");
????%>
????
????<table width="100%"?? cellspacing="0" cellpadding="0">
????<tr bgcolor="#CCCCCC">
????<th height="29">??浣?</th>
????<th>瀛???lt;/th>
????<th>??瀛?</th>
????<th>?у??</th>
????<th>????lt;/th>
????</tr>
????<%
????while(rst.next())
????{%>
????<%int aid = rst.getInt("id");%>
????<tr bgcolor="#FFFFCC">
????<td><div align="center"><a href="edit.jsp?id=<%=aid%>" target="_blank" rel="external nofollow" >缂?杈?</a> <a href="del.jsp?id=<%=aid%>" target="_blank" rel="external nofollow" >????lt;/a></div></td>
????<td><div align="center"><strong><font color="blue"><%=rst.getString("number")%></font></strong></div></td>
????<td><div align="center"><strong><font color="blue"><%=rst.getString("name")%></font></strong></div></td>
????<td><div align="center"><strong><%=rst.getString("sex")%></strong></div></td>
????<td><div align="center"><strong><%=rst.getString("mark")%></strong></div></td>
????</tr>
????<%
????}
????%>
????</table>
????
????<%
????rst.close();
????stmt.close();
????conn.close();
????}
????else
????out.println("杩??ュけ璐?");
????
????}
????catch(Exception ne)
????{
????out.println(ne);
????}
????%>
????
????<p align="center"> <a href="add.htm" target="_blank" rel="external nofollow" >娣誨???版??</a></p>
????
????3.add.htm
????
???????芥??杩幫?濉????闆??瀹圭??琛ㄥ??
????
????杩?涓???浠跺????绾?html??浠訛?浠ヤ???瀹瑰??浠ョ??W绛?缂?杈??ㄥ?朵?锛?濡?????瑙???璐村?虹??涓?瑗垮お涓???璇?锛?
????
????璐村?撅?
??????锛?
???? ??
??????锛?
???? ??
????浠ｇ??锛?
????
????<form name="form1" method="post" action="getadd.jsp">
????<table width="100%"?? cellspacing="0" cellpadding="0">
????<tr>
????<th width="38%" bgcolor="#FFCCFF" scope="row">瀛???lt;/th>
????<td width="62%"><input name="number" type="text" id="number"></td>
????</tr>
????<tr>
????<th bgcolor="#FFCCFF" scope="row">濮???</th>
????<td><input name="name" type="text" id="name"></td>
????</tr>
????<tr>
????<th bgcolor="#FFCCFF" scope="row">????lt;/th>
????<td><input name="mark" type="text" id="mark"></td>
????</tr>
????<tr>
????<th bgcolor="#FFCCFF" scope="row">?у??</th>
????<td><select name="sex" id="sex">
????<option value="boy">??lt;/option>
????<option value="girl">濂?lt;/option>
????</select></td>
????</tr>
????<tr bgcolor="#CCFFFF">
????<th colspan="2" scope="row"><input type="submit" name="Submit" value="??浜?> <input type="reset" name="Submit2" value="??缃?"></th>
????</tr>
????</table>
????</form>
????<p align="center"><a href="list.jsp" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >???闆??琛?lt;/a></p>
????
????4.getadd.jsp
????
???????芥??杩幫??峰??add.htm椤甸??腑浼???杩??ョ???版??锛?骞跺??峰?????版??娣誨??杩??版??搴?
????
????姝ら〉?㈡?????拌?琛?椤甸????版????浣????????劇ず濡?涓?锛?
???? ??
????浠ｇ??锛?
????
????<%@ page contentType="text/html; charset=gb2312" %>
????<%@ page import="javax.naming.Context" %>
????<%@ page import="javax.sql.DataSource"%>
????<%@ page import="javax.naming.InitialContext"%>
????<%@ page import="java.sql.*"%>
????
????<%
????String name=request.getParameter("name");
????String sex=request.getParameter("sex");
????String number=request.getParameter("number");
????String mark=request.getParameter("mark");
????
????DataSource ds = null;
????try{
????Context initCtx = new InitialContext();
????ds = (DataSource) initCtx.lookup("java:comp/env/ jdbc/sqlserver");
????
????if(ds!=null)
????{
????Connection conn = ds.getConnection();
????Statement stmt=conn.createStatement();
????stmt.executeUpdate("insert into student (name,sex,number,mark) values ('"+name+"','"+sex+"','"+number+"','"+mark+"')");
????//sql?????ヨ???ワ?insert into 琛ㄥ?? (瀛?娈?锛?瀛?娈?锛????? values (??锛???锛?????
????
????conn.close();
????%>
????<p align="center"><a href="list.jsp" target="_blank" rel="external nofollow" target="_blank" rel="external nofollow" >娣誨??????锛??瑰?昏????版????琛ㄣ??</a></p>
????<%
????}
????else
????out.println("杩??ュけ璐?");
????
????}
????catch(Exception ne)
????{
????out.println(ne);
????}
????%>
?