jspÑéÖ¤µÇ½
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPasswd="123456";
String dbName="hoot";
String tableName="userinfo";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password"
+ "="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String Username=request.getParameter("Username");
String Password=request.getParameter("Password");
out.println(Username);
out.println(Password);
String sql="SELECT * from userinfo where " +
"username= 'Username' and password = 'Password'";
&nbs
Ïà¹ØÎÊ´ð£º
°üÀ¨²ÎÊý
String path = request.getContextPath();
String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"; ......
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆ̨ÎÒ¿´µ½µÄÊä³öÃû³ÆЧ¹ûÊÇ£ºtest_µ ......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒ°ÑjavabeanµÄÔ´´úÂëSetGetPropertytest.Java·ÅÔÚC:\tomcat\webapps\mywork\WEB-
INF\classes\comÖÐ ÊDz»ÊÇÎҵİü´´½¨´íÁË»¹ÊÇ£¿ÒªÊǽ¨´íÁË,ËÄܸæËßÎÒÔõô½¨Âð? лл´ó¼Ò
Ç°À´°ï棬ͬʱף´ó¼ÒÖÐÇï¿ ......
ÎÒÓÃSqlServer½¨Á¢ÁËÒ»¸ö±í¡£ÀïÃæÓУ¬Îļþ±àºÅ: ÎļþÃû³Æ: ³§¼ÒÃû³Æ: ¹éµµ²¿ÃÅ: µÈµÈ£»
ÏÖÔÚÎÒÏë´ÓÕâ¸ö±íÖвéÎļþ±àºÅ£¬´úÂëÔõôд°¡£¬
ÀýÈ磬±íÃ÷dengjibiao Îļþ±à ......