主题:有关数据库的操作
各位高手帮我看看这个程序哪有错,运行没有错但就是没结果,我用的是visual foxpro来创建的数据库
import java.sql.*;
public class Database {
public static void main(String[] args) {
Connection conn=null;
Statement sta=null;
ResultSet rs=null;
//加裁并注册驱动程序
try{
Class.forName("sun.jdbs.odbs.JdbsOdbsDriver");
conn=DriverManager.getConnection("jdbs:odbs:stuDB");
}catch(Exception e){}
//建立与数据库的联接
try{
sta=conn.createStatement();
String sql="select * from 学生成绩表 where 年龄=21";
rs=sta.executeQuery(sql);
while(rs.next())
{
long num=rs.getLong(1);
String name=rs.getString(2);
String sex=rs.getString(3);
int age=rs.getInt(4);
int score=rs.getInt(5);
System.out.print("学号="+num+" ");
System.out.print("姓名="+name+" ");
System.out.print("姓别="+sex+" ");
System.out.print("年龄="+age+" ");
System.out.println("学成绩="+score+" ");
}
}catch(Exception e){}
}
}
import java.sql.*;
public class Database {
public static void main(String[] args) {
Connection conn=null;
Statement sta=null;
ResultSet rs=null;
//加裁并注册驱动程序
try{
Class.forName("sun.jdbs.odbs.JdbsOdbsDriver");
conn=DriverManager.getConnection("jdbs:odbs:stuDB");
}catch(Exception e){}
//建立与数据库的联接
try{
sta=conn.createStatement();
String sql="select * from 学生成绩表 where 年龄=21";
rs=sta.executeQuery(sql);
while(rs.next())
{
long num=rs.getLong(1);
String name=rs.getString(2);
String sex=rs.getString(3);
int age=rs.getInt(4);
int score=rs.getInt(5);
System.out.print("学号="+num+" ");
System.out.print("姓名="+name+" ");
System.out.print("姓别="+sex+" ");
System.out.print("年龄="+age+" ");
System.out.println("学成绩="+score+" ");
}
}catch(Exception e){}
}
}