使用E4A(Easy4Android)开发Android应用将数据存储到数据库中,通常采用MySQL数据库。下面介绍E4A如何与MySQL数据库进行连接。
' 导入相应的类库import java.sql.Connectionimport java.sql.DriverManagerimport java.sql.ResultSetimport java.sql.Statement' 定义连接信息dim serverip as string = "192.168.1.2"dim username as string = "root"dim password as string = "123456"dim dbname as string = "test"Dim connectionString As String = "jdbc:mysql://" & serverip & "/" & dbname & "?user=" & username & "&password=" & password & "&useUnicode=true&characterEncoding=UTF8"' 建立连接Dim conn As Connection = DriverManager.getConnection(connectionString)' 执行SQL语句Dim statement As Statement = conn.createStatementDim sql As String = "select * from student"Dim rs As ResultSet = statement.executeQuery(sql)' 处理结果集While rs.nextDim id As Int = rs.getInt("id")Dim name As String = rs.getString("name")Dim age As Int = rs.getInt("age")' 其他操作...End While' 关闭连接rs.Closestatement.Closeconn.Close
以上代码中,我们使用了Java提供的JDBC(Java Database Connectivity)进行连接MySQL数据库,并执行相应的SQL语句,最后关闭连接。其中,需要填写正确的连接信息,包括MySQL数据库的IP地址、用户名、密码和数据库名称。