求助 com.microsoft.sqlserver.jdbc.SQLServerException: 索引 0 超出范围。
public class sqlserver {
private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 连接驱动
private static final String URL = "jdbc:sqlserver://localhost:1433; DatabaseName=myway";// 访问sqlserver路径
private static final String userName = "sa";// 访问用户名
private static final String passWord = "sa";// 访问的密码
private static Connection conn;
// private static PreparedStatement ps;
// private static ResultSet rs;
static{
try {
Class.forName(DRIVER); //1.加载连接的驱动
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
}
}
public Connection getConn() {
try {
if(conn == null)
{
conn = DriverManager.getConnection(URL, userName, passWord);
}
if (!(conn == null)) {
}else {
}
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
return conn;
}
}
sqlserver mySqlServer = new sqlserver();
Connection conn = mySqlServer.getConn();
public List myFind() {
// TODO Auto-generated method stub
StringBuilder sb = new StringBuilder();
sb.append("select * from myuser") ;
String sql;
List mylist=null;
sql = sb.toString();
try {
PreparedStatement pst = conn.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
mylist.add(rs.getObject(0));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return mylist;
}