TextAreax="294"y="70"id="myArea"/>
Buttonx="333"y="196"label="value"click="getvalue();"/>
Script>
[CDATA[
importmx.controls.Alert;
functiongetvalue():
void{
Alert.show(myArea.text);
}
]]>
Script>
Application>
Flex3+java简单的增删查改
(1)数据库连接
packageutil;
importjava.sql.Connection;
importjava.sql.DriverManager;
publicclassDbConnection{
privateStringurl="jdbc:
oracle:
thin:
@192.168.1.66:
1521:
ORCL";
privateStringusername="dhec";
privateStringpassword="dhec";
privateStringdriver="oracle.jdbc.driver.OracleDriver";
privateConnectionconn=null;
publicConnectiongetConnection(){
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,username,password);
}catch(Exceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
returnconn;
}
publicstaticvoidmain(String[]args){
System.out.println(newDbConnection().getConnection());
}
}
(2)实体的编写:
packageentriy;
publicclassCompany{
privateStringrecordId;
privateStringcompanyId;
privateStringcompanyName;
publicStringgetCompanyId(){
returncompanyId;
}
publicvoidsetCompanyId(StringcompanyId){
panyId=companyId;
}
publicStringgetCompanyName(){
returncompanyName;
}
publicvoidsetCompanyName(StringcompanyName){
panyName=companyName;
}
publicStringgetRecordId(){
returnrecordId;
}
publicvoidsetRecordId(StringrecordId){
this.recordId=recordId;
}
}
(3)DAO的编写
packagemyflex;
importjava.sql.Connection;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjava.util.List;
importentriy.Company;
importutil.DbConnection;
publicclassFlexDemo{
Listlist=newArrayList();
Connectionconn=null;
//查找所有
publicListgetAllCompany(){
DbConnectiondb=newDbConnection();
Statementst=null;
ResultSetrs=null;
conn=db.getConnection();
try{
Stringsql="select*fromGGSJ_COMPANY";
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
Companycompany=newCompany();
company.setRecordId(rs.getString
(1));
company.setCompanyId(rs.getString(3));
company.setCompanyName(rs.getString(4));
list.add(company);
}
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}finally{
try{
if(st!
=null){
st.close();
}
if(rs!
=null){
rs.close();
}
if(conn!
=null){
conn.close();
}
}catch(SQLExceptione){
e.printStackTrace();
}
}
returnlist;
}
//删除
publicStringdelCompany(Companycompny){
DbConnectiondb=newDbConnection();
Stringsql="deletefromGGSJ_COMPANYwhereRECORD_ID=?
";
conn=db.getConnection();
PreparedStatementps=null;
try{
ps=conn.prepareStatement(sql);
ps.setString(1,compny.getRecordId());
ps.executeUpdate();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
try{
if(ps!
=null){ps.close();}
if(conn!
=null){conn.close();}
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
return"";
}
//查找单个
publicCompanygetOneCompany(Companycompany){
DbConnectiondb=newDbConnection();
Statementst=null;
ResultSetrs=null;
conn=db.getConnection();
try{
Stringsql="select*fromGGSJ_COMPANYwhereRECORD_ID='"+company.getRecordId()+"'";
st=conn.createStatement();
rs=st.executeQuery(sql);
if(rs.next()){
company.setRecordId(rs.getString
(1));
company.setCompanyId(rs.getString(3));
company.setCompanyName(rs.getString(4));
}
}catch(SQLExceptione){
e.printStackTrace();
}finally{
try{
if(st!
=null){
st.close();
}
if(rs!
=null){
rs.close();
}
if(conn!
=null){
conn.close();
}
}catch(SQLExceptione){
e.printStackTrace();
}
}
returncompany;
}
//修改
publicStringupdate(Companycompany){
DbConnectiondb=newDbConnection();
Stringsql="updateGGSJ_COMPANYsetCOMP