update_vote.jsp

来自「《J2EE专业项目实例开发》源代码」· JSP 代码 · 共 37 行

	<%@ page import="java.util.*" %>
	<%@ page import="java.sql.*" %>
	<%@ page import="java.text.*" %>
	<%@ page import="java.sql.Date" %>

	<%@ page language = "java" %> 



<%
	
	try{
	
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection connect;
	connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
	Statement state;
	state = connect.createStatement();
	String song1=request.getParameter("Song1");
	String song2=request.getParameter("Song2");
	String song3=request.getParameter("Song3");
	state = connect.createStatement();
	
	String strQuery1 = "update Vote_info set Number_votes=Number_votes+1 where Item_code in (select Item_code from Item_Master where Title='"+ song1+ "' or Title='"+ song1+ "' or Title='" + song3+ "')";
	
	 state.executeUpdate(strQuery1);
	connect.close();
	%>

<%		
	}
	catch(Exception e)
	{out.println("Exception ocurred"+e);}%>

	<jsp:include page="home_page.htm" flush="true"/>