帮我看看为什么会出现这样的错误:错误为:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 0 is out of range.我的代码如下,我用的是 eclipse +sql2000
package db;
import java.io.Console;
import java.sql.*;public class DBConnnection {
public static Connection getConnection()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String connstr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc";
Connection conn=DriverManager.getConnection(connstr,"sa","sa");
return conn;
}catch(Exception e)
{
e.printStackTrace();
return null;
}
}
public static void main(String args[])
{
String sql = "select * from tb_teacher";
Connection conn=DBConnnection.getConnection();
try{
Statement state=conn.createStatement();
ResultSet rs=state.executeQuery(sql);
if (rs.next()) {
rs.getString(0);
conn.close();
}
} catch (SQLException e) {
System.err.print("错误为:" + e);
}
}}
package db;
import java.io.Console;
import java.sql.*;public class DBConnnection {
public static Connection getConnection()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String connstr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc";
Connection conn=DriverManager.getConnection(connstr,"sa","sa");
return conn;
}catch(Exception e)
{
e.printStackTrace();
return null;
}
}
public static void main(String args[])
{
String sql = "select * from tb_teacher";
Connection conn=DBConnnection.getConnection();
try{
Statement state=conn.createStatement();
ResultSet rs=state.executeQuery(sql);
if (rs.next()) {
rs.getString(0);
conn.close();
}
} catch (SQLException e) {
System.err.print("错误为:" + e);
}
}}
解决方案 »
- 上传文件时,通过SmartUpload的Request总是获取不到表单值
- 调试错误,请大家帮忙
- 请教: Axis开发web service客户端的问题
- struts1 form-bean中的seesion问题
- 高分求hibernate+spring事物?????
- 像我这样,该怎么才好呢.来者有分!!!!
- 各位大虾,帮忙看看.真的很郁闷!是一个关于webservice的把控制台应用程序转为java bean的问题!
- java路径获取不到
- Exception occurred during processing request 异常问题
- 九九乘法表1*1 2*2
- Hibernate: 项目部署到服务器后,假如数据库IP和密码需要更改怎么处理?
- 我在网上下载了个项目,里面是用odbc连接的,有几处疑问请大侠近来看看看
rs.getString(0);// 从1开始吧