資源簡介
Android登陸客戶端與服務器端的源代碼

代碼片段和文件信息
package?wcl.ceshi.servlet;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
public?class?DBHandler?{
String?url?=?“jdbc:mysql://localhost:3306/test“;
String?user=“root“;
String?psd=“root“;
private?Connection?conn;
private?PreparedStatement?ps;
private?ResultSet?rs;
public?Connection?getConn(){
try{
Class.forName(“com.mysql.jdbc.Driver“);
conn?=?DriverManager.getConnection(url?user?psd);
}catch(Exception?ex){
ex.printStackTrace();
}
return?conn;
}
public?String?query(String?sqlString[]?args){
String?result=““;
try{
conn=getConn();
System.out.println(sql);
ps=conn.prepareStatement(sql);
for(int?i=0;i ps.setString(i+1?args[i]);
}
rs=ps.executeQuery();
ResultSetmetaData?rsmd?=?rs.getmetaData();
int?count=rsmd.getColumnCount();
System.out.println(count);
while?(rs.next())?{
for(int?i=1;i<=count;i++){
result+=rs.getString(i)+“*“;
}
}
System.out.println(result);
}catch?(Exception?ex)?{
ex.printStackTrace();
}
return?result;
}
public?boolean?insert(String?sqlString[]?args){
boolean?flag=false;
try{
conn=getConn();
System.out.println(sql);
ps=conn.prepareStatement(sql);
for(int?i=0;i ps.setString(i+1?args[i]);
}
int?i=ps.executeUpdate();
System.out.println(i);
if(i==1){
flag=true;
}
}catch?(Exception?ex)?{
ex.printStackTrace();
}
return?flag;
}
public?boolean?checkUser(String?sqlString[]?args){
boolean?flag=false;
try{
conn=getConn();
ps=conn.prepareStatement(sql);
for(int?i=0;i ps.setString(i+1?args[i]);
}
rs=ps.executeQuery();
if(rs.next()){
flag=true;
}
}catch?(Exception?ex)?{
ex.printStackTrace();
}
return?flag;
}
public?static?void?main(String[]?args){//????????????????????
DBHandler?dbh=new?DBHandler();
String?result=dbh.query(
“select?*?from?book?where?book_name?like???or?book_author?like??“
new?String[]?{?“%????%“?“%????%“?});
System.out.println(result);
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-03-28?17:52??登陸注冊驗證\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\
?????文件?????????529??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.classpath
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.myeclipse\
?????文件?????????303??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.myme
?????文件????????1753??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.project
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\
?????文件?????????500??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\.jsdtscope
?????文件?????????364??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\org.eclipse.jdt.core.prefs
?????文件?????????468??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\org.eclipse.wst.common.component
?????文件?????????252??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-03-28?17:48??登陸注冊驗證\InfoSearch\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\ceshi\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\ceshi\servlet\
?????文件????????2333??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\ceshi\servlet\DBHandler.java
?????文件????????1092??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\ceshi\servlet\LoginServlet.java
?????文件????????1033??2014-03-28?17:48??登陸注冊驗證\InfoSearch\src\wcl\ceshi\servlet\RegisterServlet.java
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\
?????文件?????????829??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\index.jsp
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\me
?????文件??????????36??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\me
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\wcl\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\wcl\ceshi\
?????目錄???????????0??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\wcl\ceshi\servlet\
?????文件????????3443??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\wcl\ceshi\servlet\DBHandler.class
?????文件????????1635??2014-03-28?17:48??登陸注冊驗證\InfoSearch\WebRoot\WEB-INF\classes\wcl\ceshi\servlet\LoginServlet.class
............此處省略106個文件信息
評論
共有 條評論