Java数据库处理的方法库DBUtil

2010年07月16日 13:28 | 分类：测试开发蒋 刚毅

1.postgres数据库的select操作，返回select后返回的第一行数据,返回类型为string,若要返回int,只需将getString改为getInt

public static String PgDBSelect(String sql) throws

ClassNotFoundException, SQLException{

String dbURL=”jdbc:postgresql://172.16.4.25:5432/skyups”; String dbuser=”***”;

String dbpasswd=”***”;

Class.forName(”org.postgresql.Driver”);

Connection conn = DriverManager.getConnection(dbURL,dbuser,dbpasswd); Statement stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_READ_ONLY);

ResultSet rs = stmt.executeQuery(sql);

rs.next();

String value=rs.getString(1);

rs.close();

stmt.close();

conn.close();

return value;

}

2.postgres数据的执行操作，可执行instert、delete、update等操作，不返回数据

public static void PgDBUpdate(String sql) throws ClassNotFoundException, SQLException{

String dbURL=”jdbc:postgresql://172.16.4.25:5432/skyups”; String dbuser=”***”;

String dbpasswd=”***”;

Class.forName(”org.postgresql.Driver”);

Connection conn = DriverManager.getConnection(dbURL,dbuser,dbpasswd); Statement stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

stmt.executeUpdate(sql);

stmt.close();

conn.close();

}