?? online.java
字號:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class StudentServlet3 extends HttpServlet
{
String message,Seat_no,Name,ans1,ans2,ans3,ans4,ans5;
int Total=0;
Connection connect;
Statement stmt=null;
ResultSet rs=null;
Public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException
{
try
{
String url="jdbc:odbc:studentDB!";
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
connect=DriverManager.getConnection(url," "," ");
message="Connection Successful";
}
catch(Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connect=DriverManager.getConnection(url," "," ");
message="Connection Successful";
}
catch(ClassNotfoundException cnfex)
{
cnfex.printStackTrace();
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
}
catch(Exception excp)
{
excp.printStackTrace();
}
Seat_no=request.getParameter("Seat_no");
Name=request.getParameter("Name");
ans1=request.getParameter("group1");
ans2=request.getParameter("group2");
ans3=request.getParameter("group3");
ans4=request.getParameter("group4");
ans5=request.getParameter("group5");
if(ans1.equals("True"))
Total+=2;
if(ans2.equals("False"))
Total+=2;
if(ans3.equals("True"))
Total+=2;
if(ans4.equals("False"))
Total+=2;
if(ans5.equals("False"))
Total+=2;
try
{
Statement stmt=connect.CreateStatement();
String query="INSERT INTO STUDENT TABLE("+" Seat no,Name,Marks"+");
VALUES("+Seat_no+","+Name+","+Total+");
int result=Stmt.executeUpdate(query);
stmt.close();
}
catch(SQLException ex){ }
response.setContentType.getWriter();
out.println("<html>");
out.println("<head>");
out.println("</head>");
out.println("<body bgcolor=pink>");
out.println("<h1>"+message+"</h1>/n);
out.println("<h3>Database Updated");
out.println("<b>"+The Students Database is as follows");
out.println("<table border=5>");
try
{
Statement stmt=connect.createStatemtn();
String query="SELECT*FROM STUDENTTABLE";
rs=stmt.executeQuery(query);
out.println("<th>"+Seat_no+"</th">;
out.println("<th>"+Name+"</th>;
out.println("<th>"+Marks+"</th>");
while(rs.next())
{
out.println("<tr>");
out.println("<td>" +rs.getInt(1)+ "</td>");
out.println("<td>" +rs.getString(2)+ "</td>");
out.println("<td>" +rs.getString(3)+ "</td>");
out.println("</tr>");
}
out.println("</table>");
}
catch(SQLException ex){ }
finally
{
try
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(connect!=null)
connect.close()
}
catch(SQLException e) { }
}
out.println("<cntr>");
out.println("<h1> tanks!</h1>/n");
out.println("img src=D:/tanks_giving.gif>");
out.println("</center>");
out.println("</body></html>");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -