/*
* open.java
*
* Created on 2007年12月23日, 上午12:04
*/
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import javax.tools.*;
/**
*
* @author Administrator
* @version
*/
public class open extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void conn(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("GB2312");
PrintWriter out = response.getWriter();
String name1=request.getParameter("学号");
String password1=request.getParameter("密码");
HttpSession session=request.getSession();
session.setAttribute("密码", password1);
out.print("fggf"+name1+"fg");
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); ;
String url="jdbc:microsoft:sqlserver://10.101.12.174:1433;DatabaseName=demo";
Connection conn= DriverManager.getConnection(url,"sa","123");
Statement st= conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs= st.executeQuery("select * from 学生信息表 where 学号='"+name1+"'");
while(rs.next()){
response.sendRedirect("http://10.101.12.174:8080/WebApplication1/main.jsp");
rs.close();
st.close();
conn.close();
}}catch(Exception e){e.printStackTrace();}
/* TODO output your page here
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet open</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet open at " + request.getContextPath () + "</h1>");
out.println("</body>");
out.println("</html>");
*/
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
conn(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
conn(request, response);
}
/**
* Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
courseselect.rar_java jsp 选课_java选课系统_选课系统_选课系统jsp
版权申诉
168 浏览量
2022-09-20
18:44:25
上传
评论
收藏 12.98MB RAR 举报
courseselect.rar （60个子文件） 
WebApplication1 test 
build.xml 3KB dist WebApplication1.war 5.32MB src conf MANIFEST.MF 23B java open.java 3KB nbproject build-impl.xml 38KB private profiler private.xml 211B private.properties 2KB ant-deploy.xml 5KB project.xml 706B genfiles.properties 455B project.properties 2KB web 
a.jpg 3KB content.jsp 501B
sqljdbc.jar 570KB deal.jsp 113B .LCKlogo.jsp~ 103B WEB-INF a.jpg 3KB web.xml 1KB
cool.avi 35KB sun-web.xml 516B
CALENDAR.GIF 3KB sound.wav 16KB 青花.wav 2.31MB
CALENDAR.bmp 10KB time.jsp 391B main.jsp 1KB check.jsp 835B dbo.jsp 480B index.jsp 904B cool.avi 35KB aa.jsp 944B .LCK用户界面.jsp~ 107B header.gif 23KB 青花.wav 2.31MB 选课中心.jsp 297B setup connectionPool.sun-resource 794B build web a.jpg 3KB content.jsp 501B sqljdbc.jar 570KB deal.jsp 113B META-INF MANIFEST.MF 23B WEB-INF a.jpg 3KB web.xml 1KB classes open.class 3KB cool.avi 35KB sun-web.xml 516B CALENDAR.GIF 3KB sound.wav 16KB 青花.wav 2.31MB CALENDAR.bmp 10KB time.jsp 391B main.jsp 1KB check.jsp 835B dbo.jsp 480B index.jsp 904B cool.avi 35KB aa.jsp 944B header.gif 23KB 青花.wav 2.31MB 选课中心.jsp 297B
评论0