A. jsp怎麼寫增刪改查代碼
下面的代碼即可實現（對資料庫的操作）：
<%@page
language="java"
contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"
%>
<%@pageimport="java.sql.*"%>
<center>
<H1><fontcolor="blue"size="12">管理中心</font></H1>
<HR/>
<tablewidth="80%"border="1">
<tr>
<th>ID</th>
<th>書名</th>
<th>作者</th>
<th>價格</th>
<th>刪除</th>
</tr>
<%
//資料庫的名字
StringdbName="zap";
//登錄資料庫的用戶名
Stringusername="sa";
//登錄資料庫的密碼
Stringpassword="123";
//資料庫的IP地址，本機可以用localhost或者127.0.0.1
Stringhost="127.0.0.1";
//資料庫的埠，一般不會修改，默認為1433
intport=1433;
StringconnectionUrl="jdbc:sqlserver://"+host+":"+port+";databaseName="+dbName+";user="+username
+";password="+password;
//
//聲明需要使用的資源
//資料庫連接，記得用完了一定要關閉
Connectioncon=null;
//Statement記得用完了一定要關閉
Statementstmt=null;
//結果集，記得用完了一定要關閉
ResultSetrs=null;
try{
//注冊驅動
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//獲得一個資料庫連接
con=DriverManager.getConnection(connectionUrl);
StringSQL="SELECT*fromnote";
//創建查詢
stmt=con.createStatement();
//執行查詢，拿到結果集
rs=stmt.executeQuery(SQL);
while(rs.next()){
%>
<tr>
<td>
<%=rs.getInt(1)%>
</td>
<td>
<ahref="prepareupdate?ID=<%=rs.getInt("ID")%>"target="_blank"><%=rs.getString(2)%></a>
</td>
<td>
<%=rs.getString(3)%>
</td>
<td>
<%=rs.getString(4)%>
</td>
<td>
<ahref="delete?ID=<%=rs.getInt("ID")%>"target="_blank">刪除</a>
</td>
</tr>
<%
}
}catch(Exceptione){
//捕獲並顯示異常
e.printStackTrace();
}finally{
//關閉我們使用過的資源
if(rs!=null)
try{
rs.close();
}catch(Exceptione){}
if(stmt!=null)
try{
stmt.close();
}catch(Exceptione){}
if(con!=null)
try{
con.close();
}catch(Exceptione){}
}
%>
</table>
<ahref="insert.jsp">添加新紀錄</a>
</center>
B. jsp中查詢mysql資料庫中的表，請問如果按時間查詢代碼該怎麼寫
jsp代碼編寫，其實就是把你上面的布局還原到頁面上，這個只要會html就不難。
連接池就是為了訪問資料庫，一般設置兩個xxx.xml文件就可，當然這也需要驅動，在後台要有一個類似DBHelp.java用來載入就可。
在jsp中不會使用連接池的，jsp中發送一個請求道後台，通過DBHelp來獲取資料庫中的數據。
大體流程就是這樣。
C. jsp查詢資料庫代碼
這種方法並不是很常用,只是頁面的相關操作，代碼太多,所以中間省略了部分<%
Object userUID=session.getAttribute("USERID");
String uid="";
if(userUID!=null)
{
uid=(String)userUID;
}
else
{ response.sendRedirect("../Public/loseSession.jsp");}
try
{
String today=DateUtils.getInstance().getToday();
String userIP=request.getRemoteAddr();
String sql="";
String getPage=request.getParameter("toPage");
sql=cu.exchange(request.getParameter("sql")); if (sql==null||sql.equals("")){
String getDepId="";
String getPoliticalPosition="";
String getTechnicalPosition="";
String getPoliticalLevel="";
String getTechnicalLevel="";
String getDegreeCode="";
String getGrade="";
String getLongevity="";String getAllowance="";
long depId=0;
long degreeCode=0;
long politicalPosition=0;
long technicalPosition=0;
long politicalLevel=0;
long technicalLevel=0;
long grade=0;
long longevity=0;
long allowance=0;
String[] postID=null;
String post="";
String userID="";
String userName="";
String address="";
getDepId=request.getParameter("depId");
depId=Long.parseLong(getDepId.trim());getDegreeCode=request.getParameter("degreeCode");
if (getDegreeCode!=null) {
degreeCode=Long.parseLong(getDegreeCode.trim());
}
getPoliticalPosition=request.getParameter("politicalPosition");
if (getPoliticalPosition!=null) {
politicalPosition=Long.parseLong(getPoliticalPosition.trim());
}
post=request.getParameter("post");
if(post!=null&&post.trim().equals("1"))
postID=request.getParameterValues("dyourlocation");
getTechnicalPosition=request.getParameter("technicalPosition");if (getTechnicalPosition!=null) {
technicalPosition=Long.parseLong(getTechnicalPosition.trim());
}
getPoliticalLevel=request.getParameter("politicalLevel");if (getPoliticalLevel!=null) {politicalLevel=Long.parseLong(getPoliticalLevel.trim());
}getTechnicalLevel=request.getParameter("technicalLevel");if (getTechnicalLevel!=null) {
technicalLevel=Long.parseLong(getTechnicalLevel.trim());
}getGrade=request.getParameter("grade");if (getGrade!=null) {
grade=Long.parseLong(getGrade.trim());
}getLongevity=request.getParameter("longevity");if (getLongevity!=null) {
longevity=Long.parseLong(getLongevity.trim());
}getAllowance=request.getParameter("allowance");
if (getAllowance!=null) {
allowance=Long.parseLong(getAllowance.trim());
}
userID=ParamUtils.getParameter(request,"userID");//用戶代碼
userName=ParamUtils.getParameter(request,"userName");
//用戶名稱
address=ParamUtils.getParameter(request,"address");
//得到要轉入的頁面sql="select org_user.* from org_user,org_detail where org_user.user_id=org_detail.user_id";
if (depId!=0)
{
sql=sql+" and org_user.department_id="+depId+"";
}if (userID!=null&&userID!=""){
sql=sql+" and org_user.user_id='"+userID+"'";
}
if (userName!=null&&userName!="")
{
sql=sql+" and org_user.name like '%"+userName+"%'";
}if (address!=null&&address!="")
{
sql=sql+" and org_user.address like '%"+address+"%'";
}
if(post!=null&&!post.trim().equals("0"))
{
sql=sql+" and org_detail.post in (";
for(int i=0;i<postID.length;i++)
{
sql=sql+postID[i];
if(i!=(postID.length-1))
sql=sql+",";
}
sql=sql+")";
}
if (degreeCode!=0)
{
sql=sql+" and org_detail.degree="+degreeCode+"";
}
if (politicalPosition!=0)
{
sql=sql+" and org_detail.politicalPosition="+politicalPosition+"";
}
if (technicalPosition!=0)
{
sql=sql+" and org_detail.technicalPosition="+technicalPosition+"";
}
if (technicalPosition!=0)
{
sql=sql+" and org_detail.politicalLevel="+politicalLevel+"";
}
if (grade!=0)
{
sql=sql+" and org_detail.grade="+grade+"";
}
if (longevity!=0)
{
sql=sql+" and org_detail.longevity="+longevity+"";
}
if(getAllowance!=null)
{
if (allowance==0||allowance==1)
{
sql=sql+" and org_detail.allowance="+allowance+"";
}
}
}
User[] userList =null;
userList=ur.complexSearch(sql);
log.addLog(1,1,1,uid,userIP,uid+"於("+today+")查詢員工");int cnt=userList.length;//總記錄數
int pageSize=10;//每頁顯示記錄數
int curPage=1;//當前頁
int cntPage;//總頁數
int m=1; if (cnt>0)
{
if (cnt%pageSize==0)
cntPage=cnt/pageSize;
else
cntPage=cnt/pageSize+1;
}
else
cntPage=0; if (getPage==null)
{
getPage="1";
curPage=1;
}
else
curPage=Integer.parseInt(getPage.trim());
%><form name="thisform" action="userSearchDel.jsp" method="post">
<table bgColor="#FFFFFF" border="1" borderColorDark="#ffffff" borderColorLight="#c0c0c0" cellSpacing="0" width="95%" cellpadding="4">
<tr height="25" align="center" bgcolor="#959595">
<td> </td>
<td><font color="#FFFFFF">姓名</font></td>
<td><font color="#FFFFFF">性別</font></td>
<td> <font color="#FFFFFF">所在部門</font></td>
<td> <font color="#FFFFFF">辦公地址</font></td>
<td><font color="#FFFFFF">聯系電話</font></td>
</tr>
<%
int u=1;
for(int i=0;i<cnt;i++)
{
//顯示記錄的起始位置
int j=(curPage-1)*pageSize;
//顯示記錄的末位置
int k=curPage*pageSize;
//只顯示page_size條數據
if(m>j&&m<=k)
{
String userId=userList[i].getUserID();
String gender=userList[i].getGender();
String name=userList[i].getName();
String tel=userList[i].getTel();
String useAddress=userList[i].getAddress();
long dep_id=userList[i].getDepID();
String dname=dep.getName(userList[i].getDepID());
if(tel==null||tel.equals("null"))
tel="";
if(useAddress==null||useAddress.equals("null"))
useAddress="";
//判斷沒一行該輸出的顏色
if((u%2)==0)
{
out.println("<tr bgcolor=#D7D7D7 onMouseOver=this.style.backgroundColor='#fcd4d7'; onMouseOut=if(selectedItem!=this.id){this.style.backgroundColor='#D7D7D7';}>");
}
else
{
out.println("<tr onMouseOver=this.style.backgroundColor='#fcd4d7'; onMouseOut=if(selectedItem!=this.id){this.style.backgroundColor='#FFFFFF';}>");
}
u++;
%>
<td align=center><input type="checkbox" name="checkbox" id="CHK_+<%=userId%>" value="<%=userId%>"></td>
<td align=center>
<%
long departmentID=ur.getDepID(uid);
if(up.haveRight(uid,"USER_COMPLEXQUERY")==true)
{
%>
<a href="userAnalyze.jsp?userId=<%=userId%>&dep_id=<%=dep_id%>&toPage=<%=curPage%>"><font color="#330099">
<%
}
else if(up.haveRight(uid,"DEPARTMENT_PLATFORM")==true&&dep_id==departmentID)
{
%>
<a href="userAnalyze.jsp?userId=<%=userId%>&dep_id=<%=dep_id%>&toPage=<%=curPage%>"><font color="#330099">
<%
}
%>
<%=name%></font></a></td>
<%
if(gender.trim().equals("0"))
out.println("<td align=center>男</td>");
else
out.println("<td align=center>女</td>");
%>
<td align=center><a href="depintro.jsp?id=<%=dep_id%>&toPage=<%=curPage%>"><font color="#330099"><%=dname%></font></a></td>
<td align=center> <%=useAddress%></td>
<td align=center> <%=tel%></td>
</tr>
<%
}//end if m++;
}//end for
%>
<input type=hidden name="sql" value="<%=sql%>">
<input type=hidden name="page" value="<%=curPage%>">
</table>
</form>
<form name=pageform action="searchAction.jsp" method="post">
<table border="0" width="95%">
<tr>
<td align="center">第<%=curPage%>頁/共<%=cntPage%>頁</td>
<td align="left">
<img name="firstpage" src="../Image/btn_firstpage.gif" style="cursor:hand" onclick="pageClick(1)" <%=curPage>1?" ":"disabled"%>>
<img name="prepage" src="../Image/btn_prepage.gif" style="cursor:hand" onclick="pageClick(<%=curPage-1%>)" <%=curPage>1?" ":"disabled"%>>
<img name="nextpage" src="../Image/btn_nextpage.gif" style="cursor:hand" onclick="pageClick(<%=curPage+1%>)" <%=curPage<cntPage?" ":"disabled"%>>
<img name="lastpage" src="../Image/btn_lastpage.gif" style="cursor:hand" onclick="pageClick(<%=cntPage%>)" <%=curPage<cntPage?" ":"disabled"%>>
</td>
<td align=left width=55%>
到第<input type="text" name="goPage" size="4">頁
<img border="0" src="../Image/icon_search.gif" style="cursor:hand" onclick="aPage()">
</td>
</tr><tr>
<td colspan="3" valign="middle" width="23%" align="right">
<%
if(up.haveRight(uid,"USER_MANAGE")==true)
{
%>
<img border="0" src="../Image/btn_delete.gif" style="cursor:hand" onclick="delUser()">
<%}%>
<img border="0" src="../Image/btn_return.gif" style="cursor:hand" onclick="back()">
</td>
<input type=hidden name="sql" value="<%=sql%>">
<input type=hidden name="toPage">
</td>
</tr>
</table>
</form>
<br>
<br>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
}//end else
}//end try
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</td>
</tr>
</table>