81,094
社区成员
发帖
与我相关
我的任务
分享
<form method = post action =../ReleaseDepend>
<table>
<tr>
<td></td>
<td><input type="text" size = 60 name="Warnning" disabled></input></td>
<td></td>
</tr>
<tr>
<td>顧客名</td>
<td><input type="text" size =40></input></td>
<td><input type=button name="customerName" value="选择" onclick = "alert('you clicked the button');"></input></td>
</tr>
<tr>
<td>产品</td>
<td><select name=productionName size=1>
<option value="香蕉" selected>香蕉</option>
<option value="苹果">苹果</option>
</select></td>
<td></td>
</tr>
<tr>
<td>版本</td>
<td><select name=version size=1>
<option value="赵本山" selected>赵本山</option>
<option value="宋丹丹">"宋丹丹"</option>
</select></td>
<td></td>
</tr>
<tr>
<td>使用次数</td>
<td><input type="text" name = useTimes size =40></input></td>
<td>(个数)</td>
</tr>
<tr>
<td>试用时间</td>
<td><input type="text" name = tryDay size =40></input></td>
<td>(日)</td>
</tr>
<tr>
<td>时间</td>
<td><input type="text" id="ReleaseTime" size =40 disabled >
<script language="JavaScript">
var now = new Date();
ReleaseTime.value = now.getYear() + "-"+(now.getMonth() + 1) + "-"
+ now.getDate();
</script>
</td>
<td></td>
</tr>
<tr>
<td>发行人</td>
<td><input type="text" name=Releaser size =40></input></td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td><textarea name =otherThings cols =40 rows=3></textarea></td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type=submit value="发行"></input> <input
type=reset value="清空"></input></td>
<td></td>
</tr>
</table>
</form>
import java.io.IOException;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.Service.ConnectionFactory;
public class ReleaseDepend extends HttpServlet {
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String customer = request.getParameter("customer");
String productionName = request.getParameter("productionName");
String version = request.getParameter("version");
String useTimes = request.getParameter("useTimes");
String tryDay = request.getParameter("tryDay");
String releaseTime = request.getParameter("releaseTime");
String releaser = request.getParameter("releaser");
String otherThings = request.getParameter("otherThings");
/*
* ReleaseDependModel newReleaseDepend = new ReleaseDependModel();
* newReleaseDepend
* .Doget(customer,productionName,version,useTimes,tryDay
* ,releaseTime,releaser,otherThings); ReleaseDependDao newconnection
* =new ReleaseDependDao() ; newconnection.InsertData();
*/
String sql = "insert into releasedepend(customerName,productionName,version,useTimes,tryDay,releaseDependDay,releaseDepender,otherThings)values('"
+ customer
+ "','"
+ productionName
+ "','"
+ version
+ "','"
+ useTimes
+ "','"
+ tryDay
+ "','"
+ releaseTime
+ "','"
+ releaser + "','" + otherThings + "')";
Connection conn=null;
Statement stmt=null;
ConnectionFactory newconn = new ConnectionFactory();
try{
conn = newconn.getConnection();
}
catch(Exception e){
e.printStackTrace();
}
try{
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException e){
e.printStackTrace();
}
/*request.setAttribute("customer", customer);
request.setAttribute("productioName", productionName);
request.setAttribute("version", version);
request.setAttribute("useTimes", useTimes);
request.setAttribute("tryDay", tryDay);
request.getRequestDispatcher("/jsp/ReleaseComplete.jsp").forward(
request, response);*/
}
}