![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
java连接SQL service2005 祈求大神帮忙看看哪里出问题了,就是不能运行
我稍微修改了下,能出来,由于我没有你代码里的数据库以及驱动,我用我的数据库测试的
隐私的地方我用"*"屏蔽了
package aTest;
import java.sql.*;
public class t {
private Connection con;
public static void main(String[] args) {
t test = new t();
Connection con = test.getConnection();
//注意,你这里的语句是hql语句,sql语句写的是表名而不是对象
String sql = "select * from **_***";
test.getStudent(con, sql);
}
public void getStudent(Connection con,String sql){
try {
Statement st = con.createStatement();
ResultSet result = st.executeQuery( sql);
while(result.next()){
String name1 = result.getString(1);
String code1 = result.getString(2);
String sexy1 = result.getString(3);
String age1 = result.getString(4);
System.out.println("\n姓名:"+name1+"\t学号:"+code1+"\t性别:"+sexy1+"\t年龄:"+age1);
}
st.close();
con.close() ;
}catch(Exception e){
e.printStackTrace();
}
}
public Connection getConnection(){
// String url1 = "jdbc:odbc:schoolmanage";
String url1="jdbc:db2://www.****.com.cn:****/****";//connection.url
String username = "longdage";
String password = "everyday";
try{
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("com.ibm.db2.jcc.DB2Driver");
con = DriverManager.getConnection(url1,username,password); // con
// con = DriverManager.getConnection("jdbc:odbc:sql server"," "," ");
} catch(SQLException e)
{ e.printStackTrace() ;
} catch (ClassNotFoundException ex){
ex.printStackTrace();
}
return con;
}
}
// =
// DriverManager.getConnection("jdbc:odbc:sql
// server","
// ","
// ");
// }
// catch(SQLException
// e) {
// e.printStackTrace()
// ; }
// catch
// (ClassNotFoundException
// ex)
// {
// ex.printStackTrace();
// }
// return
// con;
// }}
你的原因可能出在:
1,驱动错
2.connection。url写错了
3.sql错,
4.用户名密码错
楼主自己排查下看看,
其实你发代码出来附带后台报的错误,可能就好找到错误在哪了
如果觉得小生答的可行,望采纳,谢谢