importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importjava.sql.*;importjava.util.*;publicclassFoundData{/***@para...
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.*;
import java.util.*;
public class FoundData {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Scanner sc = new Scanner(System.in);
System.out.println("请输入姓名:");
String n = sc.nextLine();
System.out.println("姓名:"+n);
String sql="select * from table1 where NAME=n";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Access2000";
Connection con=DriverManager.getConnection(url,"","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
System.out.println(rs.getString("ID")+'\t');
System.out.println(rs.getString("NAME")+'\t');
System.out.println(rs.getString("MATH")+'\t');
System.out.println(rs.getString("AGE")+'\t');
System.out.println(rs.getString("ENGLISH")+'\t');
}else{
System.out.println("不存在该记录! ");}
stmt.close();
con.close();
}
catch(Exception e){}
}
}
为什么不可以根据输入的姓名查询数据库中的内容?程序哪里需要修改?求教
展开