¹ØÓÚMYSqlÊý¾Ý²éѯÎÊÌâ - Java / Web ¿ª·¢
¾ÍÊÇÏëͨ¹ýJavaBeanÁ¬½ÓMySQL
Java code:
package ch05;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBConnection {
public static Connection getConnection(){
Connection conn = null;
String SERVANDDB = "jdbc:mysql://localhost:3306/xietanghui?user=root&password=admin&useUnicode=true&characterEncoding=8859_1";
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(SERVANDDB);
}catch(Exception e){
e.printStackTrace();
}
return conn;
}
}
Java code:
package ch05;
public class AdminBean {
private String userName; //Óû§Ãû
private String userPassword; //Óû§ÃÜÂë
public String getUserName(){
return this.userName;
}
public void setUserName(String userName){
this.userName = userName;
}
public String getPassword(){
return this.userPassword;
}
public void setUserPassword(String userPassword){
this.userPassword = userPassword;
}
}
HTML code
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.Cod
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
´úÂëÈçÏ £¬ÎÒÏëͨ¹ý´úÀí·ÃÎÊÒ»Ð©ÍøÖ·£¬µ«ÊDz»ÖªµÀÈçºÎ²âÊÔ´úÀí³É¹¦£¬ÎÒÏëͨ¹ý·ÃÎÊ¡°http://www.blogger.com/¡±À´¿´¿´ÊÇ·ñ´úÀí³É¹¦£¬µ«ÊÇÒ²²»ÄÜ·ÃÎÊ£¬³öÏÖÒì³£¡°Unexpected end of file from server¡±£¬µ«ÊÇÈç¹û²»Õâ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
¸÷λÀÏ´óºÃ¡£¡£¡£Ð¡µÜÓÐÒ»¸öÂÒÂëÎÊÌâ¼±Ðè°ïæ½â¾ö
ÎÒÔÚ±¾Ò³ÖÐÓÃrequest.getParameter("name")È¡±äÁ¿¡£¡£±äÁ¿µÄ¸³ÖµÎªºº×Ö¡£ÎÒÔÚÒ³ÃæµÄ¿ªÍ·¼ÓÁË<%@ page language = "java" contentType=&quo ......