public int getrows(String a)
{
try{
con = this.getConnection();
s = con.createStatement();
rs= s.executeQuery("select count(*) from "+ a);
rs.next();
System.out.println(rs.getInt(1)); //我想取得这个值!!! 怎么取???
}catch(Exception e)
{
e.getMessage();
}
return number;
}
{
try{
con = this.getConnection();
s = con.createStatement();
rs= s.executeQuery("select count(*) from "+ a);
rs.next();
System.out.println(rs.getInt(1)); //我想取得这个值!!! 怎么取???
}catch(Exception e)
{
e.getMessage();
}
return number;
}
{
try{
con = this.getConnection();
s = con.createStatement();
rs= s.executeQuery("select count(*) from "+ a);
rs.next();
//System.out.println(rs.getInt(1)); //我想取得这个值!!! 怎么取???
return rs.getInt(1);
}catch(Exception e)
{
e.getMessage();
}
return -1;
}
*DbConn.java:建立数据库的连接。
*/import java.sql.*;
import java.math.*;public class DbConn {
Connection con;
PreparedStatement stmt;
ResultSet rs;
String driver;
String uri;
Statement s;
static int rows=0; protected DbConn() {
driver = "sun.jdbc.odbc.JdbcOdbcDriver";
uri = "jdbc:odbc:KTV";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
this.con = DriverManager.getConnection(uri);
} catch (Exception e) {
e.printStackTrace();
}
} public Connection getConnection() {
return this.con;
}
public int getrows(String a) //!!!把这个方法改为静态方法~~!!!
{
try{
con = this.getConnection();
s = con.createStatement();
rs= s.executeQuery("select count(*) from "+ a);
rs.next();
DbConn.rows =rs.getInt(1);
}catch(Exception e)
{
e.getMessage();
}
return DbConn.rows;
}
}
拥有这些属性
Connection con;
PreparedStatement stmt;
ResultSet rs;
String driver;
String uri;
Statement s;也拥有这个的静态方法
public int getrows(String a) //!!!把这个方法改为静态方法~~!!!
{
try{
con = this.getConnection();
s = con.createStatement();
rs= s.executeQuery("select count(*) from "+ a);
rs.next();
DbConn.rows =rs.getInt(1);
}catch(Exception e)
{
e.getMessage();
}
return DbConn.rows;
}
package ktv;
import java.sql.*;
public class DDConn {
public static int DDConn(String a) { PreparedStatement stmt;
ResultSet rs;
String driver;
String uri;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:KTV");
Statement s = con.createStatement();
rs = s.executeQuery("select count(*) from "+ a);
rs.next();
return rs.getInt(1); }catch(Exception e)
{
e.getMessage();
}
return -1;
}
}