xbkc.jsp

jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考

<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%
       Connection conn=null;
       Statement stmt=null;
       ResultSet rs=null; 
       String kc_id = request.getParameter("kc_id");
       String user_id=(String)session.getAttribute("user_id");
       String user_name=(String)session.getAttribute("user_name");
       String kc_mc="";
       String kc_rs="";
try
{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
      out.println(ce.getMessage());
}
/*requset.setCharacterEncoding("GB2312");*/
try
{
        conn=DriverManager.getConnection("jdbc:odbc:movie");
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
        rs=stmt.executeQuery("SELECT * FROM  kecheng  where kc_id='"+kc_id+"' ");
       if(rs.next())
       {
        kc_mc=rs.getString("kc_mc");
        kc_rs=rs.getString("kc_rs");
        int a=Integer.parseInt(kc_rs);
        if(a==0){
              response.sendRedirect("giakechengrenshuyiman.jsp");
             }
          else{
        String sqlstr="insert into xuanke(kc_id,user_id,user_name,kc_mc,kc_xl)  values('"+kc_id+"','"+user_id+"','"+user_name+"','"+kc_mc+"','"+user_id+""+kc_id+"')"; 
        stmt.executeUpdate(sqlstr);
        stmt.executeUpdate("UPDATE  kecheng SET kc_rs=kc_rs-1  where kc_id='"+kc_id+"'");
        response.sendRedirect("enter1.jsp");       
}
}
} 
catch(SQLException e)
{
out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>