JSP+SQLµÇ¼ע²áÒ³ÃæÒ»Ð©ÎÊÌâ
ÎÒµÄlogin.jsp¾ÍÊǼòµ¥µÄÏÖʵµÇÂ¼Ò³Ãæ£¬ÎÒµÄLoginGo.jspµÄ²¿·Ö´úÂëÈçÏ£º
<%@ page contentType="text/html; Charset=GB2312" language="java" import="java.sql.*,java.util.*,myPk.*" %>
<% Connection con;
Statement sql;
ResultSet rs;
String ID,Pwd,Figure;//µÇ¼Õ˺ţ¬ÃÜÂ룬µÇ¼Éí·Ý¼¶±ð
ID=request.getParameter("loginid");//loginidÊÇlogin.jspÖÐÕ˺ŵÄÎı¾¿òÃû×Ö
Pwd=request.getParameter("password");//passwordÊÇlogin.jspÖÐÃÜÂëµÄÃÜÂë¿òÃû×Ö
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
out.print(e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:TestScore","","");
sql=con.createStatement();
rs=sql.executeQuery("select * from users where ID='"+ID+"' and Pwd='"+Pwd+"'");
if(rs.next()){
Figure=rs.getString("Figure");
session.setAttribute("Figure",Figure);
if(Figure.equals("ѧÉú")){
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ËÑË÷ÁËһϣºhttp://so.csdn.net/bbsSearchResult.aspx?q=jsp+%e4%bc%a0%e9%80%92&p=1£¬Ã»Óз¢ÏÖÄÜÓõġ£ÒòΪÎÒÊdzõѧjsp£¬Òò´ËÓÐЩҲÐíÄÜÓã¬Ö»ÊÇÎÒ¿´²»Ã÷°×£¿
Ò»¡¢ÎÒµÄÇéÐΣº
a.html ͨ¹ý<form action=&q ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
jspÒ³ÃæÖеÄJava±äÁ¿³ö´í£¬ÇëÎÊÒ»ÏÂJavaµÄ¸ßÊÖÃÇ£¬ÈçºÎ½â¾ö£¿ÐèÒªÌí¼ÓÄĸöjar°ü
<logic:notEqual name="parts" property="checkStatus2" value="1">
<label for=&q ......