-
大小: 14.77MB文件類型: .rar金幣: 1下載: 0 次發(fā)布日期: 2023-06-19
- 語言: Java
- 標簽:
資源簡介
采用POI技術完成EXCEL和數(shù)據庫的交互，即導入導出完美兼容xls/xlsx兩種工作簿表格。而且包含了，將地址轉換為經緯度的百度接口調用（請自行注冊百度API秘鑰），同時修正了操作不當，接口崩潰的Java空指針錯誤 java.lang.NullPointerException
代碼片段和文件信息
package?Admin;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?javax.servlet.http.HttpServletRequest;
import?org.apache.struts2.ServletActionContext;
import?com.DBcon.DBconn;
import?com.opensymphony.xwork2.ActionSupport;
/**
?*?@author?Administrator
?*
?*/
public?class?CreateAdmin{
private?String?firstname;
private?String?name;
private?String?pwd;
private?String?num;
private?int?type;
????private?String?result;
DBconn?con=new?DBconn（）;
public?String?getResult（）?{
return?result;
}
public?void?setResult（String?result）?{
this.result?=?result;
}
public?CreateAdmin（）{};
public?CreateAdmin（String?firstname?String?name?String?pwd?String?num
int?type）?{
super（）;
this.firstname?=?firstname;
this.name?=?name;
this.pwd?=?pwd;
this.num?=?num;
this.type?=?type;
}
public?String?getFirstname（）?{
return?firstname;
}
public?void?setFirstname（String?firstname）?{
this.firstname?=?firstname;
}
public?String?getName（）?{
return?name;
}
public?void?setName（String?name）?{
this.name?=?name;
}
public?String?getPwd（）?{
return?pwd;
}
public?void?setPwd（String?pwd）?{
this.pwd?=?pwd;
}
public?String?getNum（）?{
return?num;
}
public?void?setNum（String?num）?{
this.num?=?num;
}
public?int?getType（）?{
return?type;
}
public?void?setType（int?type）?{
this.type?=?type;
}
????public?String?modify（）{
???? con.Open（）;
???? String?sql=“update?admin?set?username=‘“+name+“‘password=‘“+pwd+“‘where?username=‘“+（String）ServletActionContext.getRequest（）.getSession（）.getAttribute（“adminName“）+“‘“;
???? try?{
if（con.executeUpdate（sql）!=0）{
result=“密碼更新成功！“;
????System.out.println（result）;
}else{
result=“密碼修改失敗“;
System.out.println（result）;
}
}?catch?（SQLException?e）?{
//?TODO?Auto-generated?catch?block
System.out.println（e.getMessage（））;
}
???? con.Close（）;
???? return?“success“;
????}
public?String?createForm（）?throws?Exception?{
con.Open（）;
System.out.println（name）;
// String?name2=new?String（request.getParameter（“name“）.getBytes（“ISO-8859-1“）“utf-8“）;
// System.out.println（name）;
String?sql1=“select?*?from?admin?where?username=‘“+name+“‘“;
String?sql2=“insert?into?admin?value（‘“+firstname+“‘‘“+name+“‘‘“+pwd+“‘‘“+num+“‘‘“+type+“‘）“;
ResultSet?rs1=con.executeQuery（sql1）;
if（rs1.next（））{
result=“用戶已存在，創(chuàng)建失敗“;
System.out.println（result）;
}else?if（con.executeUpdate（sql2）==1）{
result=“用戶創(chuàng)建成功“;
???System.out.println（result）;
???
}
con.Close（）;
return?“success“;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????928??2016-09-11?14:24??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.classpath
?????文件????????291??2017-03-22?10:10??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.myme
?????文件????????240??2016-07-16?09:05??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.mystrutsdata
?????文件???????1832??2016-07-18?11:45??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.project
?????文件????????500??2016-07-16?09:04??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\.jsdtscope
?????文件????????563??2016-10-09?12:40??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\com.genuitec.eclipse.core.prefs
?????文件???????1009??2016-08-16?13:17??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????99??2016-08-16?12:00??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\com.genuitec.eclipse.j2eedt.core.xm
?????文件????????140??2016-09-06?11:01??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.core.resources.prefs
?????文件????????598??2016-08-11?10:03??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.jdt.core.prefs
?????文件????????456??2016-09-11?14:24??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.wst.common.component
?????文件????????299??2016-08-16?12:00??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2016-07-16?09:04??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2016-07-16?09:04??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????2786??2016-08-26?16:26??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\Admin\CreateAdmin.java
?????文件????????106??2016-09-11?15:28??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\Admin\DeEncode.java
?????文件???????1740??2016-08-11?15:45??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\Admin\DeleteContent.java
?????文件???????2745??2016-08-19?21:21??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\Admin\LoginAction.java
?????文件???????3922??2016-08-30?14:37??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\assessor\Apply.java
?????文件???????8387??2016-09-28?13:46??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\assessor\ApplyPrint.java
?????文件???????9080??2016-09-20?18:01??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\assessor\ApproveRemind.java
?????文件???????4209??2016-09-20?18:01??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\assessor\CheckInfo.java
?????文件???????4440??2016-08-31?16:33??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\assessor\CheckResult.java
?????文件??????27919??2016-09-28?14:30??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\BorrowerInformation\Borrower.java
?????文件???????6907??2016-09-28?14:30??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\BorrowerInformation\BorrowerHistory.java
?????文件????????866??2016-08-09?12:05??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\BorrowerInformation\ContactsRecord.java
?????文件???????3048??2017-03-03?18:23??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\BorrowerInformation\EditBorrower.java
?????文件???????3127??2016-10-09?11:54??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\BorrowerInformation\MarkCurrentPlace.java
?????文件???????1489??2016-07-15?10:04??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\DBcon\DBconn.java
?????文件???????4842??2016-08-31?16:16??EXCEL與數(shù)據庫互相生成+百度地圖地址轉經緯度\JiaXin\src\com\finance\PrintRecord.java
............此處省略152個文件信息
評論
共有 條評論
川公網安備 51152502000135號