java连不上数据库 高分悬赏

Question

package lalala;import java.sql.*;public class test027 { public static void main(String args[]) { Connection connect_sql = null; Statement state_sql = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connect_sql = DriverManager.getConnection("jdbc:odbc:Aaron_SQL_Server"); state_sql = createStatement(); //连接数据库的基本代码 ResultSet result_sql = state_sql.executeQuery("select * from revenue"); while(result_sql.next()) { String school = result_sql.getString(1); //数据库第一列 String name = result_sql.getString(2); //数据库第二列 String weapon = result_sql.getString(3); //数据库第三列 String duty = result_sql.getString(4); //数据库第四列 System.out.println(school + " " + name + " " + weapon + " " + duty); } }catch(Exception e) { System.out.println("出错啦"); } finally { try { if(state_sql != null) { state_sql.close(); } if(connect_sql != null) { connect_sql.close(); } }catch(Exception e2) { } } } private static Statement createStatement() { // TODO Auto-generated method stub return null; }}SQL是用windows登陆的没有密码
下图为数据库截图

解决追加100

Answer 1

报什么错误！
再说SqlServer 不应这么写吗：Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//SQL Server 2008的URL
String url="jdbc:sqlserver://localhost:1433;databasename=Student";追问

能跟您QQ交流么 按您说的改了 还是不行