java索引 2 超出范围_java中动态执行SQL语句报错：索引2超出范围，求大神指导~...

java中动态执行SQL语句报错：索引2超出范围，求大神指导~

报错：添加了1条记录到student表中

com.microsoft.sqlserver.jdbc.SQLServerException: 索引 2 超出范围。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:698)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:707)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setString(SQLServerPreparedStatement.java:1015)

at dblx.Sjk1_3.main(Sjk1_3.java:40)

package dblx;

import java.sql.*;

public class Sjk1_3 {

private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static String url="jdbc:sqlserver://neverAgain\\neverAgain:1433;DatabaseName=Myschool";

private static String user="sa";

private static String password="111111";

public static void main(String[] args)

{

Connection conn=null;

PreparedStatement ps=null;

ResultSet rs=null;

String selectsql="select * from Student where Sex=?";

String insertsql="insert into Student(Sno,Sname,Sex,Sage)"+

"values(?,?,?,?);";

String updatesql="update Student set Sno='1410030014' where Sname=?";

String deletesql="delete from Student where Sno=?";

try{

Class.forName(driver);

conn=DriverManager.getConnection(url,user,password);

ps=conn.prepareStatement(selectsql);

ps.setString(1,"女");

rs=ps.executeQuery();

while(rs.next()){

String no=rs.getString("Sno");

String name=rs.getString("Sname");

String sex=rs.getString("Sex");

String age=rs.getString("Sage");

System.out.println(no+""+name+""+sex+""+age);

}

ps=conn.prepareStatement(insertsql);

ps.setString(1, "1410030006");

ps.setString(2, "李明");

ps.setString(3, "男");

ps.setString(4,"13");

int count=ps.executeUpdate();

System.out.println("添加了"+count+"条记录到student表中");

ps=conn.prepareStatement(updatesql);

ps.setString(2, "李四");

count=ps.executeUpdate();

System.out.println("更新了"+count+"条记录到student表中");

//            ps=conn.prepareStatement(deletesql);

//            ps.setString(1,"1410030001");

//            count=ps.executeUpdate();

//            System.out.println("删除了"+count+"条记录到student表中");

}

catch(Exception e){

e.printStackTrace();

}

finally{

try{

if(rs!=null)rs.close();

if(ps!=null)ps.close();

if(conn!=null)conn.close();

}

catch(Exception e)

{

e.printStackTrace();

}

}

}

}

搜索更多相关主题的帖子:

java　动态　记录