请教各位高手,这里result里的结果如果要被别的包里的类引用,改怎么实现?谢谢各位。
public static void main(String[] args) throws Exception {
String sql="SELECT StuID,SEX,GRADE FROM student WHERE StuID = 1";
String id,sex;
int grade
Connection conn = null; //数据库的连接的对象
Statement stmt = null; //数据库更新操作
ResultSet result = null; //数据库查询结果
Class.forName(DRIVER); //使用Class类加载程序驱动
conn=DriverManager.getConnection(URL, USER, PASS); //连接数据库
stmt=conn.createStatement(); //Statement接口需要通过Connection接口进行实例化操作
result=stmt.executeQuery(sql);
while(result.next()){
id=result.getString(1);
sex=result.getString(2);
grade=result.getInt(3);
System.out.print("学号="+id);
System.out.print(" 性别="+sex);
System.out.println(" 成绩="+grade);
}
result.close();
stmt.close();
conn.close();
}
public static void main(String[] args) throws Exception {
String sql="SELECT StuID,SEX,GRADE FROM student WHERE StuID = 1";
String id,sex;
int grade
Connection conn = null; //数据库的连接的对象
Statement stmt = null; //数据库更新操作
ResultSet result = null; //数据库查询结果
Class.forName(DRIVER); //使用Class类加载程序驱动
conn=DriverManager.getConnection(URL, USER, PASS); //连接数据库
stmt=conn.createStatement(); //Statement接口需要通过Connection接口进行实例化操作
result=stmt.executeQuery(sql);
while(result.next()){
id=result.getString(1);
sex=result.getString(2);
grade=result.getInt(3);
System.out.print("学号="+id);
System.out.print(" 性别="+sex);
System.out.println(" 成绩="+grade);
}
result.close();
stmt.close();
conn.close();
}