例子代码
package ycq.connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
public class ConnectionSqlActivity extends Activity {
static Connection conn = null ;
static PreparedStatement pstate=null;
static Statement state = null;
static String dirve="org.postgresql.Driver";
static String url ;
ResultSet rs=null;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
url="jdbc:postgresql://192.168.0.249:5432/yangdb" ;
try{
if(conn==null||conn.isClosed())
{
Class.forName(dirve);
conn = DriverManager.getConnection(url,"yang","888888");
}
pstate=conn.prepareStatement("select * from yang");
rs=pstate.executeQuery();
}catch(Exception e){
e.printStackTrace();
}
//conn.close();
//pstate.close();
}
}
注意权限<uses-permission android:name="android.permission.INTERNET"/>
jdbc是postgresql-9.0-801.jdbc4.jar;
还有就是sdk版本问题,我原来是选择4.0.3的sdk建立工程,结果不能建立连接,后来我又建了个sdk版本为2.2的工程,结果成功了,后来我把sdk为4.0.3版本的那个工程中AndroidManifest.xml中的<uses-sdk android:minSdkVersion="15" />改成<uses-sdk android:minSdkVersion="8" />结果也可以了,
我百度了关于minSdkVersion对应用的影响,没找的为什么,有知道的大牛,麻烦告知下,其他数据库连接可以看 http://blog.csdn.net/conowen/article/details/7435231
package ycq.connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
public class ConnectionSqlActivity extends Activity {
static Connection conn = null ;
static PreparedStatement pstate=null;
static Statement state = null;
static String dirve="org.postgresql.Driver";
static String url ;
ResultSet rs=null;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
url="jdbc:postgresql://192.168.0.249:5432/yangdb" ;
try{
if(conn==null||conn.isClosed())
{
Class.forName(dirve);
conn = DriverManager.getConnection(url,"yang","888888");
}
pstate=conn.prepareStatement("select * from yang");
rs=pstate.executeQuery();
}catch(Exception e){
e.printStackTrace();
}
//conn.close();
//pstate.close();
}
}
注意权限<uses-permission android:name="android.permission.INTERNET"/>
jdbc是postgresql-9.0-801.jdbc4.jar;
还有就是sdk版本问题,我原来是选择4.0.3的sdk建立工程,结果不能建立连接,后来我又建了个sdk版本为2.2的工程,结果成功了,后来我把sdk为4.0.3版本的那个工程中AndroidManifest.xml中的<uses-sdk android:minSdkVersion="15" />改成<uses-sdk android:minSdkVersion="8" />结果也可以了,
我百度了关于minSdkVersion对应用的影响,没找的为什么,有知道的大牛,麻烦告知下,其他数据库连接可以看 http://blog.csdn.net/conowen/article/details/7435231